topic Re: DB Connection Timeout Issue in Talend Studio

DB Connection Timeout Issue

Bapps — Fri, 11 May 2018 06:14:05 GMT

Hi,

My job is working fine in lower environment but failing in Production with below error at the very first component DBInput itself -

"The action you have attempted has caused the back end to close the connection"

My DBInput SQL is compiling well, returning out when executing in Netezza Agent but somehow failing after deployment only in Production.

Please advise as I'm getting no clue about it.

Re: DB Connection Timeout Issue

manodwhb — Fri, 11 May 2018 06:38:37 GMT

@Bapps,could you please check java verion in production and lower environment?

Re: DB Connection Timeout Issue

manodwhb — Fri, 11 May 2018 06:40:30 GMT

@Bapps,what is exact component name of DBinput?

Re: DB Connection Timeout Issue

Bapps — Fri, 11 May 2018 06:41:46 GMT

I did. It's all JDK 1.8

Re: DB Connection Timeout Issue

Bapps — Fri, 11 May 2018 06:42:12 GMT

tNetezzaInput

Re: DB Connection Timeout Issue

manodwhb — Fri, 11 May 2018 06:43:15 GMT

@Bapps,can you in production is Module nzjdbc.jar has installed?

Re: DB Connection Timeout Issue

Bapps — Fri, 11 May 2018 06:45:11 GMT

Yes, I've installed. It's part of my springboot package already.

Re: DB Connection Timeout Issue

manodwhb — Fri, 11 May 2018 06:48:32 GMT

@Bapps,then there could be a proxy issue,since the same is working from lower environment.

Re: DB Connection Timeout Issue

Bapps — Fri, 11 May 2018 06:53:21 GMT

One of my job is working fine reading from Netezza in same environment.

Hence, shouldn't be proxy issue. I feel connection is getting timedout and reset. Need a clue how can I change time out parameter.