Setup BPEL with PT 8.X

Consuming Web Service

Thank you Rapheal for sharing the document. All this is an informative one.

Where is it?

This might be a duplicate information for many, but I believe some one is going to get benefitted from this once again.

The PeopleCode is stored in PSPCMPROG, which has all the PC objects details. If you want to quickly check the existance of your application engine program codes, the issue the SQL against this table.

SELECT * FROM PSPCMPROG WHERE OBJECTVALUE7 LIKE 'OnExecute%'

PSSQLTEXTDEFN: Contains all SQL objects in the database.
SELECT * FROM PSSQLTEXTDEFN WHERE SQLID like '%Step%'

Administering the application messages

Once the messages are in the DONE status, it is not possible to resent the messages. What If we need to re submit it?

One option we found is to trigger a SQL update against the table which stores the monitoring data - PSAPMSGPUBHDR

Update PSAPMSGPUBHDR set PUBSTATUS = 1, STATUSSTRING = 'NEW' where IBTRANSACTIONID = ’Transaction ID’ and STATUSSTRING = ‘DONE’

PUBSTATUS values:
0 - Error
1 - New
2 - Started
3 - Working
4 - Done
5 - Retry
6 - Timeout
7 - Edited
8 - Canceled

To monitor the messages, query the appropriate tables with the above status values.