Four Stars

DB Connection Timeout Issue

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.

8 REPLIES
Eleven Stars

Re: DB Connection Timeout Issue

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

Manohar B
Eleven Stars

Re: DB Connection Timeout Issue

@Bapps,what is exact component name of DBinput?

Manohar B
Four Stars

Re: DB Connection Timeout Issue

I did. It's all JDK 1.8
Four Stars

Re: DB Connection Timeout Issue

tNetezzaInput
Eleven Stars

Re: DB Connection Timeout Issue

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

Manohar B
Four Stars

Re: DB Connection Timeout Issue

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

Re: DB Connection Timeout Issue

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

Manohar B
Four Stars

Re: DB Connection Timeout Issue

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.