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.  execution return code

    Posted 07/19/06 05:45 AM

    Originally posted by: SystemAdmin


    Hello,

    One of our maps is executed by a shell script in two different environments. The map is completed successfully in both environement but the return code is

    The execution traces are the following:
    b:db644cbef3Environment 1:[/b:db644cbef3]

    Executing /BBL/ADVANTAGE/aaa dstx /ING/ADVANTAGE/gateway/mmc/SFI/MAPS/SFI_Main_Trading_Place.sun ...
    • DEBUG *** >NONE<

    INFO - Output of >/BBL/ADVANTAGE/aaa<:
    - >AAAHOME is /BBL/ADVANTAGE
    Executing /BBL/ADVANTAGE/bin/SunOS/dstx.sh /ING/ADVANTAGE/gateway/mmc/SFI/MAPS/SFI_Main_Trading_Place.sun

    Ascential DataStage(TM) TX Solaris(TM) Command Server - version 7.5(119)
    Copyright (c) 2004 Ascential Software Corporation.

    Map file: /ING/ADVANTAGE/gateway/mmc/SFI/MAPS/SFI_Main_Trading_Place.sun
    In # 1: 0 Out # 0: 0 Time: 0:00
    In # 2: 25 Out # 0: 0 Time: 0:00
    In # 2: 64 Out # 0: 0 Time: 0:00
    In # 2: 83 Out # 1: 0 Time: 0:01
    In # 2: 83 Out # 1: 0 Time: 0:01
    In # 2: 83 Out # 2: 1 Time: 0:01
    In # 2: 83 Out # 3: 4 Time: 0:01
    In # 2: 83 Out # 3: 9 Time: 0:12

    Map completed (0): Map completed successfully (1155.878 seconds)

    <

    ... DONE !!!

    hci@sbudb: /hci/root/imca0001/scripts % echo $?
    0

    b:db644cbef3Environment 2:[/b:db644cbef3]

    Executing /BBL/ADVANTAGE/aaa dstx /ING/ADVANTAGE/gateway/mmc/SFI/MAPS/SFI_Main_Trading_Place.sun ...
    • DEBUG *** >CHILDSTATUS 12142 156<

    INFO - Output of >/BBL/ADVANTAGE/aaa<:
    - >AAAHOME is /BBL/ADVANTAGE
    Executing /BBL/ADVANTAGE/bin/SunOS/dstx.sh /ING/ADVANTAGE/gateway/mmc/SFI/MAPS/SFI_Main_Trading_Place.sun

    Ascential DataStage(TM) TX Solaris(TM) Command Server - version 7.5(119)
    Copyright (c) 2004 Ascential Software Corporation.

    Map file: /ING/ADVANTAGE/gateway/mmc/SFI/MAPS/SFI_Main_Trading_Place.sun
    In # 1: 0 Out # 0: 0 Time: 0:00
    In # 2: 23 Out # 0: 0 Time: 0:01
    In # 2: 64 Out # 0: 0 Time: 0:01
    In # 2: 81 Out # 1: 0 Time: 0:01
    In # 2: 81 Out # 1: 0 Time: 0:01
    In # 2: 81 Out # 2: 1 Time: 0:01
    In # 2: 81 Out # 3: 4 Time: 0:01
    In # 2: 81 Out # 3: 9 Time: 0:07

    Map completed (0): Map completed successfully (386.315 seconds)

    <

    ... DONE !!!

    hci@sguef: /hci/root/imca0001/scripts % echo $?
    1

    Could you help me to understand ?

    Thanks,

    Regards,

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


  • 2.  Re: execution return code

    Posted 07/19/06 06:00 AM

    Originally posted by: SystemAdmin


    I see the same return code from the map. Have you checked to see if the shell scripts are identical?

    I do see differences in the data and the execution time of the map, this might have some bearing on what the script is seeing.

    What is in the script?
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: execution return code

    Posted 07/19/06 06:31 AM

    Originally posted by: SystemAdmin


    Yes, the input data and the execution time of both maps are differents but we are sure these parameters don't affect the execution.
    We have seen that Sun Solaris versions are different on both servers....
    Could this fact affect the return code ?
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 4.  Re: execution return code

    Posted 07/19/06 06:40 AM

    Originally posted by: SystemAdmin


    It shouldn't, but what are the versions.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 5.  Re: execution return code

    Posted 07/19/06 07:52 AM

    Originally posted by: SystemAdmin


    Sun Solaris:
    8 2/02 s28s_u7wos_08a
    and
    8 2/04 s28s_hw4wos_05a
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 6.  Re: execution return code

    Posted 07/20/06 10:47 AM

    Originally posted by: SystemAdmin


    Thats not it. Not enough difference
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender