Getting Deadlock on PSAPMSGPUBSYNC table Tools 8.53.15 HCM 9.20.1
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.