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):