My Oracle Support Banner

Regression: Error In Task 5-10-3 Performing Data Conversion Concurrently For CRM 9.1 To CRM 9.2 Upgrade (Doc ID 1952060.1)

Last updated on JULY 22, 2020

Applies to:

PeopleSoft Enterprise CRM HelpDesk for HR - Version 9.2 and later
Information in this document applies to any platform.
Error in Task 5-10-3 Performing Data Conversion Concurrently for CRM 9.1 to CRM 9.2 upgrade:
Table PS_RA_UD_MKTCENTER already has a row with key ROOT and the Conversion Program tries to insert a row with same key ROOT, which causes the following error:

PSAESRV.11534516 (1) [2014-12-05T10:02:53.601](3) File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 805 - ORA-00001: unique con
straint (SYSADM.PS_RA_UD_MKTCENTER) violated
Failed SQL stmt: INSERT INTO PS_RA_UD_MKTCENTER(RA_MKT_CENTER , DESCR50 ,STATUS ,CS_INSTITUTION ,RA_HE_CENTER_TYPE ,RA_HE_CENTER_ID ,DESCR ,RA_HE_EIP_CREATE ,ROW_ADDED_DTTM ,
ROW_ADDED_OPRID ,ROW_LASTMANT_DTTM ,ROW_LASTMANT_OPRID ,SYNCID ,SYNCDTTM ,RA_MC_LEVEL_NUM ,RA_PARENT_MKTCTR ,SQLTEXT) VALUES('ROOT' ,'ROOT Marketing Center' ,'A' ,' ' ,' ' ,'
RCTR' ,' ' ,'Y' , CAST(SYSTIMESTAMP AS TIMESTAMP) , 'PPLSOFT' , CAST(SYSTIMESTAMP AS TIMESTAMP) , 'PPLSOFT' , 2 , CAST(SYSTIMESTAMP AS TIMESTAMP) , 1 , ' ' , NULL)
PSAESRV.11534516 (1) [2014-12-05T10:02:53.768](3) RunAeAsync service request completed unsuccessfully -- Application ID=PTIADATACONV Process Instance=1276327
PSAESRV.10354926 (1) [2014-12-05T10:02:56.771](3) RunAeAsync service request completed successfully -- Application ID=PTIADATACONV Process Instance=1276329
PSAESRV.36962488 (1) [2014-12-05T10:02:56.778](3) RunAeAsync service request completed successfully -- Application ID=PTIADATACONV Process Instance=1276328
PSAESRV.11534516 (1) [2014-12-05T10:03:05.093](0) RunAeProgAsync status -- Application ID=PTIADATACONV Status=Error Process Instance=1276327 Current Step=None
PSAESRV.10354926 (1) [2014-12-05T10:03:05.105](0) RunAeProgAsync status -- Application ID=PTIADATACONV Status=Success Process Instance=1276329 Current Step=None
PSAESRV.36962488 (1) [2014-12-05T10:03:05.130](0) RunAeProgAsync status -- Application ID=PTIADATACONV Status=Success Process Instance=1276328 Current Step=None

Goal

 To complete CRM 9.1 to 9.2 upgrade without an error in Task 5-10-3

Solution

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
Goal
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.