My Oracle Support Banner

Campus Solutions Upgrade Fail on Step 6-6-1 - Importing Application System Data (Doc ID 2410926.1)

Last updated on JUNE 13, 2018

Applies to:

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

Symptoms

During the initial upgrade pass of the Campus Solutions 9.0 to Campus Solutions 9.2 upgrade, using certified upgrade image 9.2.002 (equivalent to Campus Solutions 9.2 PUM 8) and Campus Solutions 9.2 PUM image 8 for the RFU (Required for Upgrade) fixes, an error occurs running dlupsysi.dms script.


ERROR
-----------------------
Importing HCR_SM_RFLD_TBL
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_HCR_SM_RFLD_TBL) violated
Failed SQL stmt: INSERT INTO PS_HCR_SM_RFLD_TBL (SM_TYPE, SM_RSLT_FLD, SM_RECORD, SM_FIELD, SM_SYSDATA, SM_EFFDT_FLG, DESCR) VALUES (:1, :2, :3, :4, :5, :6, :7) (200,0)
SQL Error. Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_HCR_SM_RFLD_TBL) violated

INSERT INTO PS_HCR_SM_RFLD_TBL (SM_TYPE, SM_RSLT_FLD, SM_RECORD, SM_FIELD, SM_SYSDATA, SM_EFFDT_FLG, DESCR) VALUES (:1, :2, :3, :4, :5, :6, :7)
SQL Error. Error Position: 0 Return: 0 -
Error: SQL unable to commit transaction for HCR_SM_RFLD_TBL
Ended: Wed Mar 28 14:03:53 2018
Unsuccessful completion


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Perform the Campus Solutions 9.0 to 9.2 upgrade.
PeopleSoft Enterprise Campus Solutions Community  Support Blog  Information_Centers  Maintenance_Advisor 

 

 

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!


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