My Oracle Support Banner

OBIA 7964 DAC ETL Failed With ORA-01555: Snapshot Too Old: Rollback Segment Number 20 With Name "_SYSSMU20_425 (Doc ID 1929326.1)

Last updated on FEBRUARY 16, 2018

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.
March 2016

Symptoms

You have scheduled Incremental EPs in DAC which have successfully executed in the past. Recently you are facing an issue where the ETL is failing.  The following error can be seen in the Informatica session log

 


ORA-01555: snapshot too old: rollback segment number 20 with name "_SYSSMU20_425863094$" too small
ORA-01555: snapshot too old: rollback segment number 20 with name "_SYSSMU20_425863094$" too small
Database driver error...
Function Name : Fetch
SQL Stmt : SELECT W_INV_AGING_FS.PRODUCT_ID, W_INV_AGING_FS.INVENTORY_PROD_ID, W_INV_AGING_FS.LOT_ID, W_INV_AGING_FS.INVENTORY_ORG_ID, W_INV_AGING_FS.PLANT_LOC_ID, W_INV_AGING_FS.STORAGE_LOC_ID, W_INV_AGING_FS.INV_BALANCE_DT, W_INV_AGING_FS.RECVD_DT, W_INV_AGING_FS.AVAILABLE_QTY, W_INV_AGING_FS.UNIT_STD_COST, W_INV_AGING_FS.STD_COST_AMT, W_INV_AGING_FS.DAYS_IN_INVENTORY, W_INV_AGING_FS.DAYS_SINCE_EXPIRED, W_INV_AGING_FS.DAYS_LEFT_EXPIRY, W_INV_AGING_FS.DOC_CURR_CODE, W_INV_AGING_FS.LOC_CURR_CODE, W_INV_AGING_FS.LOC_EXCH_RATE_TYPE, W_INV_AGING_FS.LOC_EXCHANGE_RATE, W_INV_AGING_FS.EXCHANGE_DT, W_INV_AGING_FS.CREATED_BY_ID, W_INV_AGING_FS.CHANGED_BY_ID, W_INV_AGING_FS.CREATED_ON_DT, W_INV_AGING_FS.CHANGED_ON_DT, W_INV_AGING_FS.AUX1_CHANGED_ON_DT, W_INV_AGING_FS.AUX2_CHANGED_ON_DT, W_INV_AGING_FS.AUX3_CHANGED_ON_DT, W_INV_AGING_FS.AUX4_CHANGED_ON_DT, W_INV_AGING_FS.DELETE_FLG, W_INV_AGING_FS.REJECT_FLG, W_INV_AGING_FS.DATASOURCE_NUM_ID, W_INV_AGING_FS.INTEGRATION_ID, W_INV_AGING_FS.TENANT_ID, W_INV_AGING_FS.X_CUSTOM FROM W_INV_AGING_FS
Oracle Fatal Error
Database driver error...
Function Name : Fetch



You have tried to increase the UNDO RETENTION in the database from 900 to 2400. This has not worked.

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


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