How to resubmit on Integration Broker message with DONE status

Your rating: None Average: 4.8 (4 votes)

Go To subscription node in PeopleTools >> Integration Broker >> Monitor Integrations >> Sub Contracts and get teh the PUBID of the message in DONE status

For PT 8.47 and lower run the below SQL to verify that the message status is DONE
select * from PSAPMSGSUBCON where PUBID=;

Then run the update below:
update PSAPMSGSUBCON set STATUSSTRING='CNCLD', RETRYCOUNT=0, SUBCONSTATUS=8 where PUBID=;

For PT 8.48 and higher, run the below SQL to verify that the message status is DONE
select * from PSAPMSGSUBCON where QUEUESEQID=;

Then run the update below:
update PSAPMSGSUBCON set STATUSSTRING='CNCLD', RETRYCOUNT=0, SUBCONSTATUS=8 where QUEUESEQID=;

You can now go back to Sub Contracts and verify that the message status has been changed to CANCEL then open message details and resubmit.

4) Open message details and resubmit it

5) Go to Sub Contracts and press Refresh button until the message status is Done.

The message statuses are:
NEW = 1
DONE = 4
ERROR = 0
CNCLD = 8

If there is no subscription peoplecode/handler defined on a message/service operation then there is no entry in the PSAPMSGSUBCON table. Then, changes changes would have to be made to the PSAPMSGPUBHDR table to change from DONE to Cancel or NEW.

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.
Adam's picture
Adam (not verified)
Re: How to resubmit on Integration Broker message with DONE ...

Thanks for sharing. I didn't even know that was possible.

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
13 + 6 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.