Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Issue in Spoon 3.1 -Memory heap and flushing the memory

  1. #1
    Join Date
    Nov 2008
    Posts
    3

    Default Issue in Spoon 3.1 -Memory heap and flushing the memory

    Hi Guys,

    I am facing issue in clearing the memory heap in spoon3.1 version.

    Here is my explanation towards the issue

    I am having a tranforamtion that fetches data from flat file and dumps it into the table.
    The flat file has nearly 30000 records in it.

    After inserting i am having T-sql statement for altering the view based on the structure of the table. This is where the exact issue starts.

    The transformation is running perfectly till it reaches 10000 record after that it is not running , IT IS JUST STAYING IDLE BUT SHOWING THE STATUS AS RUNNING. At times it is also showing a "Java memory out of heap".

    i have tired to increase the memory by changing the memory as 512m in spoon.bat file also in .ini file . but the issue is not fixed.

    also i increased the heap size as 512 by sayin Java -Xmx512m in cmd prompt. But nothing worked out .

    Some one please help me out to fix this issue e
    r

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

    Default

    Attach the transformation, we'll have a look.

  3. #3
    Join Date
    Nov 2008
    Posts
    3

    Default

    Hi Matt,

    I have attached the transformation in XML format. Please have a look and help me out to fix the issue.

    Thank you so much for your timely response.
    Attached Files Attached Files

  4. #4
    Join Date
    Nov 2008
    Posts
    3

    Default

    Hi Matt,

    can you please suggest me a solution? I am waiting for your suggestion.

    Thanks

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.