You are currently reviewing an older revision of this page.
Creating a CDT using create from database table or view option takes a long time to generate data store drop down field.
Following error is observed in the <JBOSS_HOME>\standalone\log\server.log at the same time:
[ajp-/0.0.0.0:8009-34] WARN org.hibernate.cfg.SettingsFactory - Could not obtain connection to query metadata 18:31:43,001 INFO [stdout] (ajp-/0.0.0.0:8009-34) java.sql.SQLException: Cannot create PoolableConnectionFactory (Communications link failure)..Caused by: java.net.UnknownHostException: *Database Host Name*: Name or service not known
Appian is trying to communicate to all the available datasources to populate the drop down but is unable to connect to one/multiple end points after which it eventually times out causing the delay.
Identify the data source causing the delay based on the server.log and confirm if there are network related or other known issues between Appian and the data source.
This article applies to all versions of Appian.
Last Reviewed: September 2018