Unique Constraint Error on PS_MESSAGE_LOG

By Chris Malek | Thu, Feb 3, 2011

If you are getting a unique constraint error on PS_MESSAGE_LOG in the process monitor like this:

ORA-00001: unique constraint (SYSADM.PS_MESSAGE_LOG) violated

The cause is generally a locked user account that has a scheduled job. Clear all their errors and recurrences or unlock the account. You will see this error on un-related jobs for other users and not the locked user so it is confusing.

For additional information see the Oracle Support article 640200.1

Article Categories
Author Info
Chris Malek

Chris Malek is a PeopleTools® Technical Consultant with two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.

About Chris Work with Chris
Looking for pain-free PeopleSoft web services? 😀
PeopleSoft Simple Web Services (SWS)

Introducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.

Integration Broker - The Missing Manual

I am in the process of writing a book called "Integration Broker - The Missing Manual" that you can read online.