Hitachi Vantara Pentaho Community Forums
Results 1 to 9 of 9

Thread: Excel Input Error - Java heap space

  1. #1
    Join Date
    Jul 2010
    Posts
    23

    Default Excel Input Error - Java heap space

    I tried to put a Excel Input with .xlsx format. The file is big. But i get error:

    Unable to open dialog for this step
    java.lang.OutOfMemoryError: Java heap space
    at org.apache.xmlbeans.impl.store.Cur.createElementXobj(Cur.java:260)
    at org.apache.xmlbeans.impl.store.Cur$CurLoadContext.startElement(Cur.java:2997)
    at org.apache.xmlbeans.impl.store.Locale$SaxHandler.startElement(Locale.java:3207)
    at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.reportStartTag(Piccolo.java:1082)

    Can somebody help me ?
    Name:  Dibujo1.jpg
Views: 159
Size:  35.5 KB
    Last edited by marzo27; 10-26-2011 at 10:47 AM.

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

    Default

    I guess the file is too big. Try giving Spoon more memory to work with.

  3. #3
    Join Date
    Jul 2010
    Posts
    23

    Default

    Matt, i tried with more memory, but the error is the same. The .xlsx file have 17 MB.


    PENTAHO_DI_JAVA_OPTIONS="-Xmx1024m" "-XX:MaxPermSize=512m"

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

    Default

    It's something to do with the underlying Apache POI library. There's a JIRA case out there that we're working on to see if we can find a solution.

  5. #5
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hi there,

    give it more memory if you can. 17MB of compressed XML easily translate to a couple of hundred MB of data when expanded. Plus some footprint of internal API representation structures. My guess is that about 2G of RAM would allow for the file to be read entirely.

    Cheers
    Slawo

  6. #6
    Join Date
    Jul 2010
    Posts
    23

    Default

    I put 2 GB of RAM, but Kettle not begin.
    Example:
    PENTAHO_DI_JAVA_OPTIONS="-Xmx2048m" "-XX:MaxPermSize=256m"

  7. #7
    Join Date
    Jul 2010
    Posts
    23

    Default

    Somebody can help me ?

  8. #8
    Join Date
    Jul 2012
    Posts
    6

    Default

    Hi, I have the same problem myself - for me, this step cannot read in an .xlsx file which is only 15MB. However, small files are okay. Has a solution been found yet? Many thanks.

  9. #9
    Join Date
    Dec 2014
    Posts
    10

    Lightbulb

    Hi, I have the same problem .I am using MongoDB Input having 130000 rows but after fetching 98633 rows then java.lang.OutOfMemoryError: Java heap spac

    such error occurred, even I tried to extent the memory of spoon.bat file but spoon.bat file support only 1024 MB memory. If I extent memory up to 2048 MB then spoon.bat file not start.

    I am using community edition.and right now in my system 8GB RAM is available .Kindly provide the solution How I resolved the same.

    Regards,
    Rushikesh

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.