DB Connection Timeout Issue

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.

Forteen Stars

Re: DB Connection Timeout Issue

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: DB Connection Timeout Issue

@Bapps,what is exact component name of DBinput?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: DB Connection Timeout Issue

I did. It's all JDK 1.8
Four Stars

Re: DB Connection Timeout Issue

tNetezzaInput
Forteen Stars

Re: DB Connection Timeout Issue

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: DB Connection Timeout Issue

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

Re: DB Connection Timeout Issue

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
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.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch