PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

weird unique constraint on ps_message log sporadically

edited May 12, 2014 12:59PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered ✓

We have one sqr that runs every day, and most days there are no issues, but every now and then (maybe once a month, but not on any specific date or time), the job will fail and the process scheduler will show no success.  When I look in the out file, I see this:

PRCSAPI.SQC,Update-Process-Status,Update,PSPrcsRqst

SQL Status =     1, SQL Error  = ORA-00001: unique constraint (PSADM.PS_MESSAGE_LOG) violated

in the message log I also see this message:

You are not authorized to run process type PRCSYSPURGE and process name Application Engine. (65,8) P T_PRCS.Schedule.SubmitRequest.OnExecute  Name:SubmitPrcsRqst  PCPC:747  Statement:19

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center