Troubleshooting data source connections in Watson Query

Use these solutions to resolve the problems that you might encounter with data sources and remote data sources.

CID and TDEF columns are not returned when you reload tables in Kerberos-enabled Hive data sources
The results of the CID and TDEF columns are not returned when you reload tables in Kerberos-enabled Hive data sources.
Restoring a connection in Watson Query that was removed from Platform connections
If a connection is removed from Platform connections and the credentials change, users might see errors when they query tables that were created for that data source.
Adding a connection to an existing Amazon RDS for MySQL Platform connection fails
When you add a connection to an existing Amazon RDS for MySQL Platform connection with SSL enabled, it fails.
Credential error message when you remove a virtualized table in object storage
In Watson Query, when you try to remove a virtualized table in object storage after the connection to the data source was removed, an error occurs.
Adding a remote data source with vaulted credentials fails in Watson Query
When you add or use a data source on a remote agent that is configured with credentials that are stored in a vault, you might see a Failed to update connection details error.
A data source cannot be added with personal credentials from a vault in Watson Query
When you try to add a data source connection in which personal credentials are stored in a vault, you might see the message: The data source could not be added. Ensure that the specified parameters are correct and try again.
Cannot push down string functions with string units on Db2 remote data source in Watson Query
You can use string functions with string units from a Db2® remote data source; however, the string function is not pushed down on the Db2 remote data source.
Snowflake connection times out in Watson Query
A Snowflake connection in Watson Query might time out with an authentication token expiry message.
Cannot connect to a data source in Watson Query
You configure a data source connection to Watson Query, but the connection fails.
Cannot preview data from Salesforce.com in Watson Query
You get an error when you try to preview data from Salesforce.com.
Cannot push down join views on remote data sources in Watson Query
You create a join view of two tables from the same data source that have two columns with the VARCHAR data type. However, the join view is not pushed down on the remote data source.
Errors when you edit an SSL-based connection in Watson Query
When you edit an SSL-based connection, you might see DB_WARNING errors.
Errors when you delete a connection in Watson Query
When you remove a connection, the removal might time out and you might see HttpError524 errors.
Remote connector does not start after restart in Watson Query
Remote connectors do not automatically restart after a restart.
Stack overflow errors on remote connectors in Watson Query
You get a stack overflow error when you browse data on a remote data source.

Parent topic: Troubleshooting the Watson Query service