NullPointerException when Testing Amazon Redshift Data Server Connectivity with an ODI 12.2.1 J2EE Agent
(Doc ID 2402379.1)
Last updated on JUNE 16, 2022
Applies to:
Oracle Data Integrator - Version 12.2.1.2.6 and laterInformation in this document applies to any platform.
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: <TID>] [userId: <USERID>] [ecid: <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://<AMAZON_AWS TEST URL>:<PORT>/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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |