Connection Timed Out SQL Server

Five Stars

Connection Timed Out SQL Server

I have created a project that pulls a json string from dynamoDB and extracts the json string and inserts it into an aws rds instance of SQL Server.  It runs great as a local project.  The issue is, as soon as I move it to the cloud, it fails with a connections timed out error.  I have also tried this with an on-prem SQL Server and get the same error.  Any help would be greatly appreciated

 

Step 6ce9beab-83f2-4d7e-be1d-b1e479ffdbeb failed with code -1 and error Job stopped with errors or unable to run. ### Job STARTED at 2019/08/12 12:34:06 (jobId=4987a3dc84431d6093622, jobExecutionId=20190812123405_FdywK) ### ### Job ENDED WITH ERROR at 2019/08/12 12:36:20 (jobId=4987a3dc84431d6093622, jobExecutionId=20190812123405_FdywK) ### Exception in component tDBOutput_1 (dynamoJSONtoSQLServerDev) java.sql.SQLException: Network error IOException: Connection timed out (Connection timed out) at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436) at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at local_project.dynamojsontosqlserverdev_0_1.dynamoJSONtoSQLServerDev.tDynamoDBInput_1Process(dynamoJSONtoSQLServerDev.java:11937) at local_project.dynamojsontosqlserverdev_0_1.dynamoJSONtoSQLServerDev$2.run(dynamoJSONtoSQLServerDev.java:20486) Caused by: java.net.ConnectException: Connection timed out (Connection timed out) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source) at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source) at java.net.AbstractPlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288) at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251) at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331)

Employee

Re: Connection Timed Out SQL Server

Hi,

 

    If you are using a Cloud Remote Jobserver, could you please check whether the IP address has been white-listed in Security groups of AWS? Since its workign fine from your machine, the issue could be something related to IP blocking.

 

     Please refer the AWS documentation for details.

 

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.RDSSecurityGroups.html

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Five Stars

Re: Connection Timed Out SQL Server

The IP address has been whitelisted in AWS.  I have also tried running it in an on-prem sql server and I am getting the same error.  I have checked permissions in SQL Server and nothing I have tried works.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now

The Forrester Wave: Strategic iPaaS and Hybrid Integration Platforms, Q1 2019

Find out how Forrester rate different iPaaS and Hybrid Integration Platforms

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog