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