"Error 500..." when trying to create Cost Plan due to issue with audit trigger
search cancel

"Error 500..." when trying to create Cost Plan due to issue with audit trigger


Article ID: 217040


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


Not able to create a cost plan. Receive Error "Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator."

Error seen in logs:

ERROR 2021-06-04 14:17:45,599 [http-nio-8080-exec-128] service.ODFService (clarity:user_name:36778963__6B0F80D4-BF01-4DB6-9597-74CA34EF6E84:revmgr.costplanPost) processRequest Exceptioncom.niku.union.odf.exception.ODFException: com.niku.union.persistence.PersistenceException: SQL error code: 0Error message: ERROR: cache lookup failed for function 627074942Executed: insert into fin_plans(id,CODE,STATUS_CODE,START_PERIOD_ID,TOTAL_COST,IS_PLAN_OF_RECORD,DESCRIPTION,BENEFIT_PLAN_ID,END_PERIOD_ID,TOTAL_UNITS,PLAN_BY_2_CODE,BUDGET_SUBMIT_OPTION,OBJECT_ID,PLAN_TYPE_CODE,REVISION,TOTAL_REVENUE,PLAN_BY_1_CODE,NAME,OBJECT_CODE,PERIOD_TYPE_CODE,ACTUALS_OUT_OF_DATE,SOURCE_COST_PLAN_ID,SUB_PLAN_TYPE,created_date,created_by,last_updated_date,last_updated_by) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)


Release : Any


Issue is due to a corrupted audit trigger.


  1. Navigate to Administration->Objects
  2. Search for the Cost Plan object
  3. Go to the Audit Trail tab
  4. Remove Audited Attributes and click Save
  5. Put the audited attributes back and click Save.