IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
 View Only

  • 1.  MQ Client Adapter Configuration

    Posted Wed July 05, 2017 05:57 AM

    Originally posted by: johnxp


    Hi, anyone can help me on getting MQ Adapter work?

    OS: Windows 2012 R2 server.

    What I did:

    1. Install MQ Server 7.5

    2. Install MQ Client 7.5

    3. Create Queue manager (WTX.QM Port:1415) and Queue (WTX.SEND)

    4. Create Server-Connection Channel (WTX.CLNT.CONN)

    5. Create Client-Connection Channel (WTX.CLNT.CONN)

    6. Set System Variable MQSERVER=WTX.CLNT.CONN/TCP/127.0.0.1 (1415)

    7. Run map to put data to WTX.SEND, getting below the error:

    ---

    <3128-1680-07/05/17 17:53:49>: FULL TRACE ON
    <3128-1680-07/05/17 17:53:49>: Adapter command: -QMN WTX.QM -QN WTX.SEND -T ..\Logs\Maps\MQSCTrace.log
    <3128-1680-07/05/17 17:53:49>: [intm4mqsCheckAdapterCommand]
    <3128-1680-07/05/17 17:53:49>: [intm4mqsCheckAdapterCommand] (rc = 0) OK
    <3128-3832-07/05/17 17:53:49>: [m4mqsConnect]
    <3128-3832-07/05/17 17:53:49>: | [intm4mqsPopulateConnOption]
    <3128-3832-07/05/17 17:53:49>: | | INFO: WTX MQ adapter connection options have NOT been set.  To set options when connecting to MQ, use this environment variable setting:
      WTX_ADAPTER_MQS_CONN_OPTION=<decimal value> or 0x<hex value>
      For example, in order to use isolated binding, define the following environment variable with a hex value before starting WTX on a UNIX platform:
      export WTX_ADAPTER_MQS_CONN_OPTION=0x00000200
    <3128-3832-07/05/17 17:53:49>: | [intm4mqsPopulateConnOption] (rc = 0) OK
    <3128-3832-07/05/17 17:53:49>: | MQCONN, hQueueManager = -1 QMN=<WTX.QM> size=48 lCC=2 RC=2035 RET=1
    <3128-3832-07/05/17 17:53:49>: | MQSeries error (ReasonCode = 2035)
    <3128-3832-07/05/17 17:53:49>: [m4mqsConnect] (rc = -13) *** ERROR ***
    <3128-1680-07/05/17 17:53:49>: Destroying trace object in m4mqsDestroyAdapterInstance

    ---

     


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


  • 2.  Re: MQ Client Adapter Configuration

    Posted Wed July 05, 2017 06:22 AM

    Originally posted by: GertieKearney


    Hi,

    You are encountering MQ error 2025.

    Extract of the MQ trace log follows...

    <3128-3832-07/05/17 17:53:49>: | MQSeries error (ReasonCode = 2035)

    The following link contains information about the MQRC_NOT_AUTHORIZED error message

    http://www-01.ibm.com/support/docview.wss?uid=swg21166937

     

    Gertie.

     


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


  • 3.  Re: MQ Client Adapter Configuration

    Posted Wed July 05, 2017 10:21 PM

    Originally posted by: johnxp


    Hi Gertie,

    I followed the instructions from the link you provided, still got the same error.

    C:\Program Files (x86)\IBM\WebSphere MQ\bin>dspmqaut -m WTX.QM -n WTX.SEND -t q -p stpadm
    Entity stpadm has the following authorizations for object WTX.SEND:
    get
    browse
    put
    inq
    set
    crt
    dlt
    chg
    dsp
    passid
    passall
    setid
    setall
    clr

    Error:

    <800-1556-07/06/17 10:15:18>: FULL TRACE ON
    <800-1556-07/06/17 10:15:18>: Adapter command: -QMN WTX.QM -QN WTX.SEND -T ..\Logs\Maps\MQSCTrace.log
    <800-1556-07/06/17 10:15:18>: [intm4mqsCheckAdapterCommand]
    <800-1556-07/06/17 10:15:18>: [intm4mqsCheckAdapterCommand] (rc = 0) OK
    <800-2560-07/06/17 10:15:18>: [m4mqsConnect]
    <800-2560-07/06/17 10:15:18>: | MQCONN, hQueueManager = -1 QMN=<WTX.QM> size=48 lCC=2 RC=2035 RET=1
    <800-2560-07/06/17 10:15:18>: | MQSeries error (ReasonCode = 2035)
    <800-2560-07/06/17 10:15:18>: [m4mqsConnect] (rc = -13) *** ERROR ***
    <800-1556-07/06/17 10:15:18>: Destroying trace object in m4mqsDestroyAdapterInstance

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


  • 4.  Re: MQ Client Adapter Configuration

    Posted Wed July 05, 2017 11:46 PM

    Originally posted by: johnxp


    Refer to this link:

    https://stackoverflow.com/questions/25911557/websphere-mq-v8-mqrc-not-authorized-2035

    My problem solved.

    ALTER QMGR CHLAUTH(DISABLED)

     


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


Related Content