Investment Allocation Job Fails With Oracle Error ORA-22924

Products

• Clarity PPM On Premise

Issue/Introduction

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  

Environment

Release 15.9.1, 15.9.2, Oracle Database 

Cause

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.

Resolution

The DBA will need to analyze this type of error:

Here are possible resolutions:

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

Additionally, apply Patch #1 on 15.9.2 (15.9.2.1) 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

• Investment Allocation Job - Purpose & Overview