Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: OutOfMemory while exporting to excel

  1. #1
    Join Date
    Mar 2009
    Posts
    3

    Default OutOfMemory while exporting to excel

    Hi,

    Im trying to run a transformation in JAVA API way with a prebuilt transformation using kettle 3.1. But an OutOfMemory throws while processing about 100,000+ records. I tried limiting down the Nr of rows in rowset, but still no use.

    Code:
    public static void main(String[] args) throws KettleException {
    	StepLoader.init();
    	    EnvUtil.environmentInit();
    	    TransMeta transMeta = new TransMeta("E:\\trans\\excel-exporting.ktr");
    	    Trans trans = new Trans(transMeta);
    
    	    trans.execute(null); // You can pass arguments instead of null.
    	    trans.waitUntilFinished();
    	    if ( trans.getErrors() > 0 )
    	    {
    	      throw new RuntimeException( "There were errors during transformation execution." );
    	    }
    
        }
    thanks for your suggestions!

  2. #2
    Join Date
    Mar 2009
    Posts
    3

    Default

    could somebody give me some points?

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Your problem is not related to PDI.
    Google for Java and OutOfMemoryException.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.