My Oracle Support Banner

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 MARCH 22, 2022

Applies to:

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


 In release, 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:


  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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.