E-AE/PRCS: PSDAEMON Process Stop Running With Error "ORA-00001: unique constraint (SYSADM.PS_MESSAGE_LOGPARM) violated" (Doc ID 1072653.1)

Last updated on MARCH 31, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 to 8.50 [Release 8.4]
Information in this document applies to any platform.
***Checked for relevance on 16-May-2014***

Symptoms

In PT 8.45.09 the PSAEDAMON program stopped running after awhile with the error below as seen in the psdaemon log:

-- 01.01.18 Process 99999001 ABENDED at Step AEDAEMONMGR.MAIN.RunProc (Action Do Select) -- RC = 805
ROLLBACK
/
-- 01.01.18 SQL Error: ORA-00001: unique constraint (SYSADM.PS_MESSAGE_LOGPARM) violated

 Or the error may look like:

Process 99999000 resumed after step AEDAEMONMGR.MAIN.StartUp (108,538)

Restart failed for program AEDAEMONMGR, instance 99999000 (reason code 4) (108,504)

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms