ODI interface from planning to essbase
I keep getting the error "java.lang.OutOfMemoryError: Java heap space" in the interface that loads data from planning to essbase.
I have checked the odiparams.bat file and the parameters are set as the following
set ODI_INIT_HEAP=512m
set ODI_MAX_HEAP=1536m
When I increased it further ODI_INIT_HEAP=1024m and ODI_MAX_HEAP=2048m as below the system started hanging while executing the same interface and it gave me the error again as below.
java.lang.OutOfMemoryError: Java heap space
at java.lang.ClassLoader.checkPackageAccess(ClassLoader.java:328)
at org.hsqldb.StatementDMQL.execute(Unknown Source)