topic ODBC CONNECTION DEAD Error in New SAS User

ODBC CONNECTION DEAD Error

Shakti_Sourav — Wed, 27 Apr 2022 05:11:09 GMT

Dear Team,

I am using Data Management Studio for De-Duplication. I have one dataset having 6 crores records.

But when I am executing my data job it gives error after read 5 crores record.

Error : ODBC Connection Dead.

I have attached screenshot for your reference.

Thank You

Shakti

Re: ODBC CONNECTION DEAD Error

SASKiwi — Wed, 27 Apr 2022 08:19:01 GMT

Most likely there is a timeout rule being applied to your data connection. How long does the job run for before timing out? The problem is identifying where the timeout is being applied. I suggest you discuss the problem with your SAS administrator is this could be an Oracle connection timeout or a TCP network connection firewall timeout.

Re: ODBC CONNECTION DEAD Error

Shakti_Sourav — Mon, 06 Jun 2022 07:08:41 GMT

Hi,

Discussed with DBA as they said there is unlimited time set for the connection.

Is there any time out setting in SAS-Data flux ?

Re: ODBC CONNECTION DEAD Error

Kurt_Bremser — Mon, 06 Jun 2022 08:21:53 GMT

I'd say somewhere between SAS and Oracle there's a router/firewall that kills your connection. Experiment with different amounts of data to get a feel for the time at which the disconnect happens. This will help the network people to find where it happens.