My Oracle Support Banner

Cancelled session still holding on to a process, which had object lock (Doc ID 2622779.1)

Last updated on MARCH 06, 2020

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.8.2 to 2.4.8.4 [Release 2.4]
Information in this document applies to any platform.

Symptoms

The problem : killing the main job and sub-jobs has not resolved the issue of the next submitted job becoming "stuck".

You have followed the steps from Note: How To Abort InForm Main/Sub Jobs (Doc ID 2603943.1) but the issue still occurs and the next submitted job doesn't complete.

You've followed the steps below:

-------
Steps executed:

1. Execute with apps user the dataloadsubjobs.sql script for the stuck job.
2. Identify all subjobs.
3. For the identified subjob, navigate from LSH application to "Administration"/"Job Execution".
4. Search for the identified job.
5. Open the job and click on "Cancel Job" button.
6. Repeat steps 4-5 until all required jobs/subjobs are canceled.
-------

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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