Welcome to CompShack!
CompShack is a user driven Dev2Dev IT community. Developers can ask questions, help answer questions, or just browse code and articles contributed by users. No registration required.
You can register if you want to contribute code samples, share your knowledge at your own blog, and become adored in the community!

Contribute!

Do you find yourself with few minutes to spare, and a desire to help other CompShackers?

Submit a tip, code or an SQL snippet. Start an article about topics you are familier with, or edit a Wiki page. Help the community grow larger by sharing a little bit of what you know!

Reasons why this is great:

  • You help your fellow CompShackers
  • Give back to the community and help it grow
  • Easy access to your code any time you need it
  • Become known and adored in the community!

Note: Registration required. Guests can edit Wiki pages.

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!

Integration Broker

PeopleSoft Integration Broker related articles, setups, tips and tricks.

How to resubmit on Integration Broker message with DONE status

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=;

Message cannot be changed. Message referenced in runtime tables (Doc ID 660969.1)

Applies to

PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
SPECIFIC TO:Enterprise, Peopletools, PT8.48+

This document was previously published as Customer Connection Solution 201065338

***Checked for relevance on 27-APR-2010***
***Checked for relevance on 12-JAN-2012***
***Checked for relevance on 09-JUL-2014***

Symptoms