WA Agent for SAP : Jobs not completing and null exception for process chain

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - System Agent (AutoSys)
• Workload Automation Agent
• CA Workload Automation DE - Business Agents (dSeries)
• CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

SAP jobs will stay at STARTING or READY and may not complete.  The jobs complete in the SAP side.

Environment

Release : 11.3 / 11.4 

Component : CA Workload Automation Agent for SAP

Cause

The WA Agent logs may show errors like these for the process chain.  This will likely result in jobs getting stuck due to some internal error.  Even if the job is resubmitted, it will not complete from the agent side.

01/XX/2019 00:00:56.498-0800 1 main.Execution:-123456789683828829.CybSAPBWGetChainProcessStatus.replyChangedStatusOnly[:210] - Process chain name>>> XYZ12345  status>> 

01/XX/2019 00:00:56.498-0800 1 main.Execution:-123456789683828829.CybSAPJobManager.reply[:2884] - Reply: some object is NULL

01/XX/2019 00:00:56.498-0800 1 main.Execution:-123456789683828829.CybSAPJobManager.reply[:2887] - Encountered Exception: java.lang.NullPointerException

01/XX/2019 00:00:56.498-0800 1 main.Execution:-123456789683828829.CybSAPJobManager.returnConnectionToPool[:1388] -  returnConnectionToPool Thread >>Thread[Execution:-123456789683828829,5,main]

 

Also, following errors may be seen in the agent logs.

 

01/XX/2019 00:00:01.882-0800 1 main.Execution:123456789683828829.CybSAPBWGetChainProcessStatus.replyChangedStatusOnly[:210] - Process chain name>>> XYZ12345 status>> 

01/XX/2019 00:00:01.882-0800 1 main.Execution:123456789683828829.CybSAPJobManager.reply[:2884] - Reply: some object is NULL

01/XX/2019 00:00:01.882-0800 1 main.Execution:123456789683828829.CybSAPJobManager.reply[:2887] - Encountered Exception: java.lang.NullPointerException

at cybermation.plugins.sap.commands.bw.CybSAPBWGetChainProcessStatus.getTableCopy(Unknown Source)

at cybermation.plugins.sap.commands.bw.CybSAPBWGetChainProcessStatus.setResidualTail(Unknown Source)

 

 

Resolution

The SAP jobs may continue to have issue due to the internal error.  Update the WA Agent and SAP Plugin to latest release.

Cold start of agent may also be needed to clear the error messages.  Perform the following steps to cold start the WA Agent to clear stuck jobs.

1. Stop all the jobs on the WA Agent from manager side.

2. Stop the agent

3. Delete or remove the database and log directories inside the WA Agent install directory.

4. Start the agent and then submit the jobs again.