Solved

Cannot insert null value error in background job

I
Rank
Badge +2

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.

 

icon

Best answer by Charith Epitawatta 6 May 2022, 17:55

View original

3 replies

Charith Epitawatta
Rank
Userlevel 7
Badge +31

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!

Charith - https://charith.xyz
I
Rank
Badge +2

Thank you @Charith Epitawatta 

V
Rank
Badge +3

Hi @Charith Epitawatta,

I have faced a similar issue 

Any inputs on this regard?

Reply


Terms & ConditionsCookie settings