My Oracle Support Banner

Running the migrateFrameworkApplicationToWebCenter Script to Migrate a Portal Framework Application to WebCenter Portal Fails With: Error occurred during database update, service name: People Connections (Doc ID 2789321.1)

Last updated on JULY 08, 2021

Applies to:

Oracle WebCenter Portal - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

Running the migrateFrameworkApplicationToWebCenter Script to Migrate a Portal Framework Application to WebCenter Portal Fails With the following error: 

 

FwkAppMigrationDiagnostic.log:

-------------------------------------------------------
PeopleConnServiceMigrationHandler
-------------------------------------------------------

Reading data from table: WC_PEOPLE_CONN_CONNECTION
Inserting data into table: WC_PEOPLE_CONN_CONNECTION
Reading data from table: WC_PEOPLE_CONN_INVITATION
Inserting data into table: WC_PEOPLE_CONN_INVITATION
Reading data from table: WC_PEOPLE_CONN_LIST
Inserting data into table: WC_PEOPLE_CONN_LIST
Reading data from table: WC_PEOPLE_CONN_LIST_MEMBER
Inserting data into table: WC_PEOPLE_CONN_LIST_MEMBER
Reading data from table: WC_PEOPLE_MESSAGE
Inserting data into table: WC_PEOPLE_MESSAGE
Reading data from table: WC_PEOPLE_CONN_PROFILE_PHOTO
Inserting data into table: WC_PEOPLE_CONN_PROFILE_PHOTO
Error occurred during database update, service name: People Connections.

 WC_Spaces1.out:

<DATE=TIME> <Error> <oracle.webcenter.migration.handler.PeopleConnServiceMigrationHandler> <BEA-000000> <Error occurred during database update, service name: People Connections.
java.sql.BatchUpdateException: ORA-00001: unique constraint (CUSTPTL_WEBCENTER.SYS_C0022297) violated

     at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13349)
     at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:248)
     at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:210)
     at oracle.webcenter.migration.handler.PeopleConnServiceMigrationHandler.migrateTableData(PeopleConnServiceMigrationHandler.java:262)
     at oracle.webcenter.migration.handler.PeopleConnServiceMigrationHandler.migrate(PeopleConnServiceMigrationHandler.java:105)
     at oracle.webcenter.migration.framework.MigrationManager.handleMigrate(MigrationManager.java:192)

 

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.