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.  Initializing DataStageTX API failed

    Posted 04/05/07 03:39 PM

    Originally posted by: Staar


    We use the DSTX API in some programs to run maps. It's been working fine for a while now. The other day on 1 machine it began to fail. The error occurs after the Initialize command is issued. It returns 'Initializing DataStageTX API failed'. I compared the file dstxCOM.dll against all the other machines and it had the same size/modified date. I used a utility to find all the dependencies for dstxCOM.dll and all of the dependency files had the same size and modified date as well. The user does not use the API often so I'm not sure when the problem started. He did just apply vb6 service pack 6 the other day. I tried reinstalling the Development kit but it did not fix the problem. I'd really like to fix this problem without reinstalling everything. If this ever happens on a production server we'd have a lot of problems... Anybody have any thoughts on how to fix this problem?

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


  • 2.  Re: Initializing DataStageTX API failed

    Posted 04/05/07 04:58 PM

    Originally posted by: SystemAdmin


    Just a thought: did the installation of SP6 update or change paths that might be needed for the TX API to work? When checking the dependencies, did you do it as the user who runs the programs and maps? Perhaps something cannot be found anymore.

    Yvonne Ricard
    Resistance is NOT futile.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 3.  Re: Initializing DataStageTX API failed

    Posted 04/05/07 05:39 PM

    Originally posted by: Staar


    I used a tool that comes with visual studio 6 (depends.exe) to find the dependencies for dstxCOM.dll. I'm not sure how accurate the list is that depends.exe generated. I was at the users pc and was logged on as the user. I wonder if dstxCOM.dll gets installed during the DSTX portion of the install and not with the development kit.

    Tomorrow I'm going to check and see if he has any programs running in the background that did not terminate properly that might be using the dll. Maybe that's why it can't initialize. If that doesn't work I'll have to check what files are updated by VB6 SP6. I have SP6 on my machine as well, but I already had it before I upgraded to DSTX 8.0.

    Here was the list of dependencies that the depends.exe came up with. The size/modified date/time matched the files on all the other pcs that were working properly. Maybe one of them isn't registered properly. I reregistered dstxcom and dstxpi already. It's strange that it lets me declare and create the MFactory object but fails when I try to issue the InitializeAPI command. I would think one of those steps would fail if something was wrong with the dstxCOM dll. Hopefully I find a program running in the background that has a hold of it.

    c:\ascential\datastagetx_8.0\DSTXCOM.DLL
    c:\ascential\datastagetx_8.0\DSTXPI.DLL
    c:\ascential\datastagetx_8.0\ICUDT26L.DLL
    c:\ascential\datastagetx_8.0\ICUUC26.DLL
    c:\ascential\datastagetx_8.0\MSVCI70.DLL
    c:\ascential\datastagetx_8.0\MSVCP70.DLL
    c:\ascential\datastagetx_8.0\MSVCR70.DLL
    c:\ascential\datastagetx_8.0\XERCES-C_2_4_0.DLL
    c:\winnt\system32\ADVAPI32.DLL
    c:\winnt\system32\GDI32.DLL
    c:\winnt\system32\KERNEL32.DLL
    c:\winnt\system32\MSVCRT.DLL
    c:\winnt\system32\NTDLL.DLL
    c:\winnt\system32\OLE32.DLL
    c:\winnt\system32\OLEAUT32.DLL
    c:\winnt\system32\RPCRT4.DLL
    c:\winnt\system32\SHLWAPI.DLL
    c:\winnt\system32\USER32.DLL
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 4.  Re: Initializing DataStageTX API failed

    Posted 04/05/07 11:00 PM

    Originally posted by: SystemAdmin


    I was able to reproduce the same problem with my local installation of TX. For me, I was able to resolve it by starting a DOS command window, changing to my TX installation directory and running "regsvr32.exe %cd%\dstxCOM.dll".

    One other thing to check: If you specify a resource config file, it needs to be present and error-free.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 5.  Re: Initializing DataStageTX API failed

    Posted 04/09/07 01:02 PM

    Originally posted by: Staar


    We uninstalled everything, cleaned up the registry, and reinstalled everything. The problem still occurs. The install did show a couple errors that never appeared on previous installs. At the beginning of the installation of DSTX Extended Edition and DSTX Event Agent 8.0.1 the following error came up before the install program began copying files: The service cannot be installed due to an unknown error. Once you click on ok, it does not abort, and starts to copy files over. Anyone have any idea what the install program tries to do before it begins to copy files?
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 6.  Re: Initializing DataStageTX API failed

    Posted 04/09/07 05:38 PM

    Originally posted by: SystemAdmin


    This is probably happening because the service(s) are already installed and when it tries to install the service again, it errors. I have had the problem but never experienced adverse effects ... I was installing the same directory as before.

    Yvonne Ricard
    Resistance is NOT futile.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 7.  Re: Initializing DataStageTX API failed

    Posted 06/21/07 12:14 PM

    Originally posted by: Staar


    Problem has been solved. Support was able to make some suggestions that fixed the problem. We moved the DSTX Install directory to the beginning of the System Path variable and copied the program off the network to a local drive on the pc that was having the problem. It then began to work on the local drive but still failed when run from the network path. We figured that meant there was a dll conflict somewhere. We then looked for dll conflicts in: Computer Management - System Info - Software Environment - Loaded Modules and saw 2 instances of runmer32.dll. They had different sizes as well. One was located in the DSTX install directory and the other in System32. I checked another pc that was working and it only had it in the DSTX directory. It looks like the runmer32.dll in System32 was from the 6.7 version. The dll was not registered, so all we had to do was delete the dll in System32. The program then began working perfectly. It's strange since we use the DstxCom.dll and not the old runmer32.dll in the program. Thanks for all your help!

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


  • 8.  Re: Initializing DataStageTX API failed

    Posted 09/22/09 06:09 AM


  • 9.  Re: Initializing DataStageTX API failed

    Posted 09/22/09 06:13 AM

    Originally posted by: SystemAdmin


    Hi,

    I am using C-Sharp code for IBM Websphere transformation extender to run a simple map. When i run the code, I am getting this error "IBM Websphere transformation extender API failed". I have included proper dll file and have the mapping in the appropriate directory. Then also getting this error. Please help me out to solve this issue.

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