Tables which are in the left panel of Create Metadata page are not visible. What could be the problem?Am using Helical Insight 3.0 version

General
, ,
#1

Hello Team,

I am using Helical Insight 3.0 version.
I have connected to my database, however at the metadata level I am not able to see all the tables, it is taking really long time to load.

Once the list of tables and columns gets populated then only I can select only relevant tables for metadata creation. Please help.

Thank you.

#2

Good Evening Anu,

This problem occurs due to limited memory allocation.
By default, when Helical Insight is installed, the memory allocated is default.

In order to improve performance and overcome this issue, we need to increase the amount of memory allocated by default for Java application running on Apache Tomcat.

If you are using Linux, download File setenv.zip (182 Bytes)
Once you have downloaded, copy the {setenv .sh} file and place it at the following location:

…\hi\apache-tomcat-7\bin

Within this file, you will find 3 parameters Max, Min and Max Permanent Size. These can be set as required.

If you are using Windows, follow the instructions below:

  1. Inside the apache-tomcat-7 bin folder rename the tomcat7w.exe to HelicalInsight.exe

image

  1. After renaming double click on the same file. Provide administrative password (if any) and the below Dialog box appears.

image

Add the following lines for minimum 2 GB and Maximum 6 GB.
Perm size max and minimum may also be set

-Xmx2048M
-Xmx6144M
-XX:PermSize=1024m
-XX:MaxPermSize=2048m

Thank You
From Team Helical.