MWM Timed Batches Are Fail With "Deleting key BatchJobQueue_Id(x) from CI_BATCH_JOB_K: expected 1 row delete, got 0" , "Cannot delete key BatchJobQueue_Id(x) from key table CI_BATCH_JOB_K" (Doc ID 1632413.1)

Last updated on JUNE 01, 2023

Applies to:

Oracle Real-Time Scheduler - Version 2.1.0 and later
Oracle Utilities Mobile Workforce Management - Version 2.0 and later
Information in this document applies to any platform.

Symptoms

Batches are running fine when manually submitted. However, beginning closely after a data refresh in our UAT environment, MWM timed batches are not running.
We have imported data into UAT from other environment but did not update batch related tables.

Theadpoolworker logs include:

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

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

MWM Timed Batches Are Fail With "Deleting key BatchJobQueue_Id(x) from CI_BATCH_JOB_K: expected 1 row delete, got 0" , "Cannot delete key BatchJobQueue_Id(x) from key table CI_BATCH_JOB_K" (Doc ID 1632413.1)

Applies to:

Symptoms

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!