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.  WTX not able to find query

    Posted 04/30/18 05:08 PM

    Originally posted by: Bragger


    Hi All,

    I am using below syntax to call a child map with override input card settings.

     RUN("ChildMap", "-ID1 '-MDQ ABC.MDQ -DBNAME %DbBrt% -USER %DbBrtUser% -PASSWORD %DbBrtPwd% -Query HEADER" )

    This map is working fine on my local windows 7 system but same map when deployed on Sterling Integrator B2B is not working. I am getting below error on server:

    <SourceReport   card="1"   adapter="DB"   bytes="0"   adapterreturn="-1025">

       <Message>The specified query could not be found</Message>

       <Settings>-MDQ ABC.MDQ -DBNAME ###-USER ###-PASSWORD ***** (%DbBrtPwd%) -Query HEADER</Settings>

    </SourceReport>

     

    Does anyone know why Sterling is not able to resolve this Query whereas on local system it is working fine?


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


  • 2.  Re: WTX not able to find query

    Posted 05/01/18 03:19 AM

    Originally posted by: PaulBrett


    Did you check that the MDQ file on your SI machine actually has a query called 'HEADER' in it?

    Perhaps do a file comparison and checksum of the MDQ file on both systems to confirm they are exactly the same.

    As a test, rename the MDQ, to check that the file you think is being accessed is the correct one (you should get an MDQ not found message).

    Thank you.

    Paul

    Follow me on Twitter


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


  • 3.  Re: WTX not able to find query

    Posted 05/01/18 11:46 AM

    Originally posted by: Bragger


    Yes Paul. Already checked twice and MDQ file names, Queries are all matching. Do you know any other reason why this might be happening?


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


  • 4.  Re: WTX not able to find query

    Posted 05/02/18 04:28 AM

    Originally posted by: PaulBrett


    I do not, and if you open a PMR with IBM, my first suggestion would be a remote diagnostic session.

    Thank you.

    Paul

    Follow me on Twitter


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