My Oracle Support Banner

Fusion BICC - Unable To Extract FscmTopModelAM.PaysheetAM.ParticipantPay Data Store (Doc ID 2485695.1)

Last updated on NOVEMBER 02, 2020

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.13.18.05.0 and later
Information 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

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


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