Oracle Analytics Cloud and Server

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

BIP 12.2.1 - oracle.xdo.servlet.data.DataException: Invalid parameters requested

Received Response
181
Views
1
Comments

Summary

BIP 12.2.1 - oracle.xdo.servlet.data.DataException: Invalid parameters requested

Content

Hi

I am trying to schedule a report which has paramter value as <>  (<item>&lt;&gt;</item>)

However I get the below error only when scheduling.

However I am able to generate the report directly from BIP without any issues.

Invalid parameters requested.

  • oracle.xdo.servlet.data.DataException: Invalid parameters requested.

                at oracle.xdo.servlet.ReportImpl.renderReportXML(ReportImpl.java:804)

                at oracle.xdo.enterpriseScheduler.bursting.BurstingJobProcessor.getReportData(BurstingJobProcessor.java:640)

                at oracle.xdo.enterpriseSch

Please let me know if anyone of you faced similar issue.

SOAP Request:- (few details omitted to keep it simple )

-[HTTP request - http://<ip>:<port>/xmlpserver/services/v2/ScheduleService]---

Accept: text/xml, multipart/related, text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2

Content-type: text/xml;charset="utf-8"

                                                                                                        <parameterNameValues>                                                                                                        <listOfParamNameValues>                                                                                                            <item>                                                                                                                <UIType                                                                                                                    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>                                                                                                                    <dataType                                                                                                                        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>                                                                                                                        <dateFormatString                                                                                                                            xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>                                                                                                                            <dateFrom                                                                                                                                xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>                                                                                                                                <dateTo                                                                                                                                    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>                                                                                                                                    <defaultValue                                                                                                                                        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>                                                                                                                                        <fieldSize                                                                                                                                            xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>                                                                                                                                            <label                                                                                                                                                xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>                                                                                                                                                <lovLabels                                                                                                                                                    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>                                                                                                                                                    <multiValuesAllowed>false</multiValuesAllowed>                                                                                                                                                    <name>code</name>                                                                                                                                                    <refreshParamOnChange>false</refreshParamOnChange>                                                                                                                                                    <selectAll>false</selectAll>                                                                                                                                                    <templateParam>false</templateParam>                                                                                                                                                    <useNullForAll>false</useNullForAll>                                                                                                                                                    <values>                                                                                                                                                        <item>&lt;&gt;</item>                                                                                                                                                    </values>                                                                                                                                                </item>                                                                                                                                            </listOfParamNameValues>                                                                                                                                        </parameterNameValues>

SOAP Response:- (few details omitted to keep it simple)

--[HTTP response - http:/ip:port/xmlpserver/services/v2/ScheduleService - 200]---

null: HTTP/1.1 200 OK

Date: Tue, 13 Jun 2017 08:39:35 GMT

Transfer-encoding: chunked

X-oracle-dms-ecid: 43305de0-523f-4a73-81b1-1e6c62d645cb-000024e1

Content-type: text/xml; charset=utf-8

<?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>        <getScheduledJobInfoInSessionResponse            xmlns="http://xmlns.oracle.com/oxp/service/v2">            <getScheduledJobInfoInSessionReturn>                               <reportParameters>{report_params={&quot;p_proj_code&quot;:&quot;\u003c\u003e&quot;}}</reportParameters>                           </getScheduledJobInfoInSessionReturn>        </getScheduledJobInfoInSessionResponse>    </soapenv:Body></soapenv:Envelope>

Answers