Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

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

Received Response
31
Views
2
Comments
BHANU PRAKASH CHUNDURI
BHANU PRAKASH CHUNDURI Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

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.
Tagged:

Answers

  • FPonte
    FPonte Rank 6 - Analytics Lead

    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

  • BHANU PRAKASH CHUNDURI
    BHANU PRAKASH CHUNDURI Rank 3 - Community Apprentice

    Perfect!!

    It worked.

    Thank you so much Fernando.