Scenario Run Fails at the step of update to table KDD_JOB To FIN (Doc ID 3026321.1)

Last updated on JUNE 05, 2024

Applies to:

Symptoms

On : 8.0 version, Web UI

Scenario Run Fails at KDD_JOB update to FIN
It updates the KDD_RUN to FIN for the run and then it fails when it updates KDD_JOB to FIN.

The kDD_JOB remains in ERR state , but KDD_RUN is in FIN status. The last update statement fires and then it fails.


04/30/2024 10:54:23 DEBUG : Thread ID = 139771955803904: Rule Matcher: File = runupdater.cc: Line = 104: UPDATE mantas.KDD_RUN SET RUN_MSG_TX = :Msg WHERE RUN_ID = 67333201
04/30/2024 10:54:23 DEBUG : Thread ID = 139771955803904: Rule Matcher: File = runupdater.cc: Line = 142: UPDATE mantas.KDD_RUN SET RUN_MSG_TX = :Msg WHERE RUN_ID = 67333201
04/30/2024 10:54:23 DEBUG : Thread ID = 139771955803904: Rule Matcher: File = runupdater.cc: Line = 59: UPDATE mantas.KDD_RUN SET RUN_STATUS_CD = 'FIN' WHERE RUN_ID = 67333201
04/30/2024 10:54:23 DEBUG : Thread ID = 139771955803904: Rule Matcher: File = runupdater.cc: Line = 198: UPDATE mantas.KDD_RUN SET END_TS = TO_DATE('30/04/2024 10:54:23 AM','DD/MM/YYYY HH:MI:SS AM') WHERE RUN_ID = 67333201
04/30/2024 10:54:23 DEBUG : Thread ID = 139773341336064: Rule Matcher: File = jobupdater.cc: Line = 57: UPDATE mantas.KDD_JOB SET STATUS_CD = 'FIN' WHERE JOB_ID = 3791169

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.