Oracle Analytics Cloud and Server

Products Banner

Data Model shows - Failed to Load XML when All is selected in the prompts.

Received Response
33
Views
2
Comments

Summary

when selected All in all the prompts - Data Model shows - Failed to Load XML and inturn Report is failing.

Content

Hi Gurus,

I've a report which works fine with manual selection of values for the prompts. But when I enable 'Can Select All - All Values Passed'  Data Model is throwing error - Failed to load XML.

Total Number of Prompts are 9

MY BIP Version 11.1.1.7.150120

and this is Engine log that is generated.

<?xml version="1.0" encoding="UTF-8"?>
<debugLog>
<msg time='2018-08-09T14:58:28.110-04:00' comp_id='bi_server1' type='WARNING' level='1' host_id='amsstsrtp2' host_addr='10.95.58.143' module='oracle.xdo' tid='117' user='&lt;anonymous>' ecid='005SkKqN80U1Vcx_s9WByX0006T5001A64' rid='0:1'>
 <attr name='APP' value='bipublisher#11.1.1'/>
 <txt>XMLGEN:Exception while processing...:_ICE_History_Reports_List_History_Report_List_History_Data_Model_xdm</txt>
</msg>
<msg time='2018-08-09T14:58:28.111-04:00' comp_id='bi_server1' type='WARNING' level='1' host_id='amsstsrtp2' host_addr='10.95.58.143' module='oracle.xdo' tid='117' user='&lt;anonymous>' ecid='005SkKqN80U1Vcx_s9WByX0006T5001A64' rid='0:1'>
 <attr name='APP' value='bipublisher#11.1.1'/>
 <txt>java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
 
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
at oracle.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1896)
at oracle.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:522)
at oracle.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:437)
at oracle.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:338)
at oracle.xdo.dataengine.XMLPGEN.writeXMLDataStructure(XMLPGEN.java:271)
at oracle.xdo.dataengine.XMLPGEN.processDataSet(XMLPGEN.java:1787)
at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1490)
at oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:376)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:318)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:672)
at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:297)
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:407)
at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:101)
at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1142)
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:661)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:492)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:462)
at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:261)
at oracle.xdo.servlet.XDOServlet.doPost(XDOServlet.java:313)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:64)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:127)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
</txt>
</msg>
</debugLog>
 
 
 
 
Please let me know is there any work around for this.
 
Thank you.

Answers

  • FPonte
    FPonte ✭✭✭✭✭

    Hi Bhanu.

    The issue is clear. You are passing to many values as parameters.

    Try the following construction.

    1. Modify your parameter to pass NULL when ALL is selected.

    2. Modify you WHERE clause to work with the NULL this way.

                   WHERE (<table_column> in (<yourparametername>) or (<yourparametername> is null))

    Save and let us know the results.

    Best Regards.

    Fernando

  • Perfect!!

    It worked.

    Thank you so much Fernando.