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.  Using a native xsd transformation with Linux

    Posted 12/16/15 08:18 AM

    Originally posted by: Rick Barendse


     

    I have made a very simple XML mapping in WTX version 8.4.1.2. This WTX map converts a xml input to a xml output. I have used the native xsd in stead of an mtt. Whitin Design studio (Windows) this works fine. So far so good. Even the map trace doesn't give an error.


    Also the same mapping for AIX doesn't give a problem.

     

    But when I compile and the map for linux and run it with command server get the next failure on Linux:

     

    "External Parser returned Error

          End of Validation message for INPUT CARD 1"

     

    In the map trace I find the next error: 

    <ExecutionSummary MapStatus="Warning" mapreturn="21" ElapsedSec="0.003"  BurstRestartCount="0">

        <Message>Input valid but unknown data found</Message>


    I also have put the xsd schema in the right directory on the Linux system.


    Does somebody recognizes this problem?

    Thanks in advance.

     


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


  • 2.  Re: Using a native xsd transformation with Linux

    Posted 12/17/15 05:53 AM

    Originally posted by: paul.brett


    Are you able to supply your XML/XSD pair?

    You say that you are using WTX 8.4.1.2 Design Studio.  Is this also the version used in both AIX and LINUX runtime?

    Turn on input tracing, and what does that tell you?

    How are you transferring your files to your AIX and LINUX systems?  (If you use the same program for both, are you ensuring you use the same transfer method?)

    Thank-you.

    Paul

    Follow me on Twitter


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


  • 3.  Re: Using a native xsd transformation with Linux

    Posted 12/17/15 06:18 AM
      |   view attached

    Originally posted by: Rick Barendse


    Dear Paul,


    Thanks for your reply.

    I have attached all the files in a zip file. The runtime versions are the same on AIX and Linux. As you can see, I have turned on the input tracing in the mms. Unfortunately this doesn't generated an extra file, except the mtr file. Very strange. I have attached the mtr file in the zip.

     

    Transfer method on both methods is sftp with Moba X-Term.

    I also just tried to run the same map on Windows 2008 with the command server (64 bit) version 8.4.1 (unfortunately I don't have version 8.4.1.2). There the same map runs without problems and generates an extra log file (see the attached file SO_xdsmtr.xml). I was expecting such a file also on Linux, but it isn't there. I also attached the mmc including the extra log file SO_xdsmtr.xml, which is not available on Linux after running the map.


    Thanks in advance for taking a look at this.

    Rick


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

    Attachment(s)

    zip
    Example.zip   8 KB 1 version


  • 4.  Re: Using a native xsd transformation with Linux

    Posted 12/17/15 06:56 AM

    Originally posted by: paul.brett


    My results with your compiled map:

    $ dtxcmdsv SO.lnx

    IBM WebSphere Transformation Extender(TM) Linux Command Server - version 8.4.1.2(4)_64bit
    Copyright 1998, 2014 IBM Corporation. All rights reserved.

    Map file: /nfshome/pbrett/maps/XmlLinux/tmp/SO.lnx
    In #  1:               0  Out #  0:               0  Time:    0:00              
    In #  1:              26  Out #  1:               0  Time:    0:00              
    In #  1:              26  Out #  1:               0  Time:    0:00              
    In #  1:              26  Out #  1:              26  Time:    0:00  Auditing Data
    In #  1:              26  Out #  1:              26  Time:    0:00              
    In #  1:              26  Out #  1:              26  Time:    0:00              
    Map completed (0):  Map completed successfully (0.243 seconds)

    So I guess that perhaps your installation is damaged?  Could you try a re-install, and perhaps go with WTX 8.4.1.3 instead?

    Thank-you.

    Paul

    Follow me on Twitter


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


  • 5.  Re: Using a native xsd transformation with Linux

    Posted 12/17/15 09:23 AM

    Originally posted by: Rick Barendse


    Hi Paul,


    Many tyhanks for trying! 

    Did you also get a valid SOOut.XML?

    The only configuration issue I can imagine is that we use WTX together with MQ 7.0. on the same Linux machines. I have tried the same map on different machines, all with an MQ installation on it. Probably there is a library issue.

    In meantime I will try to install the 8.4.1.3 version without MQ. 

    Regards,

    Rick


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


  • 6.  Re: Using a native xsd transformation with Linux

    Posted 12/17/15 11:50 AM

    Originally posted by: paul.brett


    The output file was 'shiporderOUT.xml' and was 454 bytes.

    Checksum:

    914938496 454 shiporderOUT.xml

    You might want to ensure WTX library directories are first in the LIBPATH (or equivalent).

    Thank-you.

    Paul

    Follow me on Twitter


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


  • 7.  Re: Using a native xsd transformation with Linux

    Posted 12/18/15 05:57 AM
      |   view attached

    Originally posted by: Rick Barendse


    Hi Paul,


    First path Libs path are directing to the wsdtx environment. So that's not the problem. I just found out something else which probably could be the problem. What I have done is the following:

    1. I have created and build the same map in 8.4.1.3 again and had the same problems. I have put the xsd, xml and the lnx map in the same directory.   

    2. I have renamed the xsd to another filename. So that the lnx cannot find the xsd.

    3. Then I have run the lnx map again. The result is still the same.


    It looks like al the time the map cannot find the xsd. Although the reference is in the Input card is referring to the xsd in the same dir. See also the attachment.

    Did you ever see this on Linux? This goes wrong on Redhat 6, Redhat 7, CentOS 6.7 and Ubuntu.

     

    Any ideas?

     

    Thanks in advance.

     


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


  • 8.  Re: Using a native xsd transformation with Linux

    Posted 12/18/15 11:43 AM

    Originally posted by: Rick Barendse


    Paul,

     

    Problem has been solved!

     

    we have profiled the envsetup. After doing this every WTX map works fine, incl. the WTX maps which uses mtt typetrees mad of xds's. But on Linux systems you need to profile the setup in the /opt/ibm/wsdtx directory.

     

    After doing this, the WTX maps who use native xsd's work also fine.

     

    Thanks for your help.


    Rick


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