Investment Allocation Job Fails With Oracle Error ORA-22924

book

Article ID: 220778

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

The job has been failing recently with the following BG log error:

ERROR 2021-07-30 16:29:00,793 [Dispatch Investment Allocation : [email protected] (tenant=clarity)] niku.njs (clarity:admin__xxxxxxx:Investment Allocation) Error executing job: 6510145
java.lang.RuntimeException: com.niku.union.persistence.PersistenceException: 
SQL error code: 22924
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-22924: snapshot too old


 

Cause

This is an Oracle issue regarding the LOB corruption

Resolution

The DBA will need to analyze the error of this type.

Here are possible resolutions:
1. Increase the parameter of UNDO_RETENTION
2. Use larger rollback segments.