E-PORTAL: Applying IH91U005 To Interaction HUB 91 Errors Occurred "unique constraint (SYSADM.PS_PSPTSVREVENTDEF) violated "

(Doc ID 2405896.1)

Last updated on JUNE 26, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

On : 8.55 version,  Interaction HUB 9.1.5

When attempting to complete an import using a delivered DMS script via Change Assistant,
the following error occurs.

ERROR
-----------------------
"SQL Error. Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSPTSVREVENTDEF) violated "


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade Interaction HUB to latest Image 5 
2. Error: SQL Error. Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSPTSVREVENTDEF) violated


Changes

 

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