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?
search cancel

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?

book

Article ID: 16445

calendar_today

Updated On:

Products

Data Content Discovery

Issue/Introduction

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 ([t4][10380][11951][4.12.55] Required property "<hostname>" is unknown host. ERROR CODE=-4222, SQLSTATE=08001)                  

Environment

Release:
Component: DCD

Resolution

The error can occur if the <hostname> 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.