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.  Fail Function Abort map.

    Posted 08/09/10 05:27 PM

    Originally posted by: KumarP


    Hi Folks,
    I am new to this forum, recently i have been assigned to work on WTX and i am facing a issue at run time whcich is "Fail Function Abort map" when i put break ppoint and started to debug it i found error in DBLOOKUP function and the error code is 1069. but the same map is working fine in my colleague's PC. I gave the ODBC connectionections properly in my PC and not sure why this problem is still there.
    any help is greatly appreciated.
    thanks!!
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: Fail Function Abort map.

    Posted 08/10/10 01:47 PM

    Originally posted by: jvanboga


    "-1069 Required command line options missing"

    It might help if you display your dblookup, and/or your dbl (database log) file, but it looks like your cmd is incorrect or you are missing an item. Are you referencing an mdq file? If so, is it where the map thinks it should be?
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: Fail Function Abort map.

    Posted 03/04/11 04:47 PM

    Originally posted by: SystemAdmin


    jvanboga wrote:
    "-1069 Required command line options missing"

    It might help if you display your dblookup, and/or your dbl (database log) file, but it looks like your cmd is incorrect or you are missing an item. Are you referencing an mdq file? If so, is it where the map thinks it should be?

    I understand this part, Thanks for your instruction!
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 4.  Re: Fail Function Abort map.

    Posted 03/10/11 02:29 PM

    Originally posted by: FormerBuckeye


    Remember that a "Fail function Abort map" message in the audit file is caused by someone programming a map rule using the FAIL function. For example:

    =IF ( ADDDAYS ( TEXTTODATE(Inquiry Date Field:Carrier:InCarrier Record:Prop_Response ) , 30) > CURRENTDATE( ) , Inquiry Date Field:Carrier:InCarrier Record:Prop_Response , FAIL("Inquiry date more than 30 days old"))

    This has caught a number of my trading partners sending back response files based on inquiry files from previous months.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange