DB Connection Timeout Issue

[Bapps]

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.

[manodwhb]

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

[manodwhb]

@Bapps,what is exact component name of DBinput?

[Bapps]

I did. It's all JDK 1.8

[Bapps]

tNetezzaInput

[manodwhb]

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

[Bapps]

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

[manodwhb]

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

[Bapps]

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.