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.  Integrate WTX Map in WMB 7.0 message flow

    Posted 10/03/11 07:42 AM

    Originally posted by: halekote


    Hi All,

    Can anyone please let me know how WTX Map node should ignore the message which coming from WMB flow?

    Basically, WTX Map sould run the source adapter command (GET) to read the files from FTP instead of using the message which is coming from WMB flow.

    My message flow as below.

    MQInput node ->Compute node-> WTX Map node -> Compute Node ->MQOutput node.

    Thanks in advance for your help.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: Integrate WTX Map in WMB 7.0 message flow

    Posted 10/03/11 07:48 AM

    Originally posted by: Dhiren.Ghelani


    a. try defining a collection with no data elements.
    b. Why would you not just set your input to a blob of data without max size and ignore it (i.e. dont use it in your map)
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: Integrate WTX Map in WMB 7.0 message flow

    Posted 10/03/11 09:01 AM
      |   view attached

    Originally posted by: halekote


    Thanks a lot Diren for your quick response.

    1.Currently my Map is containing two input cards with FTP command to read file names from FTP server as below.
    -URL FTP://GIB_USER:PWD@host:21/data/D2991/Clarity/BUDGET2SLAM*.xml;type=D
    and my Map rule is =input_card2 and am not mapping/using input_card1 in Map rule to ignore the message which is coming from WMB flow.

    2.In my WMB message flow, i have configured input_card1 to get the message from WMB i.e *Card number to wire ->1*(input tab of WTX node) so that WTX Map will run using the Command.

    But, still sometimes i will get a message saying Source not avaiable in my Audit Log even though XML file is available(sometime it fails and sometime it will be successful).

    Thank for your help in Adavnce!
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 4.  Re: Integrate WTX Map in WMB 7.0 message flow

    Posted 10/03/11 09:15 AM

    Originally posted by: Dhiren.Ghelani


    Thats strange. What does the source card show in the audit log? can you upload a copy of your audit?
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 5.  Re: Integrate WTX Map in WMB 7.0 message flow

    Posted 10/03/11 09:53 AM
      |   view attached

    Originally posted by: halekote


    Thanks Diren.

    Please find attached tha Audit log again.

    Source report contains below message :
    <SourceReport card="1" adapter="Stream" bytes="0" adapterreturn="0">
    <Message>Success</Message>
    <TimeStamp>12:40:01 October 3, 2011</TimeStamp>
    </SourceReport>

    <SourceReport card="2" adapter="FTP deprecated" bytes="0" adapterreturn="-421">
    <Message>*Timeout (300 seconds): closing control connection.*</Message>
    <Settings>-URL FTP://GIB_USER:PWD@host:21/data/D2991/Clarity/BUDGET2SLAM*.xml;type=D</Settings>
    </SourceReport>

    Please check and let me know if i missed out anything!
    thanks again
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 6.  Re: Integrate WTX Map in WMB 7.0 message flow

    Posted 10/03/11 10:09 AM

    Originally posted by: Dhiren.Ghelani


    In the example below, IC2 is failing and this is the reason why you are seeing a Source not Available.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 7.  Re: Integrate WTX Map in WMB 7.0 message flow

    Posted 10/04/11 09:45 AM
      |   view attached

    Originally posted by: halekote


    Thanks Diren.

    Yes, IC2 is failing with below message; but why it is failing even though all FTP connection parameters and file is availavle at source directory.
    <Message>Timeout (300 seconds): closing control connection.</Message>

    And IC2 will fail once in a while while looking for a files using below FTP command.
    -URL FTP://GIB_USER:PWD@host:21/data/D2991/Clarity/BUDGET2SLAM*.xml;type=D

    what could be the reason for the failure?

    thanks in Advance for your quick response.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 8.  Re: Integrate WTX Map in WMB 7.0 message flow

    Posted 10/04/11 10:12 AM

    Originally posted by: SystemAdmin


    Hi,

    The only issue is the FTP syntax. The syntax should be as below:

    -URL FTP://GIB_USER:PWD@host:21//data/D2991/Clarity/BUDGET2SLAM*.xml;type=D

    You need an extra slash to separate the login credentials and the host parameters from file location.

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


  • 9.  Re: Integrate WTX Map in WMB 7.0 message flow

    Posted 10/04/11 01:06 PM

    Originally posted by: halekote


    Thanks pcp.

    Still am getting this error sometime after including the slash between credentials and host information.
    Below is the FTP Command:
    -URL FTP://UID:PWD@Dedusftp//data/D2991/Clarity/BUDGET2SLAM*.xml;type=D

    But, My map has input cards and both are using the above same FTP commands. IC1 will recieve message from WMB message flow and ignores it(not used in any rule) and IC2 will get the file names by running the above FTP Command.

    is this causing the problem?

    any help is much appreciated!
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 10.  Re: Integrate WTX Map in WMB 7.0 message flow

    Posted 10/04/11 04:12 PM

    Originally posted by: jvanboga


    Unless the extra slash is required in 8.2 or 8.3 or required by WMB our commands haven't required it to work in versions 6.0 thru 8.1. The most recent document states this is the format unless you have other requirements like a firewall... '//user:password@host:port/url_path'

    Try using the '-trace' option and look at the trace file.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender