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.  MQSeries / WebSphere MQ

    Posted 01/21/11 03:39 AM

    Originally posted by: Kepa_Screen


    Hi:

    I'm having some trouble with an MQSeries Queue that we want to access.
    We usually work with Oracle AQ, but i'm involved in a new project that needs to monitor some MQSeries / WebSphere MQ status . This Queues reside on AS400 servers.

    I'm creating a Test Map, just in order to read the contents of a Queue, and test if this Queue is up, or not. ( The real need is just to monitor the Queue, reading but letting the content inctact ).

    We are a little lost with MQSeries ( i'm newbiee to this ones )

    I created Test.mms, one input card, using mq.mtt from Examples source. One output card, just a simple Text Field for getting "MessageData MQSeries" field from imput.

    I use "IBM WebSphereMQ (client)" adapter and this command:

    
    -QN SILO2INF -QMN gsilo8381 -CD CSILO8381/TCP/172.22.21.60(28381) -T traza.log -LSN 3 -HDR -QTY S
    


    There is source ( map errocode :12 ) and this is the audit:

    
    <MapAudit StartTime=
    "09:36:52 January 21, 2011">   <Platform> Command Server 
    
    for Windows - Version 8.1(38)</Platform>   <ExecutionSummary MapStatus=
    "Error" mapreturn=
    "12" ElapsedSec=
    "0.0712" BurstRestartCount=
    "0"> <Message>Fuente no disponible</Message> <CommandLine>
    'C:\subversion\esai\desarrollo\Aprovisionamiento\fuente\mercator\mms\prueba.mmc'</CommandLine>   <SourceReport   card=
    "1"   adapter=
    "IBM WebSphereMQ (client)"   bytes=
    "0"   *adapterreturn=
    "-99999">* <Message>No se ha encontrado el adaptador</Message> <Settings>-QN SILO2INF -QMN gsilo8381 -CD CSILO8381/TCP/172.22.21.60(28381) -T traza.log -LSN 3 -HDR -QTY S</Settings> </SourceReport>   </ExecutionSummary>   </MapAudit>
    

    I'm running this locally in designer WSTX 8.1.0.4

    am i missing something about the installation ? ....i can see mq.jar file.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: MQSeries / WebSphere MQ

    Posted 01/23/11 03:56 PM

    Originally posted by: MJamalNasir


    Hi Kepa,

    The Error message from the "MapAudit" say you are not able to access the Source. I do not know how you are trying to access the queue, the first question comes to mind...have you set the proper authorization after creating this queue? Please check the command to set the proper authorization with "setmqaut", I think this is your problem.

    Good Luck, Jamal
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange