NullPointerException when Testing Amazon Redshift Data Server Connectivity with an ODI 12.2.1 J2EE Agent

Last updated on MAY 31, 2018

Applies to:

Symptoms

When testing Redshift Data server connectivity using a third party Amazon JDBC driver in Oracle Data Integrator 12.2.1, it is successful with the Local/No Agent or a Collocated Agent, but it gives the below error with a J2EE Agent:

[2018-03-07T05:44:27.446-05:00] [ODI_Server2] [ERROR] [ODI-1592] [oracle.odi.agent] [tid: 121] [userId: ] [ecid: ] [APP: oraclediagentname] [partition-name: DOMAIN] [tenant-name: GLOBAL] [oracle.odi.runtime.MrepExtId: ] [oracle.odi.runtime.AgentName: OracleDIAgentName] [oracle.odi.runtime.ExecPhase: ProcessRequest] [oracle.odi.runtime.Command: OdiTestDataServer] [oracle.odi.runtime.OdiUser: User.Name] [oracle.odi.runtime.EntityGuid: ] Error occurred testing connection to dataserver with agent OracleDIAgent[[
ODI-1592: Error occurred testing connection to dataserver with agent OracleDIAgent
Caused By: oracle.odi.core.exception.OdiRuntimeException: java.lang.NullPointerException
   at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor$1.doAction(TestDataServerProcessor.java:276)
   at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:173)
   at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor.doProcessRequest(TestDataServerProcessor.java:121)
   at oracle.odi.runtime.agent.processor.SimpleAgentRequestProcessor.process(SimpleAgentRequestProcessor.java:49)
   at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)
   at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:830)
   at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:748)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
   at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)
   at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
   at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
   at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)
   at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
   at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
   at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:141)
   at java.security.AccessController.doPrivileged(Native Method)
   ...
Caused by: java.lang.NullPointerException
   at java.io.File.(File.java:277)
   at com.amazon.redshift.common.PGClassLoaderSingleton.validateTempDir(Unknown Source)
   at com.amazon.redshift.jdbc.Driver.getInstance(Unknown Source)
   at com.amazon.redshift.jdbc.Driver.acceptsURL(Unknown Source)
   at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:407)
   at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:385)
   at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:352)
   at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:331)
   at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:228)
   ...

The following configurations have been performed:

• ODI Topology - Data Server definition:

            JDBC Driver: com.amazon.redshift.jdbc42.Driver
            JDBC URL: jdbc:redshift://[AmazonAWS test URL]:5439/testdb?ssl=true&sslmode=verify-full

• The driver jar file was added in the below locations and WebLogic was restarted - based on <Document 2023446.1> and the Oracle documentation.

            %APPDATA%\Roaming\odi\oracledi\userlib\RedshiftJDBC42-1.2.10.1009.jar
            [DOMAIN_HOME]\lib\RedshiftJDBC42-1.2.10.1009.jar

Changes

Cause