ODBC CONNECTION DEAD Error

[Shakti_Sourav]

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

[SASKiwi]

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.

[Shakti_Sourav]

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 ?

[Kurt_Bremser]

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.