Problem Description


Test connection job in Infoworks ADE fails with the below error.


ERROR] 2019-06-21 09:21:53,942 [main] infoworks.discovery.dbcrawler.rdbms.utils.DBConnection:85 :: Could not get database connection to jdbc:oracle:thin:@54.152.76.182:1521:xe. ORA-00604: error occurred at recursive SQL level 1

ORA-01882: timezone region not found


java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1

ORA-01882: timezone region not found


Root Cause


This is an issue from the Oracle JDBC driver end(ojdbc8.jar)


https://support.oracle.com/knowledge/Middleware/2291718_1.html


Solution


Infoworks ADE ships the Oracle jdbc driver along with the package and the jdbc jar will be placed in the below location.


$IW_HOME/lib/shared


Perform the below steps to resolve this issue.


a) Download ojdbc6.jar from Oracle website.

https://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html

b) Move the ojdbc8.jar from $IW_HOME/lib/shared to some other location on the edge node.

c) Login to the edge node as infoworks users and place the ojdbc6.jar in $IW_HOME/lib/shared location.

d) Run the test connection again.


This should resolve the issue.


Applies to Infoworks ADE versions


v2.3.x,2.4.x,2.5.x,2.6.x,2.7.x