E-IB: PSVERSION Locking When Using MULTI-QUEUE Option For Service Operations In Integration Broker

(Doc ID 2000227.1)

Last updated on JULY 07, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.

Goal

The purpose of the this document is to explain the relationship between the use of the Integration Broker Multi-Queue feature and continuing locks places on the PSVERSION table. It was observed that for each time a queue was switched that was part of multi-queue feature that the PSVERSION table was updated and locked more often.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms