IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
 View Only
  • 1.  Map Test Run Error - One or more inputs was invalid

    Posted Thu February 04, 2016 05:57 PM

    Originally posted by: Ramache


    I am new to WTX and I am trying to execute an edi (X12 to Flat file) map. But it keeps throwing the error on the input as one or more inputs was invalid.

     

    Here is part of my input

     

    ST*204*9291316~B2**CIKM****16020301885*L*PP*R~B2A*00~N9*BE*ORDC OUTBOUND~

     

    Here is what i see in the trace file.


    (Level 1: Offset 16, len 0, comp 3 of 15, #1, DI 000000000005:)
    Data at offset 16 ('2**CMKI****16020') is INVALID data of TYPE
       X'001F' (B2A Segment V4010 ANSI EDI).

     

    Not sure if it has anything to do with the delimeters. I did verify that the control record terminator has "~" and element delimiter has "*" 

     

    Can you suggest what is causing this error.

     

     


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


  • 2.  Re: Map Test Run Error - One or more inputs was invalid

    Posted Fri February 05, 2016 06:44 AM

    Originally posted by: paul.brett


    Can you attach your input file, Map and Typetree?

    Thank-you.

    Paul

    Follow me on Twitter


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


  • 3.  Re: Map Test Run Error - One or more inputs was invalid

    Posted Fri February 05, 2016 10:30 AM
      |   view attached

    Originally posted by: Ramache


    Hi Paul,

     

    Attached the artifacts for your review.

     

    Thank you.


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

    Attachment(s)

    zip
    Map_Tree_Input-WTX.zip   217 KB 1 version


  • 4.  Re: Map Test Run Error - One or more inputs was invalid

    Posted Fri February 05, 2016 11:26 AM

    Originally posted by: paul.brett


    This is where it goes wrong:

    (Level 2: Offset 7, len 9, comp 2 of 2, #1, DI 000000000002:)
    Data at offset 7 ('9291316~B') was found to be of TYPE
       X'0010' (TSCtrl# Element V4010 ANSI EDI).
    
    (Level 2: Offset 7, len 9, comp 2 of 2, #1, DI 000000000003:)
    Type X'000A' (ST Segment V4010 ANSI EDI) is known to exist.
    
    (Level 1: Offset 2, len 14, comp 1 of 15, #1, DI 000000000003:)
    Data at offset 2 ('*204*9291316~B') was found to be of TYPE
       X'000A' (ST Segment V4010 ANSI EDI).
    
    (Level 1: Offset 2, len 14, comp 1 of 15, #1, DI 000000000004:)
    Data at offset 2 ('*204*9291316~B') was found to be of TYPE
       X'0009' (Segment V4010 ANSI EDI).
    
    (Level 1: Offset 2, len 14, comp 1 of 15, #1, DI 000000000004:)
    Type X'0008' (Transaction #204 Inbound Partner Set V4010 ANSI EDI) is known to exist.
    
    (Level 1: Offset 16, len 0, comp 2 of 15, #1, DI 000000000004:)
    Data at offset 16 ('2**CIKM****16020...') does not match INITIATOR 'B2'
      of TYPE X'0011' (B2 Segment V4010 ANSI EDI).
    
    (Level 1: Offset 16, len 0, comp 2 of 15, #1, DI 000000000004:)
    COMPONENT number 2 of TYPE X'0008' (Transaction #204 Inbound Partner Set V4010 ANSI EDI)
      is required, but does not exist.
    

    '9291316~B' is read in as the TSCtrl# Element, so the data does NOT match the Typetree definition.

    That said, when I use this Typetree to create the output, no delimiter is placed in the output, and I get:

    ST*204*9291316B2**CKIM

    Where did the Typetree originate?  If it was supplied by IBM, I recommend you open a Service Request.

    Thank-you.

    Paul

    Follow me on Twitter


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


  • 5.  Re: Map Test Run Error - One or more inputs was invalid

    Posted Fri February 05, 2016 02:50 PM

    Originally posted by: Ramache


    Thanks for looking into this Paul.

     

    I tried to prune the type tree my self from ansi_4010.mtt . i followed the documentation present in this URL below . Not sure if any thing is missing here that is causing the type tree to be invalid.

     

    http://www-01.ibm.com/support/knowledgecenter/SSVSD8_8.3.0/com.ibm.websphere.dtx.packhealthcareref.doc/tasks/t_pack_healthcareref_Merging_and_Pruning_Type_Trees.htm

     

     


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


  • 6.  Re: Map Test Run Error - One or more inputs was invalid

    Posted Mon February 08, 2016 01:46 AM

    Originally posted by: paul.brett


    Does the data validate with the original Typetree (before pruning)?

    Thank-you.

    Paul

    Follow me on Twitter


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


  • 7.  Re: Map Test Run Error - One or more inputs was invalid

    Posted Thu February 11, 2016 03:15 AM

    Originally posted by: paul.brett


    In the pruning, you seem to have removed the terminator to the group object 'ST', which was set to Variable->Terminator Delimiter Control.

    However, this is not the only problem, as even when I use the original typetree, I still see in the trace:

    (Level 2: Offset 7, len 10, comp 2 of 2, #1, DI 000000000002:)
    Data at offset 7 ('9291316~B2') fails maximum size requirements
    TYPE X'0010' (TSCtrl# Element V4010 ANSI EDI).

    When I use the typetree to create the input file, I get:

    ST*204*9291316
    B2**CIKM****  
    B2A*

    ...so your data has multiple issue.

    At this point, I recommend you either use the standard Typetree, with proper X12 data, or contact your local Sales representative to engage IBM Global Services, for your custom work.

    Thank-you.

    Paul

    Follow me on Twitter


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


  • 8.  Re: Map Test Run Error - One or more inputs was invalid

    Posted Thu February 11, 2016 10:28 AM

    Originally posted by: Ramache


    Thank you for looking into this Paul !

     

    I see the issue is only with my type tree  . Now when i use the entire ansi_4010.mtt , I am able to translate with no errors.

     

     

     

     


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