Hitachi Vantara Pentaho Community Forums
Results 1 to 12 of 12

Thread: : java.lang.OutOfMemoryError: Java heap space

  1. #1

    Default : java.lang.OutOfMemoryError: Java heap space

    Hi,

    I'm working on scd2.My source table contain more than 500 thousand records.When I run the transformation I get the following error.

    : java.lang.OutOfMemoryError: Java heap space


    I gave the commit size to 25,000 and increase the buffer size in transformation settings.But still getting the error.

    Cache size I gave was 5000.

    Please give me a solution for this problem ASAP.

    Thanking you.

    preetha

  2. #2
    Join Date
    Mar 2006
    Posts
    114

    Question

    Quote Originally Posted by preetha View Post
    Hi,

    : java.lang.OutOfMemoryError: Java heap space

    How is the parameter set-Xmx ds JVM for the Spoon or what you're using?

    regards

    Conca
    Last edited by leandroconcon; 12-03-2008 at 11:29 AM.

  3. #3

    Default

    Hi,

    I'm using Spoon for the transformation.

    Thanking you.

    preetha

  4. #4
    pstoellberger Guest

    Default

    The default Xmx value for spoon is 256m....

  5. #5

    Default

    Hi,

    Sorry!From where we get the value.

  6. #6
    pstoellberger Guest

    Default

    there is this line at the bottom of spoon.bat / spoon.sh where its set:
    set OPT=-Xmx256m -cp ...................

  7. #7
    Join Date
    Mar 2006
    Posts
    114

    Wink

    Quote Originally Posted by preetha View Post
    Hi,

    Sorry!From where we get the value.


    For Spoon.exe you can change the parameter in the repository below
    KETTLE_HOME\Kettle.l4j.ini

  8. #8

    Default

    Hi,

    Thank you.I found the value in spoon.sh.
    How can I change the value?
    Spoon is working on Windows platform.

    preetha

  9. #9
    Join Date
    Mar 2006
    Posts
    114

    Default

    Quote Originally Posted by preetha View Post
    Hi,

    Thank you.I found the value in spoon.sh.
    How can I change the value?
    Spoon is working on Windows platform.

    preetha
    Alter only KETTLE_HOME\Kettle.l4j.ini

  10. #10

    Default

    Hi,

    Thankyou somuch...

    Any upper limit for this value?

    preetha

  11. #11
    Join Date
    Mar 2006
    Posts
    114

    Post

    Quote Originally Posted by preetha View Post
    Hi,

    Thankyou somuch...

    Any upper limit for this value?

    preetha

    Well, i think 1600MB.

  12. #12

    Default

    Hi,

    It's working good.Thank You for your quick response.


    preetha

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.