Note that the workflow executes just fine via my analytics platform.
I don’t even files or pass parameters.
The workflow simply connects to my database and updates records.
What could I be missing?
How do I diagnose the issue?
Suggestions welcome.
Communications link failure basically means that the client (the server executor) is not able to communicate with the server (your MySQL server) and can have different causes. Successful connection from client eliminates already some of them.
Do you use hostname or IP in the database URL? If it is hostname, can you verify that it is being resolved correctly from the DNS or use IP instead? Can you ping the DB server from your AWS KNIME Server vm? Is there a limitation in open connections that you might have run into? Is some system in between KNIME Server and DB server that is blocking connections, e.g. a firewall or proxy?