OK/INFO - 1021013 - ODBC Layer Error: [08S01] ==> [[DataDirect][ODBC Oracle Wire Protocol driver][Or
Dear Experts,
We have been facing issue with Essbase dimension build ETL scripts on the below systems.
Target: Essbase server on Exalytics box.
Source: ADW server on Exadata box.
Interface: SQL
Driver: ODBC
Error we get when we are running the dimension extract.
OK/INFO - 1021013 - ODBC Layer Error: [08S01] ==> [[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead.].
OK/INFO - 1021014 - ODBC Layer Error: Native Error code [4294967292].
ERROR - 1021001 - Failed to Establish Connection With SQL Database Server. See log for more information.
ERROR - 1241101 - Unexpected Essbase error 1021001.
The catch here is that this issue occurs only during particular time of the day (12:00 AM - 01:30 AM EST). Can you please help with any pointers to resolve this issue?