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 JANUARY 31, 2017

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms