1 Reply Latest reply on Nov 10, 2014 8:50 AM by Gregor

    PI Tree View webpart and PI table webpart (query from Oracle DB)

    Srinivas

      Hi ,

       

      I am trying to pass the connection parameter from Tree view webpart to PI table webpart which is getting the data from oracle database using oracle (Microsoft provider) driver...  When I tried to establish the connection between webparts , PI webparts is not enabled..

       

       

       

      Did any of you ever come across this? For another PI table webparts which is getting the data from the SQL Server , there I am able to connect and pass the parameters from treeview seleciton to filter the values dynamically..

       

       

       

      Anyone have any idea why it is not happening for oracle query..

       

       

       

       

       

       

       

      Regards,

       

      Srinivas

        • Re: PI Tree View webpart and PI table webpart (query from Oracle DB)

          Hello Srinivas,

           

          I suggest starting simple. Please try first to display data from Oracle in a PI table without any query parameters from a PI TreeView web part. Does that work?

           

          If not, you should be looking into possible issues with your connection against Oracle. If this doesn't work please try using another client but the same provider on the same machine to execute a query. If this works, the issue can be security related i.e. the application pool identity not having appropriate rights to access tables / views in Oracle. Please check log files on the Oracle client and server for ORA-XXXXX messages pointing to the root cause of the problem.

           

          Answers to the following questions could help to identify any known restrictions.

           

          What's the Oracle server version?

           

          What  the Oracle client version installed?

           

          What the exact name and version of the provider used?

           

          Is this an OLEDB or an ODBC driver?