IBM Sterling Transformation Extender

Sterling Transformation Extender

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

 View Only
  • 1.  input valid but unknown data found/One or more inputs was invalid

    Posted Wed March 25, 2009 04:29 PM

    Originally posted by: SystemAdmin


    Hi,
    I have a map that is NOT a run map. It watches a file coming in to run.

    First thing the map does (and this is a default function), it validates the input file against the input type tree(s)

    When I had some type of error like:

    input valid but unknown data found OR
    One or more inputs was invalid

    The map ended without further processing. Do you know how to generate the error from this type tree validating?
    I tried to create an output card to send out the lasterrorcode() and lasterrormessage () but it does not even touch the output so no message was generated.

    Please advise if you can.
    Thanks
    Huong
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: input valid but unknown data found/One or more inputs was invalid

    Posted Wed March 25, 2009 04:30 PM


  • 3.  Re: input valid but unknown data found/One or more inputs was invalid

    Posted Thu March 26, 2009 09:07 AM

    Originally posted by: repanzer


    "First thing the map does (and this is a default function), it validates the input file against the input type tree(s)"

    Really?

    Try turning on the trace file in the map settings. That will show you exactly how the input file validated against the type tree, field by field and point to the error (Most of the time). You may have to fish for the problem, but it's in the trace file.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 4.  Re: input valid but unknown data found/One or more inputs was invalid

    Posted Thu March 26, 2009 09:26 AM

    Originally posted by: NancyR


    If you're trying to have your map process the valid records and capture some information about the rejected records, put a Restart attribute on the repeating records in your type tree. You can then create an output card in your map to capture the rejected records using the REJECT function.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 5.  Re: input valid but unknown data found/One or more inputs was invalid

    Posted Thu March 26, 2009 09:54 AM

    Originally posted by: SystemAdmin


    thank you for your inputs but I think you miss understood my question. What I need is when the map fails with "input is invalid..", I need to send out an email to notify me (or my team) that map fail because of bad file. Then we have to look further for the problem.
    I know how to turn on trace. But when the map fails because it validates the type tree, I have no way of capturing the message to notify us.
    Does it make sense?
    thx
    Huong
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 6.  Re: input valid but unknown data found/One or more inputs was invalid

    Posted Thu March 26, 2009 10:21 AM

    Originally posted by: janhess


    Use the auditlog map to send out the email on a failure.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 7.  Re: input valid but unknown data found/One or more inputs was invalid

    Posted Thu March 26, 2009 10:29 AM

    Originally posted by: Kepa_Screen


    You must switch on Audit Logs on yout maps, and use Audit Log map ( you can find it at examples\general\audit\ )

    Then you can use this map in order to mail to you ( obviously, this map needs to be changed in order to specify correct host for mail, user that will receive this mails, paths of incoming files, etc..., but it's really easy to do this ).

    Then put this audit map into a system and configure Launcher in order to use it, with maps audit log files as source.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 8.  Re: input valid but unknown data found/One or more inputs was invalid

    Posted Thu March 26, 2009 10:56 AM

    Originally posted by: SystemAdmin


    I will look into your suggestion. I will let you know later. thanks. Huong
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 9.  Re: input valid but unknown data found/One or more inputs was invalid

    Posted Thu March 26, 2009 11:15 AM

    Originally posted by: repanzer


    I just wrote this for a different thread;

    "Every shop using DataStage should have a system to read the audit logs and report the results of failures automatically. The type tree for the audit log is supplied and it’s fairly easy to set up."
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender