CA PPM: Load DWH job fails with error ORA-01555: snapshot too old

Document ID : KB000098385
Last Modified Date : 30/05/2018
Show Technical Document Details
Issue:

The Load DWH job fails with following with an example table being DWH_TME_ENTRY:

ERROR 2018-05-29 01:10:55,589 [Thread-329555] dwh.event ClarityDB - isOracle? - An error occurred executing this job entry :
Couldn't execute SQL: DECLARE
.
.
.
        INSERT INTO DWH_CMN_ERROR_MESSAGE VALUES('DWH_TME_ENTRY',V_SQLERRM,V_SQLCODE,REPLACE(V_SQL_TEXT,'**',''''));
        COMMIT;
        RAISE_APPLICATION_ERROR(-20100,'ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_TME_ENTRY). SQLERRM : ' || V_SQLERRM);
    END;

END;

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_TME_ENTRY). SQLERRM : ORA-01555: snapshot too old: rollback segment number 89 with name "_SYSSMU89_214320579$" too small
ORA-02063: preceding line from [SCHEMADWH]_[SCHEMAPPM]
ORA-06512: at line 31

 

Cause:

This can happen to any table in the database schema and is due to an issue with the Oracle database configuration.

 

 

Resolution:

The issue is to be resolved by the On-Premise or SaaS DBA team.

The session which occupied the undo space is to be killed to free up the space.