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.  Problem reading from a remote directory

    Posted 11/17/09 03:14 AM

    Originally posted by: mwanaheri


    Good Morning,

    we have a little strange problem here reading files from a different server.
    A map tries to get files from a different machine (eg. //fileserver/Directory/filename.txt) That name has been set both in the map and in the IFD. If I run that map directly (simple double click), it works ok, reads the file an processes it. If I try to run the map from the launcher, all I get is an 'Input not found' message.
    The same happens, if the remote directory is hooked in on the machine, to form a path like X:\Directory\file.

    WTX has been started with the same user who can run the map directly, all systems are windows 2003 server machines.

    Does anybody have an idea how to fix this?
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: Problem reading from a remote directory

    Posted 11/17/09 09:55 AM

    Originally posted by: repanzer


    "The same happens, if the remote directory is hooked in on the machine"
    Do you mean if the directory is set up as a network drive?? Are they both window's machines?

    One path looks like Unix; //fileserver/Directory/filename.txt

    the other windows;

    X:\Directory\file.
    And when you double click the map, you mean on the server where it's deployed under launcher?
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: Problem reading from a remote directory

    Posted 11/17/09 12:09 PM

    Originally posted by: mwanaheri


    Sorry, in confused the slashes in my post. Yes, both machines are windows machines. Whether I connect the fileserver as a network drive or not does not make a difference. I can execute the map on the server on which it is deployed under launcher. I can launch it there also, but then it doesn't find the file it should read.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 4.  Re: Problem reading from a remote directory

    Posted 11/17/09 02:47 PM

    Originally posted by: repanzer


    Sorry, in confused the slashes in my post. Yes, both machines are windows machines. Whether I connect the fileserver as a network drive or not does not make a difference. I can execute the map on the server on which it is deployed under launcher. I can launch it there also, but then it doesn't find the file it should read.
    Well, I'm on Unix now, but my last enviroment was Windows and I had built a communcation system which used to sweep folders on other Windows boxes on the intranet.
    We would either use a mapped network drive on the box;

    X:\folder\input\inputfile.txt
    or we'd reference the server by the univeral path name; (or what ever it's called)

    \\servername\folder\input\inputfile.txt
    The first thought was whether the username launcher is running under had access. I've hit that issue before. I believe you set up the username under "services".

    But actually; when you log in an "double click" it, you have to log onto that box somehow, yeah? And the ID you log in with may carry over when you double click the map, which may not be the same as the ID launcher is running under, unless you log in under the same username?

    Overall, if the input in the input card to the map is the same exact string in the input card for system file (msl), and the map will grab it when you run it, it should work fine with launcher running it. That's why my thinking is revolving around access and that being your problem. At this point, I would look at the audit log for both, the map when you run in manually and when you run it under launcher, then ensure that the input is the same. After that, I would check the log files under the WTX install\logs directory, which should show you exactly the file the msl is pointing too (below).

    While I don't believe it's the problem, when accessing the folder using the universal method;

    \\servername\folder\input\inputfile.txt
    The folder may look like that, but if you were logged onto the file server you're getting the file from, it may look different, something like;

    c:\program files\someotherfolder\folder\input\inputfile.txt.

    And it's not gettig resolved correctly at run time.

    WTX log file I would check;
    • WebSphere Transformation Extender Launcher for HP-UX(TM)

    Version: 8.1(114)
    Copyright (c) 2006 IBM Corporation. All rights reserved.

    Started: Tue Nov 17 00:25:57 2009
    Computer: nj008hps

    Logging: Configuration, Start Up, Errors, Warnings

    Note: This file views correctly under fixed font editors.

    ==============================================================================

    • CONFIGURATION:

    Time: Tue Nov 17 00:25:57 2009



    Watch: 1
    MSL File: /opt/DataStageTX/Ascential/Communication/System/FTPTraceRead.msl
    System: FTPTraceRead
    Component: FTPTrace
    Map: /opt/DataStageTX/Ascential/Communication/Maps/FTPTrace.mmc

    Priority: Normal
    Map Delay: 2000 ms.
    Pending Exp.: <none>
    Retries: <none>

    Paging: 8 X 64K

    Trace: <none>

    Validation: Ignore: <none>
    Stop On First Error: Yes

    Work Area: Default - Delete -

    Max Instances: 0

    Init High: 0
    Init Low: 0

    Time Trigger: <none>

    Input 1 (T): File: /opt/DataStageTX/Ascential/Communication/FTPTrace/*.*
    Rollback: Yes, Delete: Yes, Reuse Work File: No
    Retries: <none>
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 5.  Re: Problem reading from a remote directory

    Posted 11/19/09 08:20 AM

    Originally posted by: mwanaheri


    Hello repanzer,

    thank you very much for your detailed response. The universal method finally did the trick. However, it did not work with the servername, but with the server's IP-number
    So \\servername\directory\file failed, \\serverIP\directory\file succeeded. None of the logs could explain me why, but I'll take it as it is for now.

    regards

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


  • 6.  Re: Problem reading from a remote directory

    Posted 11/19/09 09:02 AM

    Originally posted by: Kepa_Screen


    There could be several reasons for this.

    One is that your server is not reaching to your company DNS server.

    One test you could do is to put your hostname & ip at hosts file at windows server where the Launcher is installed.

    Don't know exactly where it resides but must be something like \windows\system32 or \windows\drivers\etc\

    There you must put "server ip" and "server name"

    
    127.0.0.1      localhost 192.168.10.1   dns_server 172.22.80.13   proxy.company.com 172.22.80.77   wstx_server.company.com
    


    Then you must reboot server , and it will work fine using the name of the host.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 7.  Re: Problem reading from a remote directory

    Posted 11/19/09 09:06 AM

    Originally posted by: repanzer


    No problem. Being I've built similar maps and have not encountered this issue, so it would have stumped me if I hit it in the future, but now I'll have another debug option to check, so it worked out for both of us.

    Just to know exactly why, I would probably ping the server name from the box to make sure the DNS entry is set up correctly, and maybe that's the reason? Possibly the box doesn't have access to the DNS server, so it can't resolve the name? I do recall using the server name of our box and not the IP address, so I know it should definitely work.

    The only thing is now if that ip changes, you'll need an update, being you're using the raw ip and not the DNS entry.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 8.  Re: Problem reading from a remote directory

    Posted 11/21/09 02:06 PM

    Originally posted by: repanzer


    I was writing my response as Kepa_Screen was posting his, and we're both pointing to the DNS. I would definitely research this, as you definitely want to use the DNS entry and not the raw IP. The way he put it rang a bell way in the back of my mind, a if I had this same issue when I was on windows, but that was a while ago, but I may have had to reach out to the team who supported the DNS server and mention this to them.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender