My Oracle Support Banner

Error When Migrating a SQL Server EPPM Database to PPM: DatabaseToolException: The ALTER TABLE statement conflicted with the FOREIGNKEY constraint "fk_joblog_jobsvc" (Doc ID 2988575.1)

Last updated on DECEMBER 16, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 21.12.10.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to migrate a EPPM database to PPM, the following error occurs:

ERROR:

Error in Run SQL Script : DatabaseToolException (The ALTER TABLE statement conflicted with the FOREIGNKEY constraint "fk_joblog_jobsvc". The confict occurred in database "<dbname>" table 'dbo.JOBSVC', column'job_id')

DatabaseMigration.log error:

<date> <time stamp>[INFO] [USER] Begin Table Load JOBSVC
<date> <time stamp>[INFO] [USER] Data Load error with exception Operand type clash: varbinary is incompatible with text
java.sql.BatchUpdateException: Operand type clash: varbinary is incompatible with text
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1870)
at com.primavera.database.common.container.SQLRowInserter.executeBatch(SQLRowInserter.java:446)
at com.primavera.database.tools.Dataloader.DataLoaderDBHandler.processLeftOutRows(Dataloader.java:984)
at com.primavera.database.tools.Dataloader.DBRowGenerator.run(DBRowGenerator.java:125)
at com.primavera.database.tools.Dataloader.Dataloader.run(Dataloader.java:315)
at com.primavera.database.tools.dbmt.workflow.DatapumpJob.doJob(DatapumpJob.java:71)
at com.primavera.database.tools.dbmt.AbstractJob.execute(AbstractJob.java:67)
at com.primavera.database.tools.dbmt.actions.BaseWizardRunner.runJob(BaseWizardRunner.java:205)
at com.primavera.database.tools.dbmt.actions.BaseWizardRunner.commit(BaseWizardRunner.java:214)
at com.primavera.database.tools.dbmt.actions.JobTreeTypeDef$JobRunner.run(JobTreeTypeDef.java:253)
at java.lang.Thread.run(Thread.java:750)

STEPS
The issue can be reproduced at will with the following steps:

  1. Launch migrate.bat.
  2. Select Schema migration.
  3. Select SQL Server.
  4. Enter Source EPPM database connection settings.
  5. Enter Target PPM SQL Server database connection settings.
  6. Click Next to start Migrate.
  7. Migrate fails during "Create remaining database objects".
  8. Inspect the DatabaseMigration.log for error.

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.