Investment Allocation Job Fails With Oracle Error ORA-22924
search cancel

Investment Allocation Job Fails With Oracle Error ORA-22924


Article ID: 220778


Updated On:


Clarity PPM On Premise


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

ERROR 2021-07-30 16:29:00,793 [Dispatch Investment Allocation : bg@server (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  


Release 15.9.1, 15.9.2, Oracle Database 


This is an Oracle issue regarding the LOB corruption or could also be due to the introduction of SQL Curves in 15.9.1 which can cause memory issues.


The DBA will need to analyze this type of error:

Here are possible resolutions:

    1. Increase the parameter of UNDO_RETENTION 
    2. Use larger rollback segments 

Additionally, apply Patch #1 on 15.9.2 ( or upgrade to 15.9.3 to resolve issues with SQL Curves as a cause to performance or out of memory issues. 

Refer to the following article for more details: DE60926: Investment Allocation crashes BG with OOM due to SQL Curves 

Additional Information