LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Java Heap Space error

    Employee
    Posted 06-24-2015 18:58

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: dglavastorm

    Hi - I'm using an Append Excel node and it keeps coming up with the following error :

    ERROR: Unexpected error occurred during processAll while running the node: Java heap space.
    Error Code: brain.unexpectedNodeErrorDuring

    The file it's appending is 11MB in size but it's only 2 tabs - a basic pivot and the raw data tab. The node is set to completely clear the raw data tab and write the new data in.
    There's no funky formulas or anything else apart from the basic pivot on the first tab.

    Is there a solution to this ? Not sure if it's Lavastorm or Java itself.

    PC is in I5 desktop with 4gb Ram and 64bit Windows 7 so shouldn't be a spec issue.

    Cheers,

    Dave


  • 2.  RE: Java Heap Space error

    Employee
    Posted 05-25-2017 09:15

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ejones

    Hi Dave,

    This Excel node and some of the other nodes are based on the Java node. These nodes are given a specific limit as to the amount of memory they can use. This is done for protection because if the node goes crazy allocating memory it can bring your computer to a standstill.

    I believe the default amount the node is given is 1 Gig. To change the limit create a parameter in the node named JvmMaxHeapSize and give it values like 2g or 4g to double or quadruple the maximum size the node is given.

    So to do this do the following:
    - Edit the node
    - At the top is a button named [Declare Parameters...] click that
    - In the new window click the button over to the right that creates a new line for defining a parameter.
    - Under Parameter Name enter the value JvmMaxHeapSize. You can leave the rest fields with the default values.
    - Click Ok
    - Now, if you left them with the default values you should have a new tab on the node named "Parameters 1", select it.
    - There should be a parameter named JvmMaxHeapSize in that node. Enter the new maximum memory allocations you want to try.
    - Rerun the node


  • 3.  RE: Java Heap Space error

    Employee
    Posted 10-31-2017 19:40

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: dglavastorm

    I never actually got this working for Excel, but this just solved the same issue with the Tableau TDE output node. Thanks :-)