R3_ACTIVATE_JOBS, R3_ACTIVATE_INTERCEPTED_JOBS, R3_GET_JOBS end with return code '106'

Document ID : KB000089252
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
R3_ACTIVATE_JOBS, R3_ACTIVATE_INTERCEPTED_JOBS, R3_GET_JOBS end with return code '106'
Resolution:

Symptoms

 

SAP Jobs activated through R3_ACTIVATE_JOBS, R3_ACTIVATE_INTERCEPTED_JOBS, R3_GET_JOBS dont start, end with return code '106' and ended_not_ok
    


 

NOTE!: The Information below will be added into the Documentation

 

Cause and Solution

 

Even tho an SAP job is fully identified through the Parameters Jobname and Jobcount, the selection of Sap Jobs does not work if no time selection (Start/End Date/Time)
is transfered to SAP. The Reason for this behavior is that the sap function in the interface passes on default date and time values of "00000000" for Date und "000000" for Time.

 

Tests with different versions have come to differing conclusions. Therefore we strongly recommend to use the Parameters START_DATE/START_TIME and END_DATE/END_TIME
with a valid date and time, when using R3_ACTIVATE_JOBS, R3_ACTIVATE_INTERCEPTED_JOBS, R3_GET_JOBS.

 

To find out all objects you are currently using these functions in, run the following select against your automic database:

 

For all jobs that contain "R3_ACTIVATE_JOBS"

 

select OH_CLIENT, OH_NAME, OT_LNR, OT_CONTENT
from oh
Inner Join OT on OT_OH_IDNR = OH_IDNR
where Ot_type = 0
and OT_content  like '%R3_ACTIVATE_JOBS%'
and OH_DeleteFlag = 0;

 

For all jobs that contain "R3_ACTIVATE_INTERCEPTED_JOBS"

 

select OH_CLIENT, OH_NAME, OT_LNR, OT_CONTENT
from oh
Inner Join OT on OT_OH_IDNR = OH_IDNR
where Ot_type = 0
and OT_content  like '%R3_ACTIVATE_INTERCEPTED_JOBS%'
and OH_DeleteFlag = 0;

 

For all jobs that contain "R3_GET_JOBS":

 

select OH_CLIENT, OH_NAME, OT_LNR, OT_CONTENT
from oh
Inner Join OT on OT_OH_IDNR = OH_IDNR
where Ot_type = 0
and OT_content  like '%R3_GET_JOBS%'
and OH_DeleteFlag = 0;