Migrate Utility Missing The -Dusebatchinserts=true JVM Parameter Preventing Bulk Inserting From Running During The Target Database Data Load (Doc ID 2069596.1)

Last updated on MAY 05, 2017

Applies to:

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

Symptoms

 In release 15.2.0.0, the migration utility was improved to support bulk insert operations in the data load process to enhance performance (Reference "Bug 13036577 - migrate.bat utility has poor performance when migrating large databases")

As part of resolution to the bug, a JVM option was suppose to be included in the migrate.bat|.sh file -- -Dusebatchinserts=true -- to utilize the batch insert process, however this setting is missing from the files.  As a result, the migration data load process is not utilizing the bulk inserting which will exhibit continued performance degradation when run against larger databases. 

For example:


STEPS TO REPRODUCE:
--------------------------

  1. Browse to the P6_152_Media\p6suite\database
  2. Open the migrate.bat|.sh in a text editor
  3. On the "SET JVM_PROPERTIES" line, notice the -Dusebatchinserts=true is missing.

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