IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only

Mercator 6.7, SAP 7.00, LOCK_FAILED problem

  • 1.  Mercator 6.7, SAP 7.00, LOCK_FAILED problem

    Posted 02/04/09 04:04 AM

    Originally posted by: ChB


    Hello Group,

    I'm new in this group, but not new to Mercator. I started with 1.4.2. ;-)

    Currently I try to get IDocs with Mercator 6.7 from a SAP 7.00. Most of the times it is working fine, but sometimes I get a LOCK_FAILED error.

    The IDoc is received, but it is marked in SAP in SM58 as error (LOCK_FAILED) and is waiting to be sent again.

    
    DispatchLoop() = RFC_OK: O.K. ServerThread finished. RfcWaitForRequest() = RFC_OK: O.K. RfcDispatch called... tRfc_OnTIDCheck() begins; tid = A03A5117145C49804A2A3E8C IDCheck(A03A5117145C49804A2A3E8C) = 0 (SUCCESS) tRfc_OnTIDCheck() ends; result = 0 recv_idocs() started. RfcGetData()... RfcGetData() = RFC_OK: O.K. Packet contains 1 Control Record and 9 Data Records. WriteIDocs() = RFC_OK: O.K. ItDelete(IDOC_CONTROL) = 0 ItDelete(IDOC_DATA) = 0 RfcSendData()... RfcSendData() = RFC_OK: O.K. Packet of 1 IDoc(s) received (0.010000 sec). recv_idocs() = RFC_OK: O.K. recv_idocs() finished. tRfc_OnTIDCommit() begins; tid = A03A5117145C49804A2A3E8C ItDelete(IDOC_CONTROL) = 0 ItDelete(IDOC_DATA) = 0 Run Completed at 14:08:57.359 on 01/28/09.  Cleanup deferred. Run Completed at 14:08:57.660 on 01/28/09. IBM WebSphere Transformation Extender R/3 Adapter, Version SAPTX7.2(June_6_2008) Copyright ¨ 1997-2006, IBM Corporation.  All rights reserved Built 
    
    for SUN on Jun  6 2008 at 14:23:31. Using (built-in) 
    
    for RFC services. This RFC library belongs to the SAP R/3 Release *** 620,0,1631  *** Retry Count is 0. Retry Interval is 0. OnFailure is Rollback. Fetch Unit is 0.  Card Mode is Integral. Run Started at 14:08:57.761 on 01/28/09. Options used: a,g,x,ar3,tid,trace,verbose,append,name CompareR3Conn SetIDStatus(A03A5117145C49804A2A3E8C, EXECUTED) = -1 (LOCK_FAILED) Idoc write error, failed to commit transaction tRfc_OnTIDCommit() ends; result = -1 tRfc_OnTIDRollback() begins; tid = A03A5117145C49804A2A3E8C ItDelete(IDOC_CONTROL) = 0 ItDelete(IDOC_DATA) = 0 Run Completed at 14:08:58.838 on 01/28/09.  Cleanup deferred. Run Completed at 14:08:59.199 on 01/28/09. IBM WebSphere Transformation Extender R/3 Adapter, Version SAPTX7.2(June_6_2008) Copyright ¨ 1997-2006, IBM Corporation.  All rights reserved Built 
    
    for SUN on Jun  6 2008 at 14:23:31. Using (built-in) 
    
    for RFC services. This RFC library belongs to the SAP R/3 Release *** 620,0,1631  *** Retry Count is 0. Retry Interval is 0. OnFailure is Rollback. Fetch Unit is 0.  Card Mode is Integral. Run Started at 14:08:59.658 on 01/28/09. Options used: a,g,x,ar3,tid,trace,verbose,append,name CompareR3Conn SetIDStatus(A03A5117145C49804A2A3E8C, ROLLBACK) = -1 (LOCK_FAILED) tRfc_OnTIDRollback() ends; result = -1 ...RfcDispatch returned. RfcDispatch() = RFC_CLOSED: Connection closed by the other side. ServerThread: back from RfcDispatch: RfcRc=6   ServerThread: fell thru loop: RfcRc=6 ...
    


    Do you know, where this LOCK_FAILED is coming from and how it could be solved?

    Do you know, if there are compatibility problems with Mercator 6.7 and SAP 7.00?

    If you need more details, please let me know.

    Thanks in advance

    Christian
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender