SYMPTOM:
The following error message is returned when running a report in Strategy 10.x against an Oracle warehouse.
Sample Code/Error
Database error <> : Push Auto Commit failed.
Error type: Odbc error, Odbc operation attempted: SQLSetConnectOption. Option: SQL_ATTR_QUTOCOMMIT. ORA-01012: Not logged on.
CAUSE:
This error is returned by the Oracle warehouse and it typically means that the user session is terminated.
ACTION:
To resolve this issue, contact your local database administrator to ensure that the database session is active.
Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.