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)
Do you need a quick way to create web services?
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.