Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE integration with web services

Question
24
Views
0
Comments
user5108636
user5108636 Rank 1 - Community Starter


I am trying to access a report in OBIEE through the SAWSessionService by passing a username and password for which I get a sessionID back. Next I use this sessionID to the executeIBotNow method of the IBotService using SOAPUI

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v7="urn://oracle.bi.webservices/v7">

   <soapenv:Header/>

   <soapenv:Body>

      <v7:executeIBotNow>

         <v7:path>/shared/reports/_portal/Sample Products</v7:path>

         <v7:sessionID>vc0b1jhje3hsge61p4ees3eq1l9dnrp8jt8r56x</v7:sessionID>

      </v7:executeIBotNow>

   </soapenv:Body>

</soapenv:Envelope>

which returns an error.

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:saw-SOAP="com.siebel.analytics.web/soap/v6">

   <soap:Body>

      <soap:Fault>

         <faultcode>soap:Server</faultcode>

         <faultstring>Object expected: /shared/Real Time Reporting/_portal/CAD Units Diverted</faultstring>

         <detail>

            <sawsoape:Error xmlns:sawsoape="com.siebel.analytics.web/soap/error/v1">

               <sawsoape:Code>GCARFLCS</sawsoape:Code>

               <sawsoape:Message>Object expected: >/shared/reports/_portal/Sample Products</sawsoape:Message>

               <sawsoape:File>project/websoapservices/ibotservice.cpp</sawsoape:File>

               <sawsoape:Line>445</sawsoape:Line>

               <sawsoape:LogSources>

                  <sawsoape:LogSource>saw.soap.ibotservice</sawsoape:LogSource>

                  <sawsoape:LogSource>saw.SOAP</sawsoape:LogSource>

                  <sawsoape:LogSource>saw.httpserver.request.soaprequest</sawsoape:LogSource>

                  <sawsoape:LogSource>saw.rpc.server.responder</sawsoape:LogSource>

                  <sawsoape:LogSource>saw.rpc.server</sawsoape:LogSource>

                  <sawsoape:LogSource>saw.rpc.server.handleConnection</sawsoape:LogSource>

                  <sawsoape:LogSource>saw.rpc.server.dispatch</sawsoape:LogSource>

                  <sawsoape:LogSource>saw.threadpool.socketrpcserver</sawsoape:LogSource>

                  <sawsoape:LogSource>saw.threads</sawsoape:LogSource>

               </sawsoape:LogSources>

            </sawsoape:Error>

         </detail>

      </soap:Fault>

   </soap:Body>

</soap:Envelope>

Please suggest, how to get around this. Also, if anyone can suggest how to look for a report properties and get the path of report.

Thanks in advance.