Migrate (.bat or .sh) Does Not Migrate Data To Target Database (Oracle) And DatabaseMigrate.log Shows Failure On First Table "<TIMESTAMP> [INFO] Begin Table Load ACCOUNT <TIMESTAMP> [ERROR] null com.primavera.database.tools.DatabaseToolException" (Doc ID 1904931.1)

Last updated on APRIL 22, 2016

Applies to:

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

Symptoms

When running the migrate (.bat or .sh) utility, the process creates the new schema and table structure but fails to migrate any data to the new database.  No errors are seen on screen but the following in written to the DatabaseMigration.log when attempting to migrate data from the first table:

ERROR
--------------
<TIMESTAMP> [INFO] Begin Table Load ACCOUNT
<TIMESTAMP> [ERROR] null
<TIMESTAMP> [ERROR] null
<TIMESTAMP> [ERROR] null

com.primavera.database.tools.DatabaseToolException
  at com.primavera.database.tools.Dataloader.Dataloader.run(Dataloader.java:314)
  at com.primavera.database.tools.dbmt.workflow.DatapumpJob.doJob(DatapumpJob.java:74)
  at com.primavera.database.tools.dbmt.AbstractJob.execute(AbstractJob.java:64)
  at com.primavera.database.tools.dbmt.actions.BaseWizardRunner.runJob(BaseWizardRunner.java:195)
  at com.primavera.database.tools.dbmt.actions.BaseWizardRunner.commit(BaseWizardRunner.java:203)
  at com.primavera.database.tools.dbmt.actions.JobTreeTypeDef$JobRunner.run(JobTreeTypeDef.java:252)
  at java.lang.Thread.run(Thread.java:722)

Cause

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 hundreds of Community platforms