KB439929: Enterprise Manager Data Loader Service fails to start with Oracle Database on 10.4 Hotfix 6

Senior Manager, Technical Support • MicroStrategy

This knowledge base article describes an issue that has been classified as a defect by MicroStrategy. In MicroStrategy Secure Enterprise 10.10 and 10.4 Hotfix 6, the Enterprise Manager data loader service fails to start when configured to an Oracle 12c Enterprise Manager and statistics repository. This issue has been addressed in MicroStrategy Secure Enterprise 10.11 and 10.4 Hotfix 7.

SUMMARY
This knowledge base article describes an issue that has been classified as a defect by Strategy. On Strategy 10.10 and 10.4 Hotfix 6, the Enterprise Manager data loader service fails to start when configured to an Oracle 12c Enterprise Manager and statistics repository. This issue has been addressed in Strategy Secure Enterprise 10.11 and 10.4 Hotfix 7.
SYMPTOM
When starting the Enterprise Manager data loader service while using an Oracle 12c Enterprise Manager and statistics repository in Strategy Secure Enterprise 10.10 or 10.4 Hotfix 6, the service fails to start will the following error message:


Failed to start service
Error Code: -1
Error Message: MExec:ApplicationProxy_Impl::RunInternal: Attempt to 'start' failed with error code -1 (0xFFFFFFFF)

At this time, the DSSErrors.log contains the following entries:


[Database Classes][Error] FetchScroll failed. 
Error type: Odbc error. Odbc operation attempted: SQLFetchScroll. [HY000:-5: on SQLHANDLE] [Strategy][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.

CAUSE
This is a known issue with the Strategy ODBC Driver for Oracle Wire Protocol version 8.0.1 shipped with Strategy 10.10 and 10.4 Hotfix 6 where it encounters a failure when trying to fetch data with the CLOB datatype.
ACTION
This issue has been addressed in Strategy Secure Enterprise 10.11 and 10.4 Hotfix 7. Upgrade to the latest platform release or feature release version to take advantage of this fix.
KB439929

Comment

0 comments

Details

Knowledge Article

Published:

March 29, 2018

Last Updated:

January 4, 2019

[Database Classes][Error] FetchScroll failed. Error type: Odbc error. Odbc operation attempted: SQLFetchScroll. [HY000:-5: on SQLHANDLE] [Strategy][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.