Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
tnewbie
Creator II
Creator II

How to exit Que - tJMSINPUT

Hello All,

 

Question :1

I am using tJMSINPUT to connect to IBM Websphere MQ and am able to read the messages (xml formats). After reading the messages, I want to parse and load them to corresponding tables. The stumbling block here is, after i read the messages the job is consistently connected to Que and is not released, thus placing an implicit lock on the table. so I observed that if i configure my tJMSINPUT component to read 'n' number of messages and quit then i don't have a problem or if i have a time window set (say 5mins) then also no problem because Talend/tJMSINPUT will release the lock and the data will be populated to table. But on the contrary if i want to continuously read messages from queue and populate them to underlying tables, it is not happening and the job is indefenetly looking for the messages to read from Queue.

 

Question:2

On the same lines, when i read the xml messages, same thing is happening at tXMLMap, not sure why tXMLMap is behaving like a group by function when i am just intending to carry through the record through it.

 

Please find attached image that shows my job design at a high level...Please advise if there is any other configuration that i am missing to make this happen.

Labels (3)
1 Reply
tnewbie
Creator II
Creator II
Author

Hello Gurus,

 

Can some one shed light on my below questions please 😞