Hi,
We are currently experiencing a very intermittent issues where the following two issues occur.
System
- SAP_BW 740 0009 SAPKW74009 SAP Business Warehouse
- R11.3 SP2 Agent
- AIX Server
- BWPC_JOB runs a process chain and the ESP job completes prior to the process chain finishing. As you can see from the job spool, the COMPLETE message was sent before the EXEC status, which seems to be why it completed prematurely.
BWPC_JOB run a process chain and doesn't complete even though the process chain finishes. The log below shows that an exec message was sent back to the mainframe, but then ESP removed the monitor on the process chain causing it to not receive the complete message.
04/26/2016 03:06:59.934 CDT-0500 4 main.Execution:2463683380051305420.CybSAPRequestProcessorBase.notifyCaller[:1201] - *@* Caller Notified.
04/26/2016 03:06:59.934 CDT-0500 4 main.Execution:-3669075852341782411.CybConnectionsPool.push[:158] - NOTIFY POOL : connection = 9
04/26/2016 03:06:59.934 CDT-0500 4 main.Execution:-4236747906414316582.CybSAPJobManager.processGroupOfResponses[:1465] - &&& response 0 is cybermation.plugins.sap.communicator.CybSAPRequest@4740474
04/26/2016 03:06:59.934 CDT-0500 4 main.Execution:-3669075852341782411.CybSAPRequestProcessorBase.notifyCaller[:1201] - *@* Caller Notified.
04/26/2016 03:06:59.934 CDT-0500 4 main.Execution:-4236747906414316582.CybSAPJobManager.processResponse[:1556] - operation = 87(Table Read)
04/26/2016 03:06:59.934 CDT-0500 1 main.Execution:-4236747906414316582.CybSAPBWGetChainProcessStatus.replyChangedStatusOnly[:210] - Process chain name>>> SASO005_AUMO01 status>> A
04/26/2016 03:06:59.935 CDT-0500 5 main.Execution:-4236747906414316582.CybSAPTableImageBase.display[:435] - TABLE: DATA
04/26/2016 03:06:59.935 CDT-0500 5 main.Execution:-4236747906414316582.CybSAPTableImageBase.display[:443] - [Type] [Variant] [Instance] [State] [Actual_State]
04/26/2016 03:06:59.935 CDT-0500 5 main.Execution:-4236747906414316582.CybSAPTableImageBase.display[:454] - [DTP_LOAD] [DTP_7GJZLT4H93G1FRWP3UOF3SISN] [Unknown] [Unknown] [Running]
04/26/2016 03:06:59.935 CDT-0500 5 main.Execution:-4236747906414316582.CybSAPTableImageBase.display[:454] - [DTP_LOAD] [DTP_7GJZLT4H93G1FRWPA5DVL0LD3] [Unknown] [Unknown] [Running]
04/26/2016 03:06:59.935 CDT-0500 5 main.Execution:-4236747906414316582.CybSAPTableImageBase.display[:454] - [TRIGGER] [SASO005_AUMO01_SP] [55O6LHRKMQ39IH9R6C520YHBJ] [Finished] [Finished]
04/26/2016 03:07:01.941 CDT-0500 4 main.Execution:-4236747906414316582.CybSAPResponseQueue.display[:240] -
################## REPLY AUMO01_SASO005.CHAIN/SAPAPP.482/MAIN
* VERB : STATE
* SUBVERB : EXEC
* RESIDUAL : Status(Active) FormatType(1) ExtTable(Type,Variant,Instance,State,Actual_State/nDTP_LOAD,DTP_7GJZLT4H93G1FRWP3UOF3SISN,Unknown,Unknown,Running,DTP_LOAD,DTP_7GJZLT4H93G1FRWPA5DVL0LD3,Unknown,Unknown,Running,TRIGGER,SASO005_AUMO01_SP,55O6LHRKMQ39IH9R6C520YHBJ,Finished,Finished)
04/26/2016 03:07:01.941 CDT-0500 4 main.Execution:-4236747906414316582.CybSAPResponseQueue.push[:107] - >>>>> Response added to queue...
04/26/2016 03:07:01.943 CDT-0500 1 main.Execution:-4236747906414316582.CybSAPJobManager.startPCorIPMonitoringThread[:2892] - operation >>87
04/26/2016 03:07:01.943 CDT-0500 4 main.Thread-13.CybSAPResponseQueue.popObject[:138] - <<<<< Got response from queue...
04/26/2016 03:07:03.951 CDT-0500 4 main.Execution:-4236747906414316582.CybSAPJobManager.tryToSetJobRemovalFlag[:3117] - Set Removal Flag: Job <AUMO01_SASO005.CHAIN/SAPAPP.482/MAIN> not found. Retrying ....
04/26/2016 03:07:03.951 CDT-0500 4 main.Execution:-4236747906414316582.CybSAPJobManager.tryToSetJobRemovalFlag[:3118] - Try alternative action for operation - 87
04/26/2016 03:07:03.951 CDT-0500 1 main.Execution:-4236747906414316582.CybSAPJobManager.returnConnectionToPool[:1375] - returnConnectionToPool Thread >>Thread[Execution:-4236747906414316582,5,main]
04/26/2016 03:07:03.951 CDT-0500 1 main.Execution:-4236747906414316582.CybSAPJobManager.returnConnectionToPool[:1376] - cnc Id>>8 cnc Type>> 1 established >>false
04/26/2016 03:07:03.951 CDT-0500 4 main.Execution:-4236747906414316582.CybSAPJobManager.tryToCloseConnection[:1416] - Connection #8 is not established. No need to disconnect.
04/26/2016 03:07:03.952 CDT-0500 5 main.Execution:-4236747906414316582.CybConnectionsPool.push[:149] - ConnectionsPool.push from size = 9
04/26/2016 03:07:03.952 CDT-0500 4 main.Execution:-4236747906414316582.CybConnectionsPool.push[:158] - NOTIFY POOL : connection = 8
04/26/2016 03:07:03.952 CDT-0500 4 main.Execution:-4236747906414316582.CybSAPRequestProcessorBase.notifyCaller[:1201] - *@* Caller Notified.
04/26/2016 03:07:05.048 CDT-0500 4 main.Monitor:2764908713870940128.CybSAPProcessChainManager.threadHandler1[:264] - 0-0-0 Process Chains Removal...
04/26/2016 03:07:05.048 CDT-0500 4 main.Monitor:2764908713870940128.CybSAPProcessChainManager.threadHandler1[:278] - +-- Chain <SASO005_AUMO01@AUMO01_SASO005.CHAIN/SAPAPP.482/MAIN> added to removals.
04/26/2016 03:07:05.139 CDT-0500 4 main.Monitor:2764908713870940128.CybSAPProcessChainManager.removeChain[:170] - Process Chain <SASO005_AUMO01@AUMO01_SASO005.CHAIN/SAPAPP.482/MAIN> removed from collector.
04/26/2016 03:07:05.139 CDT-0500 4 main.Monitor:2764908713870940128.CybSAPProcessChainManager.removeMarkedChains[:242] - --- Process Chain <SASO005_AUMO01@AUMO01_SASO005.CHAIN/SAPAPP.482/MAIN> removed by monitor.
04/26/2016 03:07:05.139 CDT-0500 4 main.Monitor:2764908713870940128.CybSAPProcessChainManager.threadHandler1[:301] - 0-0-0 Monitoring Process Chains