My Oracle Support Banner

Standalone Database Migration Tool Will Not Migrate SQL Server to SQLite (Doc ID 2573178.1)

Last updated on JANUARY 22, 2020

Applies to:

Primavera P6 Professional Project Management - Version 18.8.8.0 to 18.8.11.0 [Release 18.8]
Information in this document applies to any platform.

Symptoms

DESCRIPTION OF PROBLEM:
Migration tool is broken. Using customer or sample PPM database that is 18.8.8.0 cannot migrate to SQLite.

Utility fails with "Migration failed. Please see log file for more information."

Log file contains the following:
Message: Migrating Table AdminPreference
Severity: Info

Message: Exception while committing the changes to the database.
One or more errors occurred.
Severity: Exception

Message: Unable to Migrate
Severity: Exception

STEPS TO REPRODUCE:

  1. Update the PPM database to 18.8.8.0
  2. Try to use the standalone database migration tool to transfer the SQL Server PPM database to SQLite
  3. See pop up error
  4. Check log, see above

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.