Hello All,
I have the requirement to read xml messages from Queue and apply transformations like mandatory checks, rejection and load data to database.
I have selected the Delete (Under Transaction) option in MQ read stage. The messages are deleted from queue if job aborted in intermediate stages like transform stage.
Please suggest is there any option to keep messages in queue till my job completes successfully. The messages has to get delete once job compeltes successfully.
Thanks
Padma
Messages are deleting from Queue if job aborts
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 8
- Joined: Tue Sep 01, 2009 6:16 am
-
- Participant
- Posts: 8
- Joined: Tue Sep 01, 2009 6:16 am
If your target database is compatible with a DTS stage (and ofcourse if you have it and if your release support it) you could use that - and messages are handled within the job the way you want it without any additional logic.
But in the end i guess it comes down to what the business want you to do in such a scenario.. I think unless you introduce a mechanism to capture rows and retry when needed, you cannot use any of the other options..
Yes flush queues - another job with delete mode, or perhaps a script thats called in ur after job routine.
But in the end i guess it comes down to what the business want you to do in such a scenario.. I think unless you introduce a mechanism to capture rows and retry when needed, you cannot use any of the other options..
Yes flush queues - another job with delete mode, or perhaps a script thats called in ur after job routine.
-
- Participant
- Posts: 91
- Joined: Wed Apr 20, 2005 7:59 pm
- Location: U.S.
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
Extract from queue and stored the xml into a single field in a dataset.Perform this into an single job. You can read the message in delete mode.
Then in next job you can use the dataset for xml parsing and transformation. If any abortion occur in this job then xml will be as it is in the dataset.
Then in next job you can use the dataset for xml parsing and transformation. If any abortion occur in this job then xml will be as it is in the dataset.
Soumya