SAP Job Status Not Updated

Document ID : KB000052325
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Job Status not being updated for SAP jobs. The exception in the sap_communicator.log is "TABLE is empty".

Solution:

You are receiving an exception from SAP on the child processes. After a job completes, the agent calls BAPI_XBP_JOB_CHILDREN_GET to get the list of children.

In this case, SAP reports that there are children but the table containing their identity is empty and the Agent gets SAP JCo Exception "TABLE is empty" when querying for children status.

The exception in the sap_communicator.log;
CybSAPJobManager.processGroupOfResponses[:1534] - Monitor RESPONSE Exception:
TABLE is empty.

The transmitter log and CAWA (dSeries) Server tracelog reported unknown status;
STATE UNKNOWN Status(Unknown) LStatus(TABLE is empty.) Plugin(SAPPlugin).

Your SAP administrator can determine why SAP returns an exception in this case. However, an easier way to deal with this issue is to;

  1. Tell the Agent not no monitor for children by setting the "Monitor children" flag to "no" in the job definition for the job in question, OR

  2. Tell the Agent to ignore a response with an empty table by setting the following property in agentparm.txt and restarting the agent;

    sap.children.ignoreIfTableEmpty=true

If you set the "sap.children.ignoreIfTableEmpty=true" property in the agentparm.txt file, then the agent will continue to monitor children for all jobs that is supposed to. However, if while checking for children the agent receives a "TABLE is empty" exception from SAP, the agent will report the actual status of the job and ignore the status of children because it would not know anything about them.