BICC extract failing for HcmTopModelAnalyticsGlobalAM.OrganizationAM.PerDeptTreeStructureBICVO

Amit Garg-Oracle

Summary:

We are getting error while extracting data from below data store. the BICC job runs for phenomenally long time and then errors out. This is happening only in one of Fusion environments of 3.

Data Store - HcmTopModelAnalyticsGlobalAM.OrganizationAM.PerDeptTreeStructureBICVO

Error -

oracle.obiacm.dataExtract.DataExtractException: Error executing query at oracle.obiacm.queryprocessing.BIServerQuery.runQuery(BIServerQuery.java:1673) at oracle.obiacm.queryprocessing.BIServerQuery.runQuery(BIServerQuery.java:1623) at oracle.obiacm.queryprocessing.BIServerQuery.runDataExtractQuery(BIServerQuery.java:511) at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(BIVOExtractTask.java:296) at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(BIVOExtractTask.java:253) at oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract(BIVOExtractTask.java:135) at oracle.obiacm.dataExtract.BIVOExtractTask.doRun(BIVOExtractTask.java:104) at oracle.obiacm.dataExtract.AbstractCancellableTask.run(AbstractCancellableTask.java:37) at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:209) at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352) at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337) at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:60) at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41) at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420) at weblogic.work.ExecuteThread.run(ExecuteThread.java:360) Caused by: java.sql.SQLException: java.io.IOException: Error response: [nQSError: 46066] Operation cancelled. [nQSError: 43113] Message returned from OBIS. at oracle.bi.jdbc.AnaJdbcStatementImpl.executeQuery(AnaJdbcStatementImpl.java:387) at oracle.obiacm.queryprocessing.BIServerQuery.runQuery(BIServerQuery.java:1656) ... 15 more

 

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Rajasekhar Bandaru-Oracle

Hi Amit

Please use BI Broker mode while scheduling the PVO from BICC and then verify the results.

BI Broker Mode for Extraction
https://docs.oracle.com/en/cloud/saas/applications-common/24d/biacc/configure-offerings-to-extractofferingsdata-store-for-offering.html