Unable To Submit The Job In Deferred Mode Using CreateSubmission API That Accepts System Parameters (Doc ID 2205217.1)

Last updated on NOVEMBER 18, 2016

Applies to:

Oracle Life Sciences Data Hub - Version 2.4.6 and later
Information in this document applies to any platform.

Goal

Our requirement is to submit an LSH program and wait for its completion before continuing to the next step.

To achive this we use the <cdr_pub_exe_submission.createSubmission> FUNCTION by passing the required RUNTIME parameters and setting the execution mode to "Deferred".

Once the submission is created, we call the <cdr_pub_exe_submission.startJob> PROCEDURE that submits the job, waits for it completion before the control is returned to the calling program.

Since we have to submit this procedure with the same set of parameters multiple time, we have to modify the system parameters, "Force Execution Flag", and set its value to "Yes".

The <cdr_pub_exe_submission.createSubmission> FUNCTION does not accept SYSTEM parameters, so we used the <cdr_pub_exe_submission.createSubmission> PROCEDURE, that accepts both RUNTIME and SYSTEM parameters.

This createSubmission PROCEDURE behaves differently from the FUNCTION with the same name. The problem is that this createSubmission PROCEDURE does not accept any execution mode parameter and is submitting the job into the job queue, due to

which we are unable to wait for the job to complete before continuing to the next step.

We need another procedure or function that accepts SYSTEM parameters and also allows selecting the execution mode.

Solution

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 hundreds of Community platforms