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.

Symptoms

This error happens when you remove a connection to a data source on Db2® Warehouse on Cloud, which has "use_SSL": 1 by default.

For example, you might see the following message.

Load configured data source failed: HttpError524

Resolving the problem

This error occurs because the removal of the data source connection exceeds a connection limit.

You can work around this issue by running the following SQL statement in the SQL editor:

select CID, NODE_NAME from DVSYS.listrdbc;

This query lists all of the connections in the cluster. Find the row in the output for the connection that you want to remove and run the following statement in the SQL editor.

CALL DVSYS.REMOVERDBCX('<CID>', '<NODE_NAME>', ?)

Where you substitute the following values.

<CID> is the CID output from the DVSYS.listrdbc query.
<NODE_NAME> is the NODE_NAME output from the DVSYS.listrdbc query.