My Oracle Support Banner

Applying A Change Package from Campus Solutions 9.2 PUM 17 Fails on Step Application Engine With Error 'ORA-00001: unique constraint' PS_EOQF_COUNTER (Doc ID 2688898.1)

Last updated on JULY 14, 2020

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Applying a change package containing fixes from Campus Solutions 9.2 PUM 15 to 17 inclusive, the application engine step AE, AE28857769 fails with the following error.  Change Assistant is used to apply the change package.


Failed SQL stmt: INSERT INTO PS_EOQF_COUNTER (EOQF_QSTNRINSTANCE) SELECT 0 FROM PS_INSTALLATION WHERE NOT EXISTS ( SELECT * FROM PS_EOQF_COUNTER)
 Message Set Number: 200
 Message Number: 0
 Message Reason:  Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (DOMAIN.PS_EOQF_COUNTER) violated
Failed SQL stmt: INSERT INTO PS_EOQF_COUNTER (EOQF_QSTNRINSTANCE) SELECT 0 FROM PS_INSTALLATION WHERE NOT EXISTS ( SELECT * FROM PS_EOQF_COUNTER) (200,0)


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.