IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only
  • 1.  Rejects in Trading Manager

    Posted 08/06/10 05:04 PM

    Originally posted by: SystemAdmin


    Facing a peculiar issue in Trading Manager.
    Having been getting xyz_ss.rej files getting created in the tmgr reject folder.
    A more on this generally has the message as
    "The filename xyz was invalid"

    The tmgr help suggests possible causes as

    i)Cause I
    Error Condition:Reject files getting created by StampAndSort containing partial files.
    Reason :Occurs when files are written to the mail folder by an application other than the IBM Transformation Extender.
    See the section titled Interfacing with non-IBM Transformation Extender systems for additional information.

    ii)Cause II
    Error Condition:Valid files are getting rejected by StampAndSort as invalid file names when they do conform to the Trading Manager standards
    Reason :Message Manager is failing to access the database.
    Either RunMaps where not redeployed after correcting the update.mdq file or the database is not available.

    Other facts related to this are
    i)Consumes the file , does not leave it unprocessed.
    ii)No consistency on size/time of occurrence
    iii)manually re dropping the file on second attempt (after retriving it from previous process archive) , process fine.

    Have this issue on both the production servers
    1)server 1 : wtx map writing to mail
    2) server 2 : a non wtx process writing to mail

    So the error is not consistent with either a WTX map or a Non WTX process is writing to mail as it occurs on both servers.

    Assuming that its a handshake issue we did put a delay on server 2 , which has kind of reduced the errors but not completely.

    I am also looking at the actual code to get a better idea of what could be happening
    (Sortec.mms , stampandsortfile.mmc , functional map : MapReject , op card cell 6 & 7) , but not much success yet.

    Currently having an open PMR to resolve this but just checking with fellow users if anybody faced this kind of issue ?
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: Rejects in Trading Manager

    Posted 08/10/10 02:37 PM

    Originally posted by: jvanboga


    Here are some typical messages we get....


    X12 Error ThreadID: edi0000001201004120000
    April 12, 2010 - 08:53:22

    SortX12.mmc -

    Sender ISA Qual/ID : 30sendervalue
    Sender App ID : sendervalue
    Receiver ISA Qual/ID : 30receivervalue
    Receiver App ID : receivervalue
    Please check the Trading Partner information in the Interchange below.
    Commerce Manager was unable to find a valid tradelink
    File checked was xtliedi.tsv in the share directory
    Error data follows:
    .
    .
    .


    X12 Error ThreadID: edi0000014201008090000
    August 9, 2010 - 08:36:57

    SortX12.mmc -

    Sender ISA Qual/ID :
    Sender App ID :
    Receiver ISA Qual/ID :
    Receiver App ID :
    This data failed due to severe errors in the X12 data
    .
    .
    .

    X12 Error ThreadID: edi0000039201008040000
    August 4, 2010 - 17:33:33

    SortX12.mmc -

    Sender ISA Qual/ID : 30sendervalue
    Sender App ID : sendervalue
    Receiver ISA Qual/ID : 30receivervalue
    Receiver App ID : receivervalue
    The following Functional Group has a GE Count MisMatch
    Error data follows:
    .
    .
    .


    Other messages could be due to issues with map deployment, connectivity, type trees used during deployment, missing files
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: Rejects in Trading Manager

    Posted 08/10/10 05:06 PM

    Originally posted by: SystemAdmin


    Thanks for your response. Apart from the regular (missing trade link error , invalid data etc) errors that you have described, we are getting the reject files that i mentioned in my earlier post.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 4.  Re: Rejects in Trading Manager

    Posted 08/11/10 11:50 AM

    Originally posted by: wcartmill


    This is a known issue in TM. If you are running TM on a fast server, TM gets ahead of itself and fails to process the file. Error messages look like this:


    Message sent to default email. Check configuration files. See Error Below:

    StampAndSort ErrorThreadID: gen0010599oo
    August 9, 2010 - 20:18:33

    stampandsortfile - 7.7

    The filename 2rxesi826a2mgcnrlak4.KSL2192rxesi5nmgsygcnrlkh4.mo.GEN was invalid.

    File was saved as /data/wip/dstx80/mmgr/archive/2rxesi826a2mgcnrlak4.KSL2192rxesi5nmgsygcnrlkh4.mo.GEN.mec

    Possible cause was that the file extension of ' GEN ' was not a valid Get PON.
    Check in Partner Manager that the Post Office exists.


    Note that while TM did pull the sequence ID from the database (first half of the thread id)it did not include the date stamp, which makes the thread ID unique. IBM reports this as a timing issue, and recommends that you add delays to the stampandsort map. However, as you discovered, this only reduces the issue and meanwhile slows down all TM processing.

    You may also see issues where TM doesn't respect the lock on a file writing to the "get" location, and either picks up partial files, or attempts to pick up a file that has not been released by the writer, and then never picks up the file. Both of these can be corrected by writing the file in one directory, and moving (unix mv command) it to the get directory. This sometimes occurs in internal process directories, like when TM generates an acknowledgement.

    Hope this helps. Let us know if you have better luck with IBM support than we did.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 5.  Re: Rejects in Trading Manager

    Posted 08/11/10 03:30 PM

    Originally posted by: SystemAdmin


    Thats the exact error message you mentioned that i was referring about.

    Since "delay" did not work we will now have to look at other alternative options , like
    writing a file with .tmp & then then renaming it or
    witing the data file along with a ctl file & map triggering on a ctl file

    Thanks for your response.

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


  • 6.  Re: Rejects in Trading Manager

    Posted 10/16/10 07:17 PM

    Originally posted by: Breckin.Crudup


    wcartmill wrote:
    This is a known issue in TM. If you are running TM on a fast server, TM gets ahead of itself and fails to process the file. Error messages look like this:

    I encountered the same problem, Thanks! It has wasted me a lot time already, I've tried it and it works.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender