IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only
Expand all | Collapse all

Problem while executing a map

  • 1.  Problem while executing a map

    Posted 07/12/07 02:33 AM

    Originally posted by: SystemAdmin


    I have a transformation map for a data

    RS
    ***7777|123|Jignesh|Sampat|M|IBM India Pvt Ltd
    M 19761002 Vasai 401202 952506516929

    RE

    RS ==> is a record starter
    its properties to support the above format are :
    It has restrictions to include RS and <CR><LF>

    it has a literal terminator value <CR><LF> the size has minimum and maximum both restricted to 2

    The next field 7777 is a employee id field. It has initiator as "***"

    the file component has the component rules for distinguishing the RS and record group by comparing the Client record group "not equal to" "***"
    still i get this error in trace....

    (Level 1: Offset 0, len 2, comp 1 of 3, #1, DI 00000001:)
    Data at offset 0 ('RS') was found to be of TYPE
    X'0005' (RecordStart RecordTag Field ClientData).

    (Level 1: Offset 0, len 2, comp 1 of 3, #1, DI 00000002:)
    Data at offset 0 ('RS') was found to be of TYPE
    X'0004' (RecordTag Field ClientData).

    (Level 1: Offset 4, len 32, comp 1 of 3, #2, DI 00000003:)
    Data at offset 4 ('***7777|123|Jign...') fails maximum size requirements
    TYPE X'0005' (RecordStart RecordTag Field ClientData).
    Thanks,
    Jignesh
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 2.  Re: Problem while executing a map

    Posted 07/12/07 04:16 AM

    Originally posted by: janhess


    "it has a literal terminator value the size has minimum and maximum both restricted to 2"

    I don't understand how you specify the size of a literal terminator.

    I think you need to specify the "RS" and "***" as record identifiers.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: Problem while executing a map

    Posted 07/12/07 04:44 AM
      |   view attached

    Originally posted by: SystemAdmin


    The initiaters are for client_id and the max and min size is for RS {Record starter}

    attaching snap shot of the ppt for client id
    Thanks,
    Jignesh
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 4.  Re: Problem while executing a map

    Posted 07/12/07 04:46 AM
      |   view attached

    Originally posted by: SystemAdmin


    also attaching ppt of record starter
    Thanks,
    Jignesh
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 5.  Re: Problem while executing a map

    Posted 07/12/07 04:47 AM

    Originally posted by: janhess


    Can you attach the type tree for the sample data you posted.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 6.  Re: Problem while executing a map

    Posted 07/12/07 05:00 AM
      |   view attached

    Originally posted by: SystemAdmin


    zipped and attached the tree.
    Thanks,
    Jignesh
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange

    Attachment(s)



  • 7.  Re: Problem while executing a map

    Posted 07/12/07 05:15 AM
      |   view attached


  • 8.  Re: Problem while executing a map

    Posted 07/12/07 05:29 AM
      |   view attached

    Originally posted by: SystemAdmin


    Thanks alot...i progressed but still error....Input valid but unknown data found.

    the data passed is :

    RS
    ***7777|123|Jignesh|Sampat|M|IBM India Pvt Ltd|M|19761002|Vasai||401202||952506516929|||
    RE
    RS
    ***8888|888|Sanjay|Panchal|M|IBM India Pvt Ltd|M|19710831|Borivali||400064||28255519|||
    RE
    attaching the trace file...

    Thanks,
    Jignesh
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender

    Attachment(s)



  • 9.  Re: Problem while executing a map

    Posted 07/12/07 05:43 AM
      |   view attached

    Originally posted by: janhess


    You just need a file containing groups containing RS, record,RE. See attached.

    I think you need to review the type tree documentation.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender

    Attachment(s)



  • 10.  Re: Problem while executing a map

    Posted 07/12/07 05:59 AM

    Originally posted by: SystemAdmin



    I'am a beginner to WTX. Still the Client type tree is giving me the same initial as error as posted before this thread.

    Kindly suggest.

    Thanks,
    Jignesh
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 11.  Re: Problem while executing a map

    Posted 07/12/07 06:10 AM

    Originally posted by: janhess


    Well it works fine with the data in your last post. I'm using 8.1.0.2 build 34.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 12.  Re: Problem while executing a map

    Posted 07/12/07 06:31 AM

    Originally posted by: SystemAdmin


    I'm using 8.1.0.1
    Thanks,
    Jignesh
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 13.  Re: Problem while executing a map

    Posted 07/12/07 06:41 AM
      |   view attached

    Originally posted by: janhess


    I've attached all the info to resolve your problem - typetree, map, data file, log and trace.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender

    Attachment(s)



  • 14.  Re: Problem while executing a map

    Posted 07/12/07 07:36 AM

    Originally posted by: SystemAdmin


    Thanks alot...it worked fine.please tell me the mistakes i did.

    Thanks again,
    Jignesh
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 15.  Re: Problem while executing a map

    Posted 07/12/07 08:06 AM

    Originally posted by: janhess


    Use Type Tree differences under the file menue in Type Designer.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 16.  Re: Problem while executing a map

    Posted 07/12/07 08:34 AM

    Originally posted by: SystemAdmin


    I did that thanks for your precious time and solution.

    As I understand the validation is broken into several levels so a record is broken into the actual data and then it is wrapped by RS and RE. Together all these constitute the group. And then everything seems to be simple.

    Is my understanding correct....
    Thanks,
    Jignesh
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 17.  Re: Problem while executing a map

    Posted 07/12/07 07:39 AM

    Originally posted by: SystemAdmin


    how does the reject works without restart attribute.....
    Thanks,
    Jignesh
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 18.  Re: Problem while executing a map

    Posted 07/12/07 08:12 AM

    Originally posted by: janhess


    It doesn't or it mayreject everything after the first error.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange