EPM System Configurator - ORA-01882 ORA-00604 Timezone Region Not Found:

 

Error

ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region  not found

Solution:

Cancel the configurator, and change the files as shown below, and restart the configurator again

 Change

epmsys_registry.bat in common\config\11.1.2.0\resources\instance

From

if "%1" == "" (

    echo Generating Report

    "%JAVA_HOME%\bin\java" -cp "%CLASSPATH%" -DHYPERION_HOME=%EPM_ORACLE_HOME% -DEPM_ORACLE_HOME=%EPM_ORACLE_HOME% -DEPM_ORACLE_INSTANCE=%EPM_ORACLE_INSTANCE%  com.hyperion.hit.registry.ui.Console %EPM_ORACLE_HOME%\common\config\11.1.2.0\resources\registry\registry.vm %EPM_ORACLE_INSTANCE%\diagnostics\reports\registry.html %1

) else (

    "%JAVA_HOME%\bin\java" -cp "%CLASSPATH%" -DHYPERION_HOME=%EPM_ORACLE_HOME% -DEPM_ORACLE_HOME=%EPM_ORACLE_HOME% -DEPM_ORACLE_INSTANCE=%EPM_ORACLE_INSTANCE% com.hyperion.hit.registry.regedit.RegEditUtility "%1" "%2" "%3" "%4"

)

To

if "%1" == "" (

    echo Generating Report

    "%JAVA_HOME%\bin\java" -cp "%CLASSPATH%" -Duser.timezone=GMT -DHYPERION_HOME=%EPM_ORACLE_HOME% -DEPM_ORACLE_HOME=%EPM_ORACLE_HOME% -DEPM_ORACLE_INSTANCE=%EPM_ORACLE_INSTANCE%  com.hyperion.hit.registry.ui.Console %EPM_ORACLE_HOME%\common\config\11.1.2.0\resources\registry\registry.vm %EPM_ORACLE_INSTANCE%\diagnostics\reports\registry.html %1

) else (

    "%JAVA_HOME%\bin\java" -cp "%CLASSPATH%" -Duser.timezone=GMT -DHYPERION_HOME=%EPM_ORACLE_HOME% -DEPM_ORACLE_HOME=%EPM_ORACLE_HOME% -DEPM_ORACLE_INSTANCE=%EPM_ORACLE_INSTANCE% com.hyperion.hit.registry.regedit.RegEditUtility "%1" "%2" "%3" "%4"

)

AND:

Change

common\config\11.1.2.0\startconfigtool.bat

From

"%JAVA_HOME%\bin\java" %JAVA_AGENT_OPTION% -Xms256m -Xmx512m -XX:PermSize=64m -XX:MaxPermSize=256m -Djava.library.path=%JAVA_LIB_PATH% -DHYPERION_HOME=%EPM_ORACLE_HOME% -DEPM_ORACLE_HOME=%EPM_ORACLE_HOME% %ODL_ARGS% -cp %CLASSPATH% -jar %CONFIGTOOL_HOME%\configtool.jar %*

if not "%1" == "-silent" (

    exit

)

To

"%JAVA_HOME%\bin\java" %JAVA_AGENT_OPTION% -Xms256m -Xmx512m -XX:PermSize=64m -XX:MaxPermSize=256m -Duser.timezone=GMT -Djava.library.path=%JAVA_LIB_PATH% -DHYPERION_HOME=%EPM_ORACLE_HOME% -DEPM_ORACLE_HOME=%EPM_ORACLE_HOME% %ODL_ARGS% -cp %CLASSPATH% -jar %CONFIGTOOL_HOME%\configtool.jar %*

if not "%1" == "-silent" (

    exit

)

AND:

====

DO NOT update "set ODL_ARGS" with this as well in startconfigtool.bat

######################

When the configuration completes, the "-Duser.timezone=GMT" will be populated in all of the below files under "user_projects"

After the configuration completes, also do the below change to the validate.bat file

From:

set ODL_ARGS=-Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=validationTool-logging.xml

To

set ODL_ARGS=-Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=validationTool-logging.xml -Duser.timezone=GMT