Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Search our knowledge base, curated by global Support, for answers ranging from account questions to troubleshooting error messages.
After executing for more than one hour, tasks are failing with the error shown below:
java.sql.SQLException: [Amazon](500150) Error setting/closing connection: Not Connected
This generally is caused by not having the proper security group configuration in Redshift (for example, whitelist the IP address of the server running the Spark driver).
Get the hostname and/or IP address from the Remote Engine machine that is running the failed task.
After making the changes, use the telnet command to verify whether the connection from the Remote Engine server to Redshift is successful or not.
If the problem persists, contact AWS Redshift support to check if there's an issue on their end.