IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
 View Only
  • 1.  How to capture WTX Warning ..Input valid but unknown data found

    Posted Thu April 22, 2010 05:11 AM

    Originally posted by: vijji_WTX


    Hi All,

    Could you please suggest how can i capture Input valid but unknown data found warning in WTX. my requirement is i have to log error message for this warning. I checked ISERROR, ONERROR and also Map settings but no luck.

    Request your valuable comments on this.
    Thanks in advance !!!

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


  • 2.  Re: How to capture WTX Warning ..Input valid but unknown data found

    Posted Thu April 22, 2010 06:34 AM

    Originally posted by: TimUK


    2 possible ways to start with

    1. using lasterrormsg() function valid(run("map",....), lasterrormsg()))

    2. scan the audit log, which was stored in memory run("map","-aem .....) and use the word function to strip out the contents of the <Message></Message> tag or look for string mapreturn="8"

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


  • 3.  Re: How to capture WTX Warning ..Input valid but unknown data found

    Posted Thu April 22, 2010 07:38 AM

    Originally posted by: vijji_WTX


    Hi Tim,

    Thanks for your reply. Lasterrorcode or msg functions work only if any error occurs. correct me if i am wrong. Before calling run function i have to confirm input is correct or not. Here first 2 records are fine and 3rd record is worng i.e unknow data. First 2 records are processed and 3rd record process is ending. i have to capture this warning message.

    Second method is fine....but i do not much idea how can implement using audit file.. Could u pls suggest me how to do it.. or any other solution..

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


  • 4.  Re: How to capture WTX Warning ..Input valid but unknown data found

    Posted Thu April 22, 2010 09:02 AM

    Originally posted by: repanzer


    Being it's been so long that I've had to code for this, I am hitting the same problem now.

    Something I was doing was making the type tree stronger on validation, for example, the first field always should contain "2.1", as text, and I defined it as a text string. It was part of a thousand byte fixed record, where each field was required, but all spaces would be accepted for each field as the pad. If I dropped a files with just AAAAAA, I would get the warning, even though it's so far from being anywhere near valid data.

    I believe it's because AAAAA successfully validatated for the first field, so it found good data, then got confused and threw the warning. What I did was put a component rule on the first field as $="2.1", which would make it fail.

    If anyone can let me know if I'm incorrect in my description of why AAAAA would still be "input valid but unknown data found", please let us know.

    I'm not sure if putting "fail on warnings" would make it a failure that would work with the reject function/restart attribute.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 5.  Re: How to capture WTX Warning ..Input valid but unknown data found

    Posted Thu April 22, 2010 09:37 AM

    Originally posted by: vijji_WTX


    Hi repanzer... h r u and how is life .....i know u will reply to this mail...Thanks for your time and knowledge sharing. I have fixed this issue. As you said , we have to make TT stronger.....I updated the TT -->record and sheet settings to infix.

    i mean Format->Component syntax -> locaton = infix for both Record and sheet .

    earlier it was different. Now i am able to get expected result. Now my 3rd record invalid and here i am not doing anything just triggering mail to support team.

    repanzer: i have one very basic question. to be honest i do not know it's answer. What is syntax in Type Tree. how can i explain this..

    Thanks a lot for all.
    Have a great day !!

    regards,
    Vijji
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 6.  Re: How to capture WTX Warning ..Input valid but unknown data found

    Posted Thu April 22, 2010 11:43 AM
      |   view attached

    Originally posted by: repanzer


    "repanzer: i have one very basic question. to be honest i do not know it's answer. What is syntax in Type Tree. how can i explain this.."

    Well, I hope you wouldn’t ask a question you knew the answer to….unless this is a tech interview.

    The easiest way for me to explain this is if you are familiar with X12 EDI.

    In X12 EDI, there are a number of delimiters and terminators that are acceptable per the standard. In order to make the type tree accept any of these values, you set up a “syntax” item/field;

    In every single X12 interchange, it’s starts off as:

    ISA*

    Where ISA is the segment identifier and the next character (4th byte) is the record delimiter...ALWAYS. So, if you know the 4th byte in every interchange is the record delimiter, you set up the 4th character as a field. You call it a syntax item.

    Now, if you look at any segment in the X12 type tree and see what the delimiter is, because they are all delimited, it is not a literal, like a comma; it is a syntax item, the field that is set as the 4th character. (see attached)
    When the map reads in the “delimiter”, it set that value in the 4th byte as the record delimiter for the entire interchange….NOT FILE, interchange, because there may be many interchanges per file, and each may use a different delimiter or terminator (or composite delimiter), which will be “reset”, every time it’s starts to read a new one.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 7.  Re: How to capture WTX Warning ..Input valid but unknown data found

    Posted Thu April 22, 2010 11:44 AM

    Originally posted by: repanzer


    and life @#$2 right now...unless you're hiring.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 8.  Re: How to capture WTX Warning ..Input valid but unknown data found

    Posted Thu April 22, 2010 12:14 PM

    Originally posted by: vijji_WTX


    thanks Rep..really nice explanation.... I will definatly take you on board if i am a PM for my project.... I am a small software Engineer in small co. Just kidding.....any way Allll the best man......for your next challenging role....:-)
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange