My Oracle Support Banner

Fusion - BICCC Extract Failing - Error 500--Internal Server Error - 10.5.1 500 Internal Server Error (Doc ID 2596653.1)

Last updated on OCTOBER 24, 2019

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Symptoms

BICCC incremental extracts scheduled to run on daily basis have failed with below error

ERROR
-----------------------
FscmTopModelAM.CatalogAM.CategoryAssignmentP1 with java.io.IOException [IMPL SPT]

oracle.obiacm.dataExtract.DataExtractException: Error executing query at oracle.obiacm.queryprocessing.BIServerQuery.runQuery(BIServerQuery.java:1478) at oracle.obiacm.queryprocessing.BIServerQuery.runQuery(BIServerQuery.java:1432) at oracle.obiacm.queryprocessing.BIServerQuery.runDataExtractQuery(BIServerQuery.java:431) at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(BIVOExtractTask.java:217) at oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract(BIVOExtractTask.java:109) at oracle.obiacm.dataExtract.BIVOExtractTask.doRun(BIVOExtractTask.java:93) at oracle.obiacm.dataExtract.AbstractCancellableTask.run(AbstractCancellableTask.java:37) at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:378) at weblogic.work.ExecuteThread.run(ExecuteThread.java:307) Caused by: java.sql.SQLException: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed:

Detailed error as per nqquery log:
Error 500--Internal Server Error
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.