Fusion - BICCC Extract Failing - Error 500--Internal Server Error - 10.5.1 500 Internal Server Error
(Doc ID 2596653.1)
Last updated on AUGUST 29, 2022
Applies to:
Oracle Fusion Financials Common Module Cloud Service - Version 11.13.19.04.0 and laterInformation 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 |