Track-It! 2019 - Migration Error java.lang.OutOfMemoryError: Java heap space

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Track-It!


    COMPONENT:

    Track-It! 2019 R3


    APPLIES TO:

    Track-It! 2018 - Track-It! 2019



    PROBLEM:

    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


    CAUSE:

    The process is running out of memory.


    SOLUTION:

    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


    Article Number:

    000173713


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles