Skip to main content

I am facing following error in database background job

1)Job Name: Set Original Latest Finish custom field value. .

2)Error Text: The Event Action "Execute Online SQL" on "WT_ORG_LATEST_FINISH_BJ" has failed. Please contact your System Administrator to manage the Event Actions. ORA-01400: cannot insert NULL into ("IFSAPP"."JT_TASK_CFT"."ROWKEY") ORA-20105: FndEventAction.EVENT_ACTION_ERROR.

 

Hi @InfPrajwK,

Seems like the ROWKEY column is not updated correctly for JT_TASK_TAB table. Could you please check whether JT_TASK_TAB has it’s ROWKEY column set to “not nullable’ and the default value for the ROWKEY column is set to sys_guid()?

Have a look at following documentation regarding updating the rowkey :

https://docs.ifs.com/techdocs/foundation1/020_installation/040_upgrading_system/020_preparing_upgrade/020_installation_roadmap/hidden_itd/030_fndbas_rowkey_details.htm

Hope this helps!

Thank you @Charith Epitawatta 

Hi @Charith Epitawatta,

I have faced a similar issue 

Any inputs on this regard?

Reply


Terms & ConditionsCookie settings