Hi everybody!
I´m using Dataflux Data Management Studio 2.6 to connect and join 6 tables (same database) that came from an Oracle Server.
- ODBC connection using Dataflux 32 bit Oracle Wire Protocol
The job is totally functional when we limit the number of registries (about 1000) and the result is OK.
However, when we use the entire load, we´re usually receiving an Connection Dead Error like this below:
"[24:SOURCE_ODBCSQL:Lê ARQUIVO_RAIS] [08S01] [DataFlux][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead. (-4)"
I would appreciate any information or guidance in resolving this situation.
Hi - it's hard to tell what's going on without additional information but here are some thoughts:
Ron
Thank´s Ron,
I´ve turned on advanced "DAC" logging (TRACE) and can´t find any explicit reason for the problem.
So, now we are mantaining contacts with our DBA for monitoring that long-running queries.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.