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

    Posted 12/27/07 12:33 PM

    Originally posted by: DianeC


    I am trying to run dtxpage on a map and I'm not sure if I'm doing this right. The first time I tried "dtxpage mapname" and got return code 3072. A search on that told me to make sure I can run the map alone first, which I can. I tried it again, adding the overrides for inputs and got the same return code 3072.

    When I use dtxcmdsv, (using overrides for input) the map runs fine. So, then I tried combining the 2 commands: "dtxpage dtxcmdsv map.mmc -IF1 nnnnn -IF2 nnnnn -IF3 nnnnn" and got "Map dtxcmdsv has return code 768. dtxpage exiting."

    I tried to search for the 3072 return code, but nothing comes up on the IBM site anywhere. I checked the error codes for AIX, and nothing there.

    We're running on AIX 5.2, WTX (with Launcher) version 8.1.0.1.

    Can anyone tell me what I'm doing wrong?
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: Unknown return code

    Posted 12/27/07 03:58 PM

    Originally posted by: SystemAdmin


    Being I don't even know what dtxpage is, I doubt I can help, but this thread came up when I google-ed it.

    http://www-128.ibm.com/developerworks/forums/thread.jspa?threadID=164479

    good luck.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 3.  Re: Unknown return code

    Posted 12/28/07 06:37 AM

    Originally posted by: DianeC


    If you read what the answer was - it was to make sure you can run the map from the command line. I can do that.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 4.  Re: Unknown return code

    Posted 12/28/07 09:36 AM

    Originally posted by: SystemAdmin


    I did read it, and it also mentioned about moving it over binary, which you I didn't see in your post.

    Gosh, I was only trying to help.

    :(

    Message was edited by: rep
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 5.  Re: Unknown return code

    Posted 12/28/07 10:24 AM

    Originally posted by: DianeC


    If you don't transfer binary, the maps don't run. Therefore, if I can run the map, I must've transfered it binary.

    Thanks for trying though.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 6.  Re: Unknown return code

    Posted 12/28/07 02:57 PM

    Originally posted by: SystemAdmin


    I've never heard of the dtxpage command before this thread, but it looks interesting.

    Maybe try the command with a dummy mapname to see what gets returned, just ensure the command is seeing the map. In the documentation, is says:

    See ″Troubleshooting″ for details about capturing and evaluating the return code resulting from the execution of this utility command.

    Under troubleshooting it says:

    ERRORLEVEL environment variable

    To retrieve the value of the ERRORLEVEL variable, run the following DOS command.
    ECHO % ERRORLEVEL %

    Utility commands return the following valid values in the ERRORLEVEL variable:
    Return Code Description

    0 This value indicates that the utility command was successful.

    1 This value indicates that the utility command was not successful.

    The ERRORLEVEL variable can also be used in batch files to retrieve the value of the return code.

    Being it's DOS, I'm not sure if that helps though.
    I also see a dtxprof command.

    dtxprof is the name of the utility command used to analyze map execution behavior. The output file name and compiled map name (.mmc) are required fields.

    The following is the syntax of the dtxprof utility command:

    dtxprof -fs -ts -d -o output_file -dtx "map_name map_options
    Maybe run that one against the map to see what happens?

    I'll shut up now.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 7.  Re: Unknown return code

    Posted 12/28/07 03:41 PM

    Originally posted by: SystemAdmin


    When I put a dummy map name, I got the 768 error.

    $ dtxpage testasdfasf.mmc

    IBM WebSphere Transformation Extender
    Page Setting Assistant for Maps - version 8.1(114)
    Copyright (c) 2006 IBM Corporation. All rights reserved.

    Map testasdfasf.mmc has return code 768. dtxpage exiting.
    ga009hds edigis $
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 8.  Re: Unknown return code

    Posted 01/04/08 11:45 AM

    Originally posted by: SLWatts


    The syntax is: dtxpage followed by the name of the executable map.

    For example:

    dtxpage mymap.mmc

    If the map is not in the same directory, you need to supply the path.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 9.  Re: Unknown return code

    Posted 01/07/08 09:55 AM

    Originally posted by: DianeC


    "dtxpage /edi/cbc/maps/H837i_A1_DB.mmc -IF1 /edi/c......." - - this is what I am typing in on the command line.


    IBM WebSphere Transformation Extender
    Page Setting Assistant for Maps - version 8.1(114)
    Copyright (c) 2006 IBM Corporation. All rights reserved.

    Map /edi/cbc/maps/H837i_A1_DB.mmc has return code 3072. dtxpage exiting.


    That's the message I am still getting. I don't know for sure what the 3072 means. When I run the map outside of 'dtxpage', it runs good and I get a good return, I get the correct output, no error messages, and the log says "...completed successfully".

    Message was edited by: DianeC

    Message was edited by: DianeC
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender