This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Track-It! 2019 R3
Track-It! 2018 - Track-It! 2019
The migration tool fails in any of the modules with any of the following errors:
java.lang.OutOfMemoryError: Java heap space
Couldn't close query: resultset or prepared statements
The process is running out of memory.
It is necessary to increase java heap size.
- Close the migration tool
- Go to C:\Program Files\BMC\Track-It! 2019 Migration Tool\pdi-ce-6\data-integration
- Edit the Spoon.bat file
- Search for 'PENTAHO_DI_JAVA_OPTIONS='
- Change "-Xmx2048m" option to "-Xmx4096m"
- Save the file
- Re run the Migration tool from C:\Program Files\BMC\Track-It! 2019 Migration Tool, right click on 'DatabaseMigration.exe' and select 'Run as administrator'
Note: The value can be increased based on the memory available on the server, without exceeding 10 GB