1 Reply Latest reply: Dec 17, 2012 11:11 AM by ptravassos RSS

    Error while calling BI Publisher 11g webservice.URGENT

    mike621062
      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
          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