Error while using MQ Connector stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
basav_ds
Participant
Posts: 24
Joined: Sun Nov 11, 2007 11:19 pm
Location: Mumbai

Error while using MQ Connector stage

Post by basav_ds »

Hi,
i am reading xml messages from MQ(Normal) stage in job. The credentials i am giving here is Q Manager Name and Q Name. I can see the message content by clicking View Data in MQ satge(normal) successfully.

But when i use 'MQ Connector stage' instaed of 'MQ stage', and click View Data, its giving error message "An exception occured because the query returned 0 instances of Connector when a single unique instance is required."
"Error occured while invoking CAS..."

Can you tell me whats the error is about?
Suggest solutions if any..
I never let school to interfere in my education
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Try running the job and not using view data, does it work then? I think you need a local queue in order to get view data to work in the connector.
basav_ds
Participant
Posts: 24
Joined: Sun Nov 11, 2007 11:19 pm
Location: Mumbai

Post by basav_ds »

Hi,
i tried running the job, got error 'Unable to create QS run file directory, RT_QS773'. I have provided Mode=Server. Q mngr and Q name are provided. What should be the Username and Password field values?
I never let school to interfere in my education
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Are you using QS (QualityStage) in this job?
basav_ds
Participant
Posts: 24
Joined: Sun Nov 11, 2007 11:19 pm
Location: Mumbai

Post by basav_ds »

No.. I am not using QS in the job
I never let school to interfere in my education
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Something is odd here, directories/hashed files with "QS" are used for the V8 quality stage, I don't see how MQ could utilize them. Is the project directory path full?
basav_ds
Participant
Posts: 24
Joined: Sun Nov 11, 2007 11:19 pm
Location: Mumbai

Post by basav_ds »

Now that error is not coming while running. Unable to found what was the cause. But still View Data doesn't work.
Thnx.
I never let school to interfere in my education
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

View data will not work unless the queue is local to the server. Always try to run the job with the MQ Connector
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post by lstsaur »

No, I can view the data even the queue is remote using MQ Connector. It all depends on how the MQ configured.
Post Reply