问题描述

Kettle探索资源库报错

java.lang.RuntimeException: java.lang.RuntimeException: org.pentaho.di.core.exception.KettleException:
Unable to get list of repository objects

An error occurred executing SQL:
SELECT NAME, MODIFIED_USER, MODIFIED_DATE, DESCRIPTION, ID_JOB FROM R_JOB WHERE ID_DIRECTORY = ?

Error determining value metadata from SQL resultset metadata
For input string: "4294967295"

解决方案

修改参数，将内存值调大（256的倍数），调整后如下所示：

REM ******************************************************************
REM ** Set java runtime options **
REM ** Change 512m to higher values in case you run out of memory **
REM ** or set the PENTAHO_DI_JAVA_OPTIONS environment variable **
REM ******************************************************************

if "%PENTAHO_DI_JAVA_OPTIONS%"=="" set PENTAHO_DI_JAVA_OPTIONS="-Xmx1024m" "-XX:MaxPermSize=2048m"

set OPT=%PENTAHO_DI_JAVA_OPTIONS% "-Djava.library.path=%LIBSPATH%" "-DKETTLE_HOME=%KETTLE_HOME%" "-DKETTLE_REPOSITORY=%KETTLE_REPOSITORY%" "-DKETTLE_USER=%KETTLE_USER%" "-DKETTLE_PASSWORD=%KETTLE_PASSWORD%" "-DKETTLE_PLUGIN_PACKAGES=%KETTLE_PLUGIN_PACKAGES%" "-DKETTLE_LOG_SIZE_LIMIT=%KETTLE_LOG_SIZE_LIMIT%" "-DKETTLE_JNDI_ROOT=%KETTLE_JNDI_ROOT%