PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Getting Deadlock on PSAPMSGPUBSYNC table Tools 8.53.15 HCM 9.20.1

edited Mar 27, 2015 10:51AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered

Hi

We are getting deadlocks on PSAPMSGPUBSYNC table.  We run HCM 9.20.1 and we also are running ELM 9.0 (I think), same Tools version 8.53.

We are in the process of running our yearly budgeted group salary process that loads new salary rows to the JOB table several times a day. Unfortunately,  several times a day, the process will bomb out on a deadlock on PSAPMSGPUBSYNC.  We are looking to process 55K employees this week.

We are thinking of this approach, namely, suspend messaging to our ELM process every time we run we run our budgeted group salary process.

I was also researching deadlocks in MOS and came upon article 656090.1 Deadlocking in PSIBQUEUEINST -- which mentioned deadlocks on PSAPMSGPUBSYNC as well.  The article specifically mentioned that "deferred publishing" could be used (e.g. publish a message after all commits)  vs "immediate".  It also mentioned that future releases would contain publish methods performed in "deferred publishing" ... however if I look at the code in our demo database, the code that is delivered is &MSG.Publish() - which I don't think is deferred publishing.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center