Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BI Publisher 12c Error : Failed to load xml in Data model (view data)
Summary
BI Publisher 12c Error : Failed to load xml in Data model (view data)
Content
Hi All,
I am trying to create data model using simple sql query (configured JDBC connection) and when I am clicking the view data ,am getting error as "failed to load XML " due to this I am unable to create report and was not able to click save as sample data.
I am to see data in query builder for the same query but in view data I am unable to see xml (I selected 5 rows)
Please help me to resolve the issue
Answers
-
^ what does the output here say?
0 -
[180115_11150016][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]XMLGEN:Exception while processing datamodel...:_PCLS_BI_BI_Publisher_Sample_Data_Model___CCL_xdm
[180115_11150016][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Process Cancelled Stage:false
[180115_11150016][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]XMLPGEN:java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
ORA-01031: insufficient privileges - Database is telling you you are trying to do something without having the correct privileges associated with your login credentials
0 -
Hi Thomas ,
Thanks for your reply.
I am able to see data in query builder but no in view data.
Please find below view Engine log information and let me know if you find any error information (Actually , I am unable to find anything)
<?xml version="1.0" encoding="UTF-8"?>
<!--Generated by Oracle BI Publisher 12.2.1.2.0 -Dataengine, datamodel:_PCLS_BI_BI_Publisher_Sample_Data_Model___CCL_xdm -->
-<DIAGNOSTIC_OUT>
-<DATA_PROCESSOR_LOG>
-<![CDATA[
Data Processor debug log
================================================================
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Initializing DateFormatter for thread id:Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]:MapSize:5
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Initializing DecimalFormatter for thread id:Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]:MapSize:0
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]server_temp_dir=/qmrtsbx/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1/to5gma/public/xdo/tmp/
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Storing Session thread :Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads] : for id:oxIwt1kKMa1516086915811
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Start Datamodel parsing ..SessionId:oxIwt1kKMa1516086915811
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]DataModel parsing started...
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Oracle XML Parser version : Oracle XML Developer's Kit 12.2.1.2.0 - Production
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Data Model ......
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Inside properties Parser...
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Inside dataQueryParser...
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Inside dataStructureParser...
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Group ...report
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Group ...G_1
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Inside triggerParser...
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Inside parameterParser...
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]DataModel parsing completed....
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Setting Data Model ...
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Setting Parameters ...
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Setting Data sets Connections...
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Initializing DateFormatter for thread id:Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]:MapSize:5
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Initializing DecimalFormatter for thread id:Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]:MapSize:0
[180115_11150015][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Start Datamodel processing ..SessionId:oxIwt1kKMa1516086915811
[180115_11150016][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Exception while setting SQLSessionTrace:r_Sample_Data_Model___CCL_xdm_180115_1115
[180115_11150016][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:218)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:31)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2168)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2100)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:363)
at oracle.xdo.dataengine.util.SQLUtil.setTraceOn(SQLUtil.java:383)
at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1673)
at oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:385)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:310)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:687)
at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:333)
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:528)
at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:113)
at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1418)
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:890)
at oracle.xdo.servlet.resources.ReportItemServiceImpl.runSynch(ReportItemServiceImpl.java:214)
at oracle.xdo.servlet.resources.ReportItemServiceImpl.run(ReportItemServiceImpl.java:196)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:529)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:498)
at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:279)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:74)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:229)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:141)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:124)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:232)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:32)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3683)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3649)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2433)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2281)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2259)
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1691)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1651)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:270)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:640)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:406)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
[180115_11150016][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]XMLGEN:Exception while processing datamodel...:_PCLS_BI_BI_Publisher_Sample_Data_Model___CCL_xdm
[180115_11150016][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Process Cancelled Stage:false
[180115_11150016][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]XMLPGEN:java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
[180115_11150016][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]java.sql.SQLException: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
at oracle.xdo.dataengine.util.SQLUtil.setTraceOn(SQLUtil.java:390)
at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1673)
at oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:385)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:310)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:687)
at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:333)
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:528)
at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:113)
at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1418)
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:890)
at oracle.xdo.servlet.resources.ReportItemServiceImpl.runSynch(ReportItemServiceImpl.java:214)
at oracle.xdo.servlet.resources.ReportItemServiceImpl.run(ReportItemServiceImpl.java:196)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:529)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:498)
at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:279)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:74)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:229)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:141)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:124)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:232)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:32)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3683)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3649)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2433)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2281)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2259)
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1691)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1651)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:270)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:640)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:406)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:218)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:31)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2168)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2100)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:363)
at oracle.xdo.dataengine.util.SQLUtil.setTraceOn(SQLUtil.java:383)
... 59 more
[180115_11150016][DATA PROCESSOR ID:1704132772][SCH JOB INFO:] Start Datamodel diagnostic details..
======================================================================
Datamodel name: _PCLS_BI_BI_Publisher_Sample_Data_Model___CCL_xdm
Processing mode: online
Calling module:
StringList: 2
Cache SQL Rowset: false
Allow DB Modifications: false
Is DM Customized: false
Output format: 1
Auto db Fetchsize enabled: true
Default db Fetchsize : 20
SQL Query Timeout : 600
Olnine SQL Query Timeout : 500
Offline SQL Query Timeout : 3600
XML data size limit: 314572800
XML Sample data size limit: 1048576
Processed with Scalable mode enabled: true
Track xml size enabled: true
SQL Session Trace enabled: true
SQL Session Trace File:
SQL Query Pruning enabled: true
Is Layout Elements passed: false
Layout Elements size: 0
Webservice timeout: 1800
Debug Mode: false
Estimate XML DataSize: false
Generate Output XML: true
DataSet Name:report
Number of elements:0
Total Query Execution time (ms):0
DataSet Name:Parameters
Number of elements:0
Total Query Execution time (ms):0
DataSet Name:Triggers
Number of elements:0
Total Query Execution time (ms):0
DataSet Name:Sample Data Model - CCL
DataSet Type:sql
DataSet DB fetch size:100
DataSet Query Timeout:600
Total Number Of Times Query Executed:0
Total Number Of Rows Processed:0
Number of elements:5
Total Query Execution time (ms):0
------------------------------------------------------------------------
Total Number of Datasets: 4
Total Number of Elements: 5
Total Parse Time (ms): 0
Total Used Memory at Start: 977.03 MB
Total Used Memory after Parsing: 977.59 MB
Total Used Memory after Processing: 979.60 MB
Total Query Execution Time: 0 mseconds
Total Data Generation Time: 41 mseconds
Total XML Data Size Generated: 0
Processing Exceptions: java.sql.SQLException: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
at oracle.xdo.dataengine.util.SQLUtil.setTraceOn(SQLUtil.java:390)
at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1673)
at oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:385)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:310)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:687)
at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:333)
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:528)
at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:113)
at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1418)
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:890)
at oracle.xdo.servlet.resources.ReportItemServiceImpl.runSynch(ReportItemServiceImpl.java:214)
at oracle.xdo.servlet.resources.ReportItemServiceImpl.run(ReportItemServiceImpl.java:196)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:529)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:498)
at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:279)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:74)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:229)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:141)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:124)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:232)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:32)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3683)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3649)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2433)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2281)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2259)
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1691)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1651)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:270)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:640)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:406)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:218)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:31)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2168)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2100)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:363)
at oracle.xdo.dataengine.util.SQLUtil.setTraceOn(SQLUtil.java:383)
... 59 more
======================================================================
End Datamodel diagnostic details..
[180115_11150016][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Removed Session thread :Thread[[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads] : for id:oxIwt1kKMa1516086915811
]]>
</DATA_PROCESSOR_LOG>
</DIAGNOSTIC_OUT>
0 -
Below is the output of View Engine Log:
<?xml version="1.0" encoding="UTF-8"?>
<!--Generated by Oracle BI Publisher 12.2.1.2.0 -Dataengine, datamodel:_PCLS_BI_BI_Publisher_Test__BI_Data_Model___OBIEE_Report_as_Source_xdm -->
-<DIAGNOSTIC_OUT>
-<DATA_PROCESSOR_LOG>
-<![CDATA[
Data Processor debug log
================================================================
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Initializing DateFormatter for thread id:Thread[[ACTIVE] ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]:MapSize:5
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Initializing DecimalFormatter for thread id:Thread[[ACTIVE] ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]:MapSize:0
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]server_temp_dir=/qmrtsbx/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1/to5gma/public/xdo/tmp/
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Storing Session thread :Thread[[ACTIVE] ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads] : for id:Gs0isguxZN1516080794644
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Start Datamodel parsing ..SessionId:Gs0isguxZN1516080794644
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]DataModel parsing started...
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Oracle XML Parser version : Oracle XML Developer's Kit 12.2.1.2.0 - Production
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Data Model ......
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Inside properties Parser...
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Inside dataQueryParser...
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Inside dataStructureParser...
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Group ...report
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Group ...G_2
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Inside triggerParser...
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Inside parameterParser...
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]DataModel parsing completed....
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Setting Data Model ...
[180115_09330014][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Setting Parameters ...
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Setting Data sets Connections...
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Initializing DateFormatter for thread id:Thread[[ACTIVE] ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]:MapSize:5
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Initializing DecimalFormatter for thread id:Thread[[ACTIVE] ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]:MapSize:0
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Start Datamodel processing ..SessionId:Gs0isguxZN1516080794644
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Executing PARAMETER triggers...
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Executing BEFORE REPORT triggers...
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Start process Data Structure ..
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Parameter name -> values for processing..
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]XDO_USER_NAME->c_bchapp
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]XDO_USER_ROLES->BIAdministrator, BIConsumer, BIAuthor
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]XDO_USER_UI_LOCALE->en
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]XDO_USER_UI_ORACLE_LANG->US
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]XDO_USER_REPORT_LOCALE->en_US
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]XDO_USER_REPORT_ORACLE_LANG->US
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]XDO_DASHBOARD_EXPR->null
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]FUSION_SECURITY_ENABLED->false
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]FUSION_ESS_APPLSESSION_ID->
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]TimeZone Details:
User Preference time zone selected:sun.util.calendar.ZoneInfo[id="Africa/Casablanca",offset=0,dstSavings=3600000,useDaylight=true,transitions=100,lastRule=java.util.SimpleTimeZone[id=Africa/Casablanca,offset=0,dstSavings=3600000,useDaylight=true,startYear=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=10800000,endTimeMode=0]]
Java SimpleDateFormat with no timezone set:2018-01-15 09:33:15.033-080021
JVM Java.Util.Timezone:sun.util.calendar.ZoneInfo[id="US/Pacific",offset=-28800000,dstSavings=3600000,useDaylight=true,transitions=185,lastRule=java.util.SimpleTimeZone[id=US/Pacific,offset=-28800000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,endTime=7200000,endTimeMode=0]]
Java SimpleDateFormat with JVM timezone:2018-01-15 09:33:15.033-080021
FND Cononical Date Format with JVM timezone:2018-01-15T21:33:15.614-08:00
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Writing Data ...
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Number of queries :1
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Returning Final Query from QueryParser:
select "CL_GROUP_TYPE"."CL Group Name" as "CL Group Name"
from "CCL"."CL_GROUP_TYPE" "CL_GROUP_TYPE" ;
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]DataSet Name:bbbbbvvvvvvvvvvv: DB Fetch Size: 100
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]DataSet Name:bbbbbvvvvvvvvvvv: SQL Query Timeout: 500
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]DataSet Name:bbbbbvvvvvvvvvvv: SQL Query :bbbbbvvvvvvvvvvv: select "CL_GROUP_TYPE"."CL Group Name" as "CL Group Name"
from "CCL"."CL_GROUP_TYPE" "CL_GROUP_TYPE" ;
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Complete process Data Structure ..
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Executing AFTER REPORT triggers...
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Data Generation Completed...
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Total Data Generation Time: 0.0 seconds
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Total Estimated XML Data size: 447
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:] Start Datamodel diagnostic details..
======================================================================
Datamodel name: _PCLS_BI_BI_Publisher_Test__BI_Data_Model___OBIEE_Report_as_Source_xdm
Processing mode: online
Calling module:
StringList: 2
Cache SQL Rowset: false
Allow DB Modifications: false
Is DM Customized: false
Output format: 1
Auto db Fetchsize enabled: true
Default db Fetchsize : 20
SQL Query Timeout : 600
Olnine SQL Query Timeout : 500
Offline SQL Query Timeout : 3600
XML data size limit: 314572800
XML Sample data size limit: 1048576
Processed with Scalable mode enabled: true
Track xml size enabled: true
SQL Session Trace enabled: false
SQL Session Trace File:
SQL Query Pruning enabled: true
Is Layout Elements passed: false
Layout Elements size: 0
Webservice timeout: 1800
Debug Mode: false
Estimate XML DataSize: false
Generate Output XML: true
DataSet Name:report
Number of elements:0
Total Query Execution time (ms):0
DataSet Name:Parameters
Number of elements:0
Total Query Execution time (ms):0
DataSet Name:Triggers
Number of elements:0
Total Query Execution time (ms):0
DataSet Name:bbbbbvvvvvvvvvvv
DataSet Type:sql
DataSet DB fetch size:100
DataSet Query Timeout:600
Total Number Of Times Query Executed:1
Total Number Of Rows Processed:5
Number of elements:1
Total Query Execution time (ms):1
------------------------------------------------------------------------
Total Number of Datasets: 4
Total Number of Elements: 1
Total Parse Time (ms): 4
Total Used Memory at Start: 1.36 GB
Total Used Memory after Parsing: 1.36 GB
Total Used Memory after Processing: 1.37 GB
Total Query Execution Time: 1 mseconds
Total Data Generation Time: 8 mseconds
Total XML Data Size Generated: 462
Processing Exceptions:
======================================================================
End Datamodel diagnostic details..
[180115_09330015][DATA PROCESSOR ID:1312954902][SCH JOB INFO:]Removed Session thread :Thread[[ACTIVE] ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads] : for id:Gs0isguxZN1516080794644
]]>
</DATA_PROCESSOR_LOG>
</DIAGNOSTIC_OUT>
0 -
Hi Thomas ,
Have checked with other user (who is having sysdba previleges) , still I am unable to view data and getting failed to load xml error. Please help me to resolve this issue.
Below is the view engine log information:
<?xml version="1.0" encoding="UTF-8"?>
<!--Generated by Oracle BI Publisher 12.2.1.2.0 -Dataengine, datamodel:_PCLS_BI_CCL_TEST_DATA_xdm -->
-<DIAGNOSTIC_OUT>
-<DATA_PROCESSOR_LOG>
-<![CDATA[
Data Processor debug log
================================================================
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Initializing DateFormatter for thread id:Thread[[ACTIVE] ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]:MapSize:5
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Initializing DecimalFormatter for thread id:Thread[[ACTIVE] ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]:MapSize:0
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]server_temp_dir=/qmrtsbx/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1/to5gma/public/xdo/tmp/
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Storing Session thread :Thread[[ACTIVE] ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads] : for id:ZJRbekGUZ11516170425072
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Start Datamodel parsing ..SessionId:ZJRbekGUZ11516170425072
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]DataModel parsing started...
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Oracle XML Parser version : Oracle XML Developer's Kit 12.2.1.2.0 - Production
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Data Model ......
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Inside properties Parser...
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Inside dataQueryParser...
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Inside dataStructureParser...
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Group ...report
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Group ...G_1
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Inside triggerParser...
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Inside parameterParser...
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]DataModel parsing completed....
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Setting Data Model ...
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Setting Parameters ...
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Setting Data sets Connections...
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Initializing DateFormatter for thread id:Thread[[ACTIVE] ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]:MapSize:5
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Initializing DecimalFormatter for thread id:Thread[[ACTIVE] ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]:MapSize:0
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Start Datamodel processing ..SessionId:ZJRbekGUZ11516170425072
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Executing PARAMETER triggers...
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Executing BEFORE REPORT triggers...
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Start process Data Structure ..
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Parameter name -> values for processing..
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]XDO_USER_NAME->c_bchapp
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]XDO_USER_ROLES->BIAdministrator, BIConsumer, BIAuthor
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]XDO_USER_UI_LOCALE->en
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]XDO_USER_UI_ORACLE_LANG->US
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]XDO_USER_REPORT_LOCALE->en_US
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]XDO_USER_REPORT_ORACLE_LANG->US
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]XDO_DASHBOARD_EXPR->null
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]FUSION_SECURITY_ENABLED->false
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]FUSION_ESS_APPLSESSION_ID->
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]TimeZone Details:
User Preference time zone selected:sun.util.calendar.ZoneInfo[id="Africa/Casablanca",offset=0,dstSavings=3600000,useDaylight=true,transitions=100,lastRule=java.util.SimpleTimeZone[id=Africa/Casablanca,offset=0,dstSavings=3600000,useDaylight=true,startYear=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=10800000,endTimeMode=0]]
Java SimpleDateFormat with no timezone set:2018-01-16 10:27:05.033-080022
JVM Java.Util.Timezone:sun.util.calendar.ZoneInfo[id="US/Pacific",offset=-28800000,dstSavings=3600000,useDaylight=true,transitions=185,lastRule=java.util.SimpleTimeZone[id=US/Pacific,offset=-28800000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,endTime=7200000,endTimeMode=0]]
Java SimpleDateFormat with JVM timezone:2018-01-16 10:27:05.033-080022
FND Cononical Date Format with JVM timezone:2018-01-16T22:27:05.236-08:00
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Writing Data ...
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Number of queries :1
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Returning Final Query from QueryParser:
select /* QUERY_SRC('datamodel: _PCLS_BI_CCL_TEST_DATA_xdm,dataset:a') */ "CHECKLIST_GROUP"."VERSION" as "VERSION",
"CHECKLIST_GROUP"."ACTIVE" as "ACTIVE",
"CHECKLIST_GROUP"."CREATED_BY" as "CREATED_BY"
from "CCL"."CHECKLIST_GROUP" "CHECKLIST_GROUP"
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]DataSet Name:a: DB Fetch Size: 100
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]DataSet Name:a: SQL Query Timeout: 500
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]DataSet Name:a: SQL Query :a: SELECT "VERSION",
"ACTIVE",
"CREATED_BY" FROM (select /* QUERY_SRC('datamodel: _PCLS_BI_CCL_TEST_DATA_xdm,dataset:a') */ "CHECKLIST_GROUP"."VERSION" as "VERSION",
"CHECKLIST_GROUP"."ACTIVE" as "ACTIVE",
"CHECKLIST_GROUP"."CREATED_BY" as "CREATED_BY"
from "CCL"."CHECKLIST_GROUP" "CHECKLIST_GROUP" ) PRUNED_a
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Complete process Data Structure ..
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Executing AFTER REPORT triggers...
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Data Generation Completed...
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Total Data Generation Time: 0.0 seconds
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Total Estimated XML Data size: 571
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:] Start Datamodel diagnostic details..
======================================================================
Datamodel name: _PCLS_BI_CCL_TEST_DATA_xdm
Processing mode: online
Calling module:
StringList: 2
Cache SQL Rowset: false
Allow DB Modifications: false
Is DM Customized: false
Output format: 1
Auto db Fetchsize enabled: true
Default db Fetchsize : 20
SQL Query Timeout : 600
Olnine SQL Query Timeout : 500
Offline SQL Query Timeout : 3600
XML data size limit: 314572800
XML Sample data size limit: 1048576
Processed with Scalable mode enabled: true
Track xml size enabled: true
SQL Session Trace enabled: false
SQL Session Trace File:
SQL Query Pruning enabled: true
Is Layout Elements passed: false
Layout Elements size: 0
Webservice timeout: 1800
Debug Mode: false
Estimate XML DataSize: false
Generate Output XML: true
DataSet Name:report
Number of elements:0
Total Query Execution time (ms):0
DataSet Name:Parameters
Number of elements:0
Total Query Execution time (ms):0
DataSet Name:Triggers
Number of elements:0
Total Query Execution time (ms):0
DataSet Name:a
DataSet Type:sql
DataSet DB fetch size:100
DataSet Query Timeout:600
Total Number Of Times Query Executed:1
Total Number Of Rows Processed:5
Number of elements:3
Total Query Execution time (ms):14
------------------------------------------------------------------------
Total Number of Datasets: 4
Total Number of Elements: 3
Total Parse Time (ms): 0
Total Used Memory at Start: 1.17 GB
Total Used Memory after Parsing: 1.17 GB
Total Used Memory after Processing: 1.18 GB
Total Query Execution Time: 14 mseconds
Total Data Generation Time: 16 mseconds
Total XML Data Size Generated: 586
Processing Exceptions:
======================================================================
End Datamodel diagnostic details..
[180116_10270005][DATA PROCESSOR ID:1573961815][SCH JOB INFO:]Removed Session thread :Thread[[ACTIVE] ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads] : for id:ZJRbekGUZ11516170425072
]]>
</DATA_PROCESSOR_LOG>
</DIAGNOSTIC_OUT>
0 -
Yes Thomas , I also noticed that error. But my doubt is whether this permission error related to DB or BI publisher side ?? Because I am able to run the query in same DB and see the data in DB (Using Sql developer).
Why this error coming in BI publisher ? Could you please explain me .
0