When starting the DCDCONTL UI, I am getting 'Database connection or query execution failure' error and CannotGetJdbcConnectionException error in the DCDCONTL STDOUT sysout, what causes this?

Document ID : KB000016445
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

When starting the DCDCONTL UI, I am getting 'Database connection or query execution failure' error and CannotGetJdbcConnectionException error in the DCDCONTL STDOUT sysout, what causes this?

The DCDCONTL task STDOUT contains the following error:

2017-11-02 09:24:54,814 Received an exception org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (Ýjcc¨Ýt4¨Ý10380¨Ý11951¨Ý4.12.55¨ Required property "sys1.company.com" is unknown host. ERROR CODE=-4222, SQLSTATE=08001)                        

 

Answer:

The error can occur if the host does not resolve to an ip address. Verify that your TCPIP data set is in LINKLIST or the DCDCONTL proc has a SYSTCPD DD pointing to your TCPIP dataset.