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.  Optional Date causing input failure

    Posted 01/06/10 04:43 PM

    Originally posted by: Liv2luv


    I am reading values from a text file which has an optional date in it. When the date is defined, the map runs with out an error. When the date is not defined white space is available and it causes the following error :

    
    (Level 2: Offset 95, len 8, comp 3 of 4, #1, DI 0000000E:) Data at offset 95 (
    '        ') failed item presentation test 
    
    for TYPE X
    '0014' (SERVICE_DATE_END Field CopyBook).   (Level 2: Offset 95, len 8, comp 3 of 4, #1, DI 0000000E:) Data at offset 95 (
    '        ') is INVALID data of TYPE X
    '0014' (SERVICE_DATE_END Field CopyBook).
    


    I have tried tweaking with options like padding, NONE, Zero etc. Still my map fails when the date is not specified.

    How this needs to be handled?

    Thanks

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


  • 2.  Re: Optional Date causing input failure

    Posted 01/07/10 11:32 AM

    Originally posted by: LaurentB


    I'd have expected the special value "NONE" to work. Do you have a simple sample ?
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 3.  Re: Optional Date causing input failure

    Posted 01/07/10 11:42 AM
      |   view attached

    Originally posted by: Liv2luv


    I have attached the project interchange, every thing else works good except the SERVICE_END_DATE item.

    As said before, I tried with NONE, ZERO and Padding. None worked for me.

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

    Attachment(s)



  • 4.  Re: Optional Date causing input failure

    Posted 01/07/10 03:00 PM
      |   view attached

    Originally posted by: SystemAdmin


    it seems to be validating the ip after changing the SERVICE_END_DATE item to optional.
    Plz find attached.
    Regards
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender

    Attachment(s)



  • 5.  Re: Optional Date causing input failure

    Posted 01/07/10 04:11 PM

    Originally posted by: Liv2luv


    Thanks. That is what I was exactly trying to do.

    I looked into the Properties of the item and could not find how to make it optional. Could you please elaborate how can we make it optional ?

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


  • 6.  Re: Optional Date causing input failure

    Posted 01/07/10 04:15 PM

    Originally posted by: Liv2luv


    Ok. I see that now. It is the Set Range Property which made all the Difference.

    Thank you very much!
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 7.  Re: Optional Date causing input failure

    Posted 01/12/10 02:10 PM

    Originally posted by: rogrady


    Let me know if you are still having trouble. I have the cobol to xml map working. The cobol copy book layout and copy book file are not in sync.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 8.  Re: Optional Date causing input failure

    Posted 01/12/10 02:17 PM

    Originally posted by: Liv2luv


    I have it working now. Set Range was the issue.

    If you can share the project interchange that will be good.

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


  • 9.  Re: Optional Date causing input failure

    Posted 01/12/10 03:16 PM

    Originally posted by: rogrady


    I'm sorry to say the Set Range advice left you with a ticking time bomb. If any of the other date, time, or numeric fields are not present, the map will fail.... Please post the latest TypeTree-Xml.mtt, there seems to be two version out there.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender