Posted: Tue Aug 16, 2005 12:02 pm Post subject: Work in progress queue (WIP) for MySAP.com adapter
Apprentice
Joined: 08 Nov 2004 Posts: 25 Location: Portland, OR
I had some questions about the 'work in progress' queue that the MySAP.com adapter uses. We recently had an SAP adapter failure. A message landed on our SAPADPTR.PRGN.ALE.WIP queue at 2:19 8/8/2005. The data was an Idoc from SAP going to the adapter. The adapter crashed the next day at 10:53 08/09/2005.
See the adapter log below.
I looked through Adapter for mySAP.com (SAP R/3 V. 4.x) User Guide pdf, but I'm still unclear how the adapter uses this queue.
Questions:
1. Can you clarify how the wip queue is used?
2. What is the best practice for handling messages that land on the WIP queue? (We backed up the message, and had the Idoc resent)
From the adapter log:
[Time: 2005/08/09 10:53:14.538] [System: ConnectorAgent] [SS: SAPPRGNConnector] [Thread: JCO.ServerThread-1 (#879191111)] [Type: Error] [MsgID: 28050] [Mesg: SapRfcServerConnectorAgent.onConfirmTID() : Thread JCO.ServerThread-1: Error: java.lang.Exception: [Type: Error] [MsgID: 30006] [Mesg: MQServerSessionManager.mqOnConfirm() : Unable to retrieve MQMessage for ID : "35E79F555CCF42F8EB940001" from queue SAPADPTR.PRGN.ALE.WIP.] .] [Time: 2005/08/09 10:53:14.571] [System: ConnectorAgent] [SS: SAPPRGNConnector] [Thread: JCO.ServerThread-1 (#879191111)] [Type: Error] [MsgID: 23062] [Mesg: SapRfcServerConnectorAgent.onConfirmTID() is requesting shutdown of connector. Check earlier errors.]
[Time: 2005/08/09 10:53:14.572] [System: ConnectorAgent] [SS: SAPPRGNConnector] [Thread: JCO.ServerThread-1 (#879191111)] [Type: Error] [MsgID: 28037] [Mesg: Exception in Server Thread : JCO.ServerThread-1 , Error message : com.sap.mw.jco.JCO$AbapException: (126) Check SAP Connector log. Error in OnConfirmTID.: Check SAP Connector log. Error in OnConfirmTID..]
Looks like your WIP queue is used to store the SAP transactionID.
What this means is most probably that you had a transaction fail.
The idoc in question should still be on SM58...
Remember that with ALE you are not guaranteed the order of the messages and you will have to check the timestamp to determine whether you want to apply it or throw it away...
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum