Connection to Netezza times out (does not even reach the Netezza box). Increasing timeout time does not solve this. JDBC connection with Squirrel SQL works.
The Netezza JDBC connector 7.2 requires JDBC 4.0 and Java 1.7 or higher.
Database type is set to based on URL.
Can someone see why it is failing?
Here full log (or as much as I could find).
2018-12-20 10:05:28,729 : DEBUG : KNIME-Worker-4 : NodeContainer : Database Connector : 0:1 : Database Connector 0:1 has new state: EXECUTING
2018-12-20 10:05:28,729 : DEBUG : KNIME-Worker-4 : WorkflowDataRepository : Database Connector : 0:1 : Adding handler 96f5d111-e1e2-4573-8262-ac434d0679bd (Database Connector 0:1: ) - 1 in total
2018-12-20 10:05:28,729 : DEBUG : KNIME-Worker-4 : LocalNodeExecutionJob : Database Connector : 0:1 : Database Connector 0:1 Start execute
2018-12-20 10:05:28,729 : DEBUG : KNIME-Worker-4 : NodeContext : Database Connector : 0:1 : Workflow user found: HISSA
2018-12-20 10:05:28,729 : DEBUG : KNIME-Worker-4 : RegisteredDriversConnectionFactory : Database Connector : 0:1 : Try to lock key to obtain connection: ConnectionKey [db-user=HISSA, db-name=jdbc:netezza://netezza.ag.fi:5480/MYDATA, wf-user=HISSA]
2018-12-20 10:05:28,729 : DEBUG : KNIME-Worker-4 : RegisteredDriversConnectionFactory : Database Connector : 0:1 : Create new connection for key: ConnectionKey [db-user=HISSA, db-name=jdbc:netezza://netezza.ag.fi:5480/MYDATA, wf-user=HISSA]
2018-12-20 10:05:28,729 : DEBUG : KNIME-Worker-4 : DatabaseDriverLoader : Database Connector : 0:1 : Database driver retrieved from user defined drivers: org.netezza.DriverDriver info: Driver class name: org.netezza.Driver major version: 7 minor version: 2 jdbc compliant: false
2018-12-20 10:05:28,729 : DEBUG : pool-4-thread-2 : RegisteredDriversConnectionFactory : Database Connector : 0:1 : Opening database connection to “jdbc:netezza://netezza.ag.fi:5480/MYDATA”…
2018-12-20 10:05:44,753 : DEBUG : KNIME-Worker-4 : Node : Database Connector : 0:1 : reset
2018-12-20 10:05:44,753 : ERROR : KNIME-Worker-4 : Node : Database Connector : 0:1 : Execute failed: Could not create connection to database: Connection to database ‘jdbc:netezza://netezza.ag.fi:5480/MYDATA’ timed out
2018-12-20 10:05:44,753 : DEBUG : KNIME-Worker-4 : Node : Database Connector : 0:1 : Execute failed: Could not create connection to database: Connection to database ‘jdbc:netezza://netezza.ag.fi:5480/MYDATA’ timed out
java.sql.SQLException: Could not create connection to database: Connection to database ‘jdbc:netezza://netezza.ag.fi:5480/MYDATA’ timed out
at org.knime.base.node.io.database.connection.JDBCConnectorNodeModel.execute(JDBCConnectorNodeModel.java:122)
at org.knime.core.node.NodeModel.executeModel(NodeModel.java:567)
at org.knime.core.node.Node.invokeFullyNodeModelExecute(Node.java:1186)
at org.knime.core.node.Node.execute(Node.java:973)
at org.knime.core.node.workflow.NativeNodeContainer.performExecuteNode(NativeNodeContainer.java:559)
at org.knime.core.node.exec.LocalNodeExecutionJob.mainExecute(LocalNodeExecutionJob.java:95)
at org.knime.core.node.workflow.NodeExecutionJob.internalRun(NodeExecutionJob.java:179)
at org.knime.core.node.workflow.NodeExecutionJob.run(NodeExecutionJob.java:110)
at org.knime.core.util.ThreadUtils$RunnableWithContextImpl.runWithContext(ThreadUtils.java:328)
at org.knime.core.util.ThreadUtils$RunnableWithContext.run(ThreadUtils.java:204)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTaskT.java:266)
at org.knime.core.util.ThreadPool$MyFuture.run(ThreadPool.java:123)
at org.knime.core.util.ThreadPool$Worker.run(ThreadPool.java:246)
Caused by: java.sql.SQLException: java.io.IOException: Connection to database ‘jdbc:netezza://netezza.ag.fi:5480/MYDATA’ timed out
at org.knime.core.node.port.database.DatabaseConnectionSettings.execute(DatabaseConnectionSettings.java:691)
at org.knime.base.node.io.database.connection.JDBCConnectorNodeModel.execute(JDBCConnectorNodeModel.java:113)
… 13 more
Caused by: java.io.IOException: Connection to database ‘jdbc:netezza://netezza.ag.fi:5480/MYDATA’ timed out
at org.knime.core.node.port.database.connection.CachedConnectionFactory.getConnection(CachedConnectionFactory.java:244)
at org.knime.core.node.port.database.DatabaseConnectionSettings.createConnection(DatabaseConnectionSettings.java:474)
at org.knime.core.node.port.database.DatabaseConnectionSettings.execute(DatabaseConnectionSettings.java:667)
… 14 more
2018-12-20 10:05:44,753 : DEBUG : KNIME-Worker-4 : WorkflowManager : Database Connector : 0:1 : Database Connector 0:1 doBeforePostExecution
2018-12-20 10:05:44,753 : DEBUG : KNIME-Worker-4 : NodeContainer : Database Connector : 0:1 : Database Connector 0:1 has new state: POSTEXECUTE
2018-12-20 10:05:44,753 : DEBUG : KNIME-Worker-4 : WorkflowManager : Database Connector : 0:1 : Database Connector 0:1 doAfterExecute - failure
2018-12-20 10:05:44,753 : DEBUG : KNIME-Worker-4 : Node : Database Connector : 0:1 : reset
2018-12-20 10:05:44,753 : DEBUG : KNIME-Worker-4 : Node : Database Connector : 0:1 : clean output ports.
2018-12-20 10:05:44,753 : DEBUG : KNIME-Worker-4 : WorkflowDataRepository : Database Connector : 0:1 : Removing handler 96f5d111-e1e2-4573-8262-ac434d0679bd (Database Connector 0:1: ) - 0 remaining
2018-12-20 10:05:44,753 : DEBUG : KNIME-Worker-4 : NodeContainer : Database Connector : 0:1 : Database Connector 0:1 has new state: IDLE
2018-12-20 10:05:44,753 : DEBUG : KNIME-Worker-4 : Node : Database Connector : 0:1 : Configure succeeded. (Database Connector)
2018-12-20 10:05:44,753 : DEBUG : KNIME-Worker-4 : NodeContainer : Database Connector : 0:1 : Database Connector 0:1 has new state: CONFIGURED
2018-12-20 10:05:44,753 : DEBUG : KNIME-Worker-4 : NodeContainer : Database Connector : 0:1 : KNIME_project 0 has new state: IDLE
2018-12-20 10:05:44,753 : DEBUG : KNIME-WFM-Parent-Notifier : NodeContainer : : : ROOT has new state: IDLE