SQLite Standalone Database Migration Tool fails to Migrate Data from Larger Oracle and SQL Server Databases

(Doc ID 2316220.1)

Last updated on NOVEMBER 06, 2017

Applies to:

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

Symptoms

When attempting to migrate a Standalone database to SQLite, the following error occurs:

ERROR
-----------------------
Migration failed. Please see log file for more information.
Log File: C:\Users\<username>\AppData\Local\Temp\P6MigrateTool.log

or

Standalone Database Migration Tool hangs while importing Activities data


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Launch the Standalone Database Migration Tool
2. Select the database alias to convert and enter the database system or sa password
3. Issue occurs


Changes

 

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