IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
Back to discussions
Expand all | Collapse all

MS SQL database - WTX Error - Input query not found

  • 1.  MS SQL database - WTX Error - Input query not found

    Posted 03/05/09 01:07 PM

    Originally posted by: SystemAdmin


    I am working on WTX 8.2.0.3.
    I have a SQLServer.mdq file, where the configurations are for the MS SQL Server.
    I have defined 3 datasources in them with each one having queries as follows
    DB1 - Q11, Q12
    DB2 - No queries
    DB3 - Q31
    In the card settings, if I am giving DB1, then in the query field, Q11 and Q12 are populating and I can select the required query.
    But when I am selecting DB3, the required queries are not populating immediately. But if I close the card and open it, then it populates with Q31.
    My issue is, when I build the map, I am getting the following Build Error Message

    M1027 ERROR:
    Input query not found:
    InCard1

    Please help. Any suggestions to solve this are welcome. Are the new settings not retained?? PS. It works fine in 7.5.

    For the present I have done a workaround by creating a second .mdq file and defining only the DB3 data source and calling the required query.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


Related Content