Fusion BICC - Unable To Extract FscmTopModelAM.PaysheetAM.ParticipantPay Data Store
(Doc ID 2485695.1)
Last updated on JUNE 28, 2022
Applies to:
Oracle Fusion Financials Common Module Cloud Service - Version 11.13.18.05.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.13.18.05.0 version, Technology Management - Reports/Analytics
When attempting to run BICC extract on FscmTopModelAM.PaysheetAM.ParticipantPay the following error occurs.
ERROR
-----------------------
java.lang.RuntimeException: Unable to write/upload file
at oracle.obiacm.utils.WriterUtils.writeToFileAndUploadConcurrent(WriterUtils.java:271)
at oracle.obiacm.dataExtract.BIVOExtractTask.writeToFileAndUploadConcurrent(BIVOExtractTask.java:418)
at oracle.obiacm.dataExtract.BIVOExtractTask.writeToFile(BIVOExtractTask.java:334)
at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(BIVOExtractTask.java:132)
at oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract(BIVOExtractTask.java:102)
at oracle.obiacm.dataExtract.BIVOExtractTask.doRun(BIVOExtractTask.java:86)
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: Error while fetching rows from server: java.io.IOException: fetch failed[nQSError: 43113] Message returned from OBIS.
[nQSError: 43119] Query Failed:
[nQSError: 17001] Oracle Error code: 1555, message: ORA-01555: snapshot too old: rollback segment number 115 with name "_SYSSMU115_3895279079$" too small
at OCI call OCIStmtFetch.
[nQSError: 17012] Bulk fetch failed.
at oracle.bi.jdbc.AnaJdbcResultSetImpl.fetchSomeRowsVersion2(AnaJdbcResultSetImpl.java:1591)
at oracle.bi.jdbc.AnaJdbcResultSetImpl.fetchSomeRows(AnaJdbcResultSetImpl.java:1253)
at oracle.bi.jdbc.AnaJdbcResultSetImpl.fetchMoreRows(AnaJdbcResultSetImpl.java:1871)
at oracle.bi.jdbc.AnaJdbcResultSetImpl.next(AnaJdbcResultSetImpl.java:766)
at oracle.obiacm.utils.WriterUtils.writeToFileAndUploadConcurrent(WriterUtils.java:235)
... 9 more
]]
[2018-10-09T12:57:12.581+00:00] [bi_server1] [ERROR] [] [oracle.obiacm.dataExtract.BIVOExtractTask] [tid: 189161] [ecid: 005TwRfrYns8pmc_xhT4iW00068P00002Y,1:58909] [APP: oracle.biacm#11.1.1] [ESS_JobMetadataID: JobDefinition://oracle.apps.ess.biccc/BICloudConnectorJobDefinition] [ESS_RequestID: 61329] [ESS_Module: Processor] FscmTopModelAM.PaysheetAM.ParticipantPay - ExecSummary - queryDuration=8,extractDuration=0,uploadDuration=0,totalDuration=18681,rowsCount=0
-----------------------
java.lang.RuntimeException: Unable to write/upload file
at oracle.obiacm.utils.WriterUtils.writeToFileAndUploadConcurrent(WriterUtils.java:271)
at oracle.obiacm.dataExtract.BIVOExtractTask.writeToFileAndUploadConcurrent(BIVOExtractTask.java:418)
at oracle.obiacm.dataExtract.BIVOExtractTask.writeToFile(BIVOExtractTask.java:334)
at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(BIVOExtractTask.java:132)
at oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract(BIVOExtractTask.java:102)
at oracle.obiacm.dataExtract.BIVOExtractTask.doRun(BIVOExtractTask.java:86)
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: Error while fetching rows from server: java.io.IOException: fetch failed[nQSError: 43113] Message returned from OBIS.
[nQSError: 43119] Query Failed:
[nQSError: 17001] Oracle Error code: 1555, message: ORA-01555: snapshot too old: rollback segment number 115 with name "_SYSSMU115_3895279079$" too small
at OCI call OCIStmtFetch.
[nQSError: 17012] Bulk fetch failed.
at oracle.bi.jdbc.AnaJdbcResultSetImpl.fetchSomeRowsVersion2(AnaJdbcResultSetImpl.java:1591)
at oracle.bi.jdbc.AnaJdbcResultSetImpl.fetchSomeRows(AnaJdbcResultSetImpl.java:1253)
at oracle.bi.jdbc.AnaJdbcResultSetImpl.fetchMoreRows(AnaJdbcResultSetImpl.java:1871)
at oracle.bi.jdbc.AnaJdbcResultSetImpl.next(AnaJdbcResultSetImpl.java:766)
at oracle.obiacm.utils.WriterUtils.writeToFileAndUploadConcurrent(WriterUtils.java:235)
... 9 more
]]
[2018-10-09T12:57:12.581+00:00] [bi_server1] [ERROR] [] [oracle.obiacm.dataExtract.BIVOExtractTask] [tid: 189161] [ecid: 005TwRfrYns8pmc_xhT4iW00068P00002Y,1:58909] [APP: oracle.biacm#11.1.1] [ESS_JobMetadataID: JobDefinition://oracle.apps.ess.biccc/BICloudConnectorJobDefinition] [ESS_RequestID: 61329] [ESS_Module: Processor] FscmTopModelAM.PaysheetAM.ParticipantPay - ExecSummary - queryDuration=8,extractDuration=0,uploadDuration=0,totalDuration=18681,rowsCount=0
Changes
No application change.
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 |