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
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 ChrisPeopleSoft 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.