My Oracle Support Banner

BI Cloud Connector Extract ORA-01555 Error FscmTopModelAM.FinGlJrnlEntriesAM.JournalLinePVO (Doc ID 2440871.1)

Last updated on FEBRUARY 28, 2022

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.13.18.02.0 and later
Oracle Fusion Application Toolkit - Version 11.1.9.2.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

While running the BICCC extract for Financial Analytics the following PVO is failing:


FscmTopModelAM.FinGlJrnlEntriesAM.JournalLinePVO


Error message:
java.lang.RuntimeException: Unable to write/upload file at oracle.obiacm.utils.WriterUtils.writeToFileAndUploadConcurrent(WriterUtils.java:270) at oracle.obiacm.dataExtract.BIVOExtractTask.writeToFileAndUploadConcurrent(BIVOExtractTask.java:436) at oracle.obiacm.dataExtract.BIVOExtractTask.writeToFile(BIVOExtractTask.java:353) at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(BIVOExtractTask.java:151) at oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract(BIVOExtractTask.java:127) at oracle.obiacm.dataExtract.BIVOExtractTask.run(BIVOExtractTask.java:108) 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 169 with name "_SYSSMU169_503825329$" 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:234) ... 8 more

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.