BI Publisher: Cannot run report with web service

Imad Ikhouane

Summary

BI Publisher: Cannot run report with web service

Content

Hi All

I cannot call a run report from web service. I'm trying to test with SoapUi

Absolute path: /SiebelCRMReports/test.xdo

SoapUI test:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2">

   <soapenv:Header/>

   <soapenv:Body>

      <v2:runReport>

         <v2:reportRequest>

            <v2:attributeCalendar>Gregorian</v2:attributeCalendar>

            <v2:attributeFormat>pdf</v2:attributeFormat>

            <v2:attributeLocale>fr-CH</v2:attributeLocale>

            <v2:attributeTemplate>test.rtf</v2:attributeTemplate>

            <v2:attributeTimezone>America/Los_Angeles</v2:attributeTimezone>

            <v2:attributeUILocale>fr-CH</v2:attributeUILocale>

            <v2:byPassCache>True</v2:byPassCache>

            <v2:flattenXML>False</v2:flattenXML>

            <v2:reportAbsolutePath>/SiebelCRMReports/test.xdo</v2:reportAbsolutePath>

            <v2:reportData>cid:358389474709</v2:reportData>

            <v2:sizeOfDataChunkDownload>-1</v2:sizeOfDataChunkDownload>

         </v2:reportRequest>

         <v2:userID>user1</v2:userID>

         <v2:password>password11</v2:password>

      </v2:runReport>

   </soapenv:Body>

</soapenv:Envelope>

SoapUI result:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

   <soapenv:Body>

      <soapenv:Fault>

         <faultcode>soapenv:Server.userException</faultcode>

         <faultstring>oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReport for reportAbsolutePath [/SiebelCRMReports/test.xdo] failed: due to oracle.xdo.server.ServerException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.lang.reflect.InvocationTargetException</faultstring>

         <detail>

            <oracle.xdo.webservice.exception.OperationFailedException/>

            <ns1:hostname xmlns:ns1="http://xml.apache.org/axis/">hostname</ns1:hostname>

         </detail>

      </soapenv:Fault>

   </soapenv:Body>

</soapenv:Envelope>

The Absolute path is correct.

Any idea ?

Thank you for you help

Regards

Imad

Imad Ikhouane

Hi All

Removed the line

v2:reportData>cid:358389474709</v2:reportData>

and it works

Thank you

Regards

Imad Ikhouane