DBConnection Test From ICS Through Agent Fails With Error "ORA-01882: timezone region not found"

(Doc ID 2324903.1)

Last updated on NOVEMBER 06, 2017

Applies to:

Integration Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

While testing DB Connection in ICS which is connected through Agent, it fails with error

oracle.ics.webconsole.common.exception.GeneralException: ICS-10977: Unable to test the connection. Error code : oracle.ics.common.exception.NonICSRuntimeException: CLOUD-0005: Unable to establish connection. Please check connection parameters.


ERROR
-----------------------
Logs shows the below trace:
java.lang.Exception: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

at oracle.tip.tools.ide.adapters.db.common.plugin.connection.CloudDatabaseRemoteConnector.ping(CloudDatabaseRemoteConnector.java:131)
at oracle.tip.tools.ide.adapters.db.plugin.connection.CloudDatabaseConnection.ping(CloudDatabaseConnection.java:170)
at oracle.ics.webconsole.model.manager.AppConfigManager.testApplicationInstance(AppConfigManager.java:2068)
at oracle.ics.webconsole.view.beans.AppConfigCreateResourceBean.testAppInstance(AppConfigCreateResourceBean.java:1440)
at oracle.ics.webconsole.view.beans.AppConfigCreateBean.testAppInstance(AppConfigCreateBean.java:747)
at oracle.ics.webconsole.view.beans.AppConfigCreateBean$HeaderPageTemplateBackingBean.customButton1Action(AppConfigCreateBean.java:1514)
at sun.reflect.GeneratedMethodAccessor6476.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.sun.el.parser.AstValue.invoke(AstValue.java:254)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)
at org.apache.myfaces.trinidad.component.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:46)
at com.sun.faces.application.ActionListenerImpl.processAction(Unknown Source)
at org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:190)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a DB Connection through Agent and Test the connection

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms