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.  Problems with burst mode

    Posted 08/08/05 06:07 AM

    Originally posted by: SystemAdmin


    I have a fairly simple partition type tree for a file that I want to read in bursts of 500 records. (File is <NL> delimited with three character initiator for each line. File has had rejects removed.)

    When I turn burst mode off, the file is validated correctly. When I turn burst on, it fails with i:835fd5194f"Input type contains errors."[/i:835fd5194f] warning message. The file has roughly 1800 records but in looking at the audit, I see that burst count went up to five. The trace shows that after the fourth i:835fd5194f"End of Validation messages for INPUT CARD 1."[/i:835fd5194f] message there are a lot of trace messages, like this one:

    code:1:835fd5194f(Level 2: Offset 3, len 0, comp 1 of 21, #1, DI 00000001:)
    Data at offset 3 ('(end of data)') is INVALID data of TYPE
    X'000F' (RIC_TO DZF_Columns Data).[/code:1:835fd5194f]

    So it seems like the burst iterates one too many times. The "b:835fd5194f(end of data)[/b:835fd5194f]" bit says the last time there is no data.

    Actually I did some iterations of the map, tinkering with the fetch unit and found that it failed if the fetch unit was 460 to 532. Outside of that, it ran fine, though I didn't test much outside that range.

    What is going on here?

    I really need to output in i:835fd5194fchunks[/i:835fd5194f] of 500 records. If someone knows how to get burst working, or a better way outside of burst, I certainly would enjoy hearing about it.

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


  • 2.  Re: Problems with burst mode

    Posted 08/09/05 04:50 AM

    Originally posted by: SystemAdmin


    Send this stuff to support -- they'll help you. ;o)
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: Problems with burst mode

    Posted 08/09/05 05:13 AM

    Originally posted by: SystemAdmin


    Busted! LOL

    Just thought I'd see if anyone else had any ideas.

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


  • 4.  Re: Problems with burst mode

    Posted 08/09/05 05:29 AM

    Originally posted by: SystemAdmin


    Hehehehe. No prob, I'd do the same thing.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 5.  Re: Problems with burst mode

    Posted 08/10/05 06:48 AM

    Originally posted by: SystemAdmin


    It also helps to mention the version and platform when asking a question.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 6.  Re: Problems with burst mode

    Posted 08/10/05 06:58 AM

    Originally posted by: SystemAdmin


    Yep, you're right about that.

    Datastage TX 7.5.1 (119)
    Windows XP Pro SP1

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


  • 7.  Re: Problems with burst mode

    Posted 08/10/05 11:10 AM

    Originally posted by: SystemAdmin


    Could you try a different way to describe to type designer the initiator/terminator sequence?
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 8.  Re: Problems with burst mode

    Posted 08/10/05 01:07 PM

    Originally posted by: SystemAdmin


    Actually, I thought it might be the type tree. I tried modifying the type tree but could not find the i:13a866e206silver bullet[/i:13a866e206] I needed. Additionally, I was able to replicate it on a simple Text File type tree (ie. repeating text fields delimited by <NL>).

    Ascential has opened an eCase on it.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender