topic Re: Error in JDBC Stored procedure component when using with Azure Sql in Talend Studio

Error in JDBC Stored procedure component when using with Azure Sql

Anonymous — Tue, 27 Jan 2015 15:47:23 GMT

Hi
I have a job where i am reading data from a stage table - validate the data using a schema compliance check component and then insert it into the final production table.
If there is an error on the schema compliance component the error path is connected to a stored procedure component which updates the staging table status column to FAIL with an appropriate error message.
However i keep getting the following error at the stored procedure
Exception in component tJDBCSP_1
com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1668)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1655)
at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1789)
at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:4838)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:6150)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:402)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1716)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)
disconnected
at biopharm.prod_hcp_address_1_0.prod_hcp_address.tJDBCInput_1Process(prod_hcp_address.java:4274)
at biopharm.prod_hcp_address_1_0.prod_hcp_address.runJobInTOS(prod_hcp_address.java:6672)
at biopharm.prod_hcp_address_1_0.prod_hcp_address.main(prod_hcp_address.java:6531)
I have attached the screen shot below. Any clues?
Thanks

Re: Error in JDBC Stored procedure component when using with Azure Sql

Anonymous — Wed, 28 Jan 2015 03:55:08 GMT

Hi,
Have you already checked if your Azure Sql table is locked or blocked?
Best regards
Sabrina

Re: Error in JDBC Stored procedure component when using with Azure Sql

Anonymous — Wed, 28 Jan 2015 16:16:31 GMT

Hi Sabrina
Checked the event logs - there are no deadlocks. But what i do see is the following message "Connection has been idle for longer than system defined threshold."
Is it possible that the error is because of the above? If so then what is the mechanism in Talend to retry and connect? What can be done to avoid this error?
Regards
Sid

Re: Error in JDBC Stored procedure component when using with Azure Sql

Anonymous — Wed, 28 Jan 2015 18:05:10 GMT

You may find this link on azure retry useful. Unfortunately the examples are all .NET
I am considering using Talend with Azure Sql and interested in your results.

Re: Error in JDBC Stored procedure component when using with Azure Sql

Anonymous — Thu, 29 Jan 2015 15:21:38 GMT

Sabrina
The lost connection seems to be the reason for failure. Surely talend must have some retry functionality for lost database connection. If not what are your recommendations?
Sid

Re: Error in JDBC Stored procedure component when using with Azure Sql

Anonymous — Thu, 05 Feb 2015 20:28:02 GMT

Any updates/workarounds in Talend open studio to retry connections?