This discussion is archived
1 Reply Latest reply: Dec 17, 2012 9:11 AM by ptravassos RSS

Error while calling BI Publisher 11g webservice.URGENT

mike621062 Newbie
Currently Being Moderated
I am trying to schedule existing report and pass parameter using web service API.

This is soap envelope I am passing in the web service call:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<pub:scheduleReport xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService">
<scheduleRequest>
<deliveryChannels>
<emailOptions>
<emailBody>webservice test</emailBody>
<emailFrom>info@arrow.com</emailFrom>
<emailSubject>test report</emailSubject>
<emailTo>xxx</emailTo>
</emailOptions>
</deliveryChannels>
<reportRequest>
<attributeFormat>excel2000</attributeFormat>
<reportAbsolutePath>/~weblogic/List of Requests 3.xdo</reportAbsolutePath>
<*paramNameValues>*
*<paramNameValue>*
*<name>P_REQUEST_ID</name>*
*<multiValuesAllowed>false</multiValuesAllowed>*
*<values>*
*<value>166</value>*
*</values>*
*</paramNameValue>*
*</paramNameValues>*
</reportRequest>
<userJobName>test_job</userJobName>
</scheduleRequest>
<userID>test</userID>
<password>test123</password>
</pub:scheduleReport>
</soapenv:Body>
</soapenv:Envelope>

This is the response I am getting as the result of the call:

<?xml version="1.0" encoding="UTF-8"?>
<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>org.xml.sax.SAXException: Invalid element in oracle.xdo.webservice.v2.ReportRequest - paramNameValues</faultstring>
<detail><ns1:hostname xmlns:ns1="http://xml.apache.org/axis/">xxx</ns1:hostname></detail></soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>

So error message says: org.xml.sax.SAXException: Invalid element in oracle.xdo.webservice.v2.ReportRequest - paramNameValues

I think there is a problem with the format of ParamNameValues, just don't know what exactly is the problem.

Any ideas ?

Thanks

Mikhail

Edited by: mike621062 on Nov 30, 2012 12:59 PM

Edited by: mike621062 on Nov 30, 2012 1:00 PM

Edited by: mike621062 on Nov 30, 2012 1:00 PM

Edited by: mike621062 on Nov 30, 2012 4:27 PM

Edited by: mike621062 on Dec 1, 2012 9:10 AM
  • 1. Re: Error while calling BI Publisher 11g webservice.URGENT
    ptravassos Newbie
    Currently Being Moderated
    Hi, double check the documentation.

    I have the following elements to pass a parameter value:

         <sch:parameterNameValues>
                        <sch:listOfParamNameValues>
                             <sch:item>
                                  <sch:multiValuesAllowed>false</sch:multiValuesAllowed>
                                  <sch:name>g_SortBy</sch:name>
                                  <sch:refreshParamOnChange>false</sch:refreshParamOnChange>
                                  <sch:selectAll>false</sch:selectAll>
                                  <sch:templateParam>false</sch:templateParam>
                                  <sch:useNullForAll>false</sch:useNullForAll>
                                  <sch:values>
                                       <sch:item>C</sch:item>
                                  </sch:values>
                             </sch:item>
                        </sch:listOfParamNameValues>
         </sch:parameterNameValues>

    paulo.

    p.s. Ignore the XML namespace prefix sch: in my example.

    Edited by: ptravassos on Dec 17, 2012 9:10 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points