IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
 View Only
Back to discussions
Expand all | Collapse all

ITX 9.0.0.4 - Input Card Validation issues in 9.0.0.4

  • 1.  ITX 9.0.0.4 - Input Card Validation issues in 9.0.0.4

    Posted Tue November 04, 2025 02:08 PM
      |   view attached

    hi,

    I am facing a major issue with Input Card validation.

    See attached image of the type tree that is causing the issue.

    The input card has three components

    1. Header
    2. NewValues
    3. OldValues

    The Components delimiter value is 'FS'

    The field delimiter value within each component is 'RS'

    The input card reads the header and the NewValues record correctly but fails to read the start of the OldValues record.

    Below is the portion of the Trace where it fails.

    +++++++++++++++++++++++++++++++++++++++++++++++++++++++++

    (Level 3: Offset 1700, len 4, comp 320 of 321, #1, DI 000000000088:)

    Data at offset 1700 ('NULL') was found to be of TYPE

       X'015F' (valuation_d datetime_t datatype Audext_operation).

     

    (Level 3: Offset 1705, len 10, comp 321 of 321, #1, DI 000000000088:)

    Data at offset 1705 ('04/11/2025') was found to be of TYPE

       X'0160' (value_d datetime_t datatype Audext_operation).

     

    (Level 2: Offset 95, len 1620, comp 2 of 3, #1, DI 000000000089:)

    Data at offset 95 ('NULLRSNULLRSNULLRSN...') was found to be of TYPE

       X'0013' (NewValues Audext_operation).

     

    (Level 2: Offset 1715, len 0, comp 3 of 3, #1, DI 00000000008A:)

    Data at offset 1715 ('RSFSNULLRSNULLRSNULL...') does not match DELIMITER 'FS'

      of TYPE X'0003' (AuditRec Audext_operation).

     

    (Level 2: Offset 1715, len 0, comp 3 of 3, #1, DI 00000000008A:)

    Data at offset 1715 ('RSFSNULLRSNULLRSNULL') was found to be of TYPE

       X'0161' (OldValues Audext_operation).

     

    (Level 1: Offset 1715, len 0, comp 1 of 1, #1, DI 00000000008A:)

    Data at offset 1715 ('RSFSNULLRSNULLRSNULL...') does not match TERMINATOR '<LF>'

      of TYPE X'0003' (AuditRec Audext_operation).

    +++++++++++++++++++++++++++++++++++++++++++++++++++++++++

    As you can see it is able to read correctly up to the last field 321 for the NewValues component.

    But when it start to reads the next (OldValues) component it fails.

    I can observe that it is not calculating the offset correct ( 1705 + 10 + 1 = 1716) for the next component. ( see highlighted text in yellow above)

    Instead it fails to take into account the 'RS' character and calculates the wrong value ( 1705 + 10 = 1715) and fails to read the next component correctly.

    appreciate your help with the above.

    Thanks

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



    ------------------------------
    joseph dmello
    ------------------------------


  • 2.  RE: ITX 9.0.0.4 - Input Card Validation issues in 9.0.0.4

    Posted Wed November 05, 2025 05:58 PM

    All you answers are right there - but you cannot "see it" in your data...  You need a good editor with the ability to see unprintable characters / hex editor.  Notepad++ is free, however UltraEdit is my favorite.  You have NULLS (hex 00) in your file and it looks like extra RS delimiters as well.  Mind your definition on the field delimiter - it looks like your data is postfix but you probably want infix and to remove the extra RS before the FS as well. It sounds like the record group should be explicit, delimited, infix with RS as the literal delimiter and a literal Terminator of FS.  The file group would have just be the repeating record - implicit sequence group no terminators.Hope this helps!

    (Level 2: Offset 1715, len 0, comp 3 of 3, #1, DI 00000000008A:)

    Data at offset 1715 ('RSFSNULLRSNULLRSNULL...') does not match DELIMITER 'FS'

      of TYPE X'0003' (AuditRec Audext_operation).

    Hope this helps and happy mapping!



    ------------------------------
    Lisa Edwards
    Software Engineer / Subject Matter Expert
    Rainbow Data Systems, Inc
    ------------------------------

    Original Message


Related Content