Database Migration Produces Error "This Is An Unsupported Feature: Getbytes" (Doc ID 2743355.1)

Last updated on JANUARY 12, 2021

Applies to:

Symptoms

When attempting to migrate the P6EPPM database from Oracle to MS SQL Server, it shows completed, but, logs below error in DatabaseMigration.log:

ERROR

Error: table = RSRCROLEASGNMENTSPREAD: Conversion failed when Converting the nvarchar value 'RSRC' to data type int. is displayed.
[INFO] [USER] Data Load error with exception Conversion failed when converting the nvarchar value 'RSRC' to data type int.
com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the nvarchar value 'RSRC' to data type int.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
...
[ERROR] The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "fk_dashboard_users". The conflict occurred in database "XXXX", table "dbo.USERS", column 'user_id'.
[ERROR] Database Error: error number=XXX
[ERROR] Error Message: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "fk_dashboard_users". The conflict occurred in database "XXXX", table "dbo.USERS", column 'user_id'.
[WARN] [USER] Could not complete because the job "Run SQL Script sspm_ins_aux.sql" failed.
com.primavera.database.tools.DatabaseToolException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "fk_dashboard_users". The conflict occurred in database "XXXX", table "dbo.USERS", column 'user_id'.

STEPS

The issue can be reproduced at will with the following steps:
1. Run migrate.bat.
2. The db migration fails with above error.

Cause

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