Summary:
Connection issues with Oracle 12c were noticed when upgrading Strategy to 10.10 version or after installation of Hotfix 6 for version 10.4. Encountered issue is below described and resolved.
Symptom:
Connection to History List and/or Repository is being randomly terminated and in DSSErrors.log below errors can be found:
[SERVER:CastorServer][PID:7939][THR:140397216220928][Metadata Server][Error][0x80041404] Database error <5>: Push Auto Commit failed.
Error type: Odbc error. Odbc operation attempted: SQLSetConnectOption. Option: SQL_ATTR_AUTOCOMMIT. [HY000:-5: on SQLHANDLE] [Strategy][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.
Cause:
Root cause of the issue are drivers for Oracle 12c installed with 10.4.6 and 10.10 versions.
Action:
Replace drivers for Oracle 12c with drivers from previous version (for example Strategy 10.4.0). Default path for Linux is following:
Installation path/opt/MicroStrategy/lib/ files MYora64.so and MYoraXX.so
In Windows drivers should be placed in:
Local host\Program Files (x86)\Common Files\MicroStrategy\ODBC files myora64.dll and myora64r.dll
Issue should be resolved also in version 10.11 KB440365
