Question

Background job error

  • 1 August 2022
  • 1 reply
  • 119 views

Userlevel 4
Badge +7

Hi Team,

 

Any idea about below background job error.

 

Regards,

N


1 reply

Userlevel 7
Badge +11

Hi @Nagarjuna , as per the error, one possible reason could be that process is trying to insert/update a record which is a duplicate to existing record. So if you have database access, try to add 2 insert & update triggers to the table INTFACE_JOB_DETAIL_TAB table to capture the primary key columns (intface_name, line_no) and also to print the call stack (dbms_utility.format_call_stack) of the execution path.

Afterwards re-execute the background job, then you should get the trigger output. Based on that it should be possible to technically track down the root cause which is causing this issue.

 

Reply