12-13-2016 03:13 PM
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:
"[24OURCE_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.
12-15-2016 10:41 AM
Hi - it's hard to tell what's going on without additional information but here are some thoughts:
12-20-2016 08:44 AM
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.