1725614 - Reason[Microsoft][ODBC SQL Server Driver]Invalid cursor state.. error when accessing SIA Configuration tab

Symptom

Error in Service Intelligence Agent (SIA) Configuration tab with one of the following errors:

Failed to retrieve cluster name from the database. Reason: Database access error. Reason[Microsoft][ODBC SQL Server Driver]Invalid cursor state..

Failed to retrieve cluster name from the database. Reason: Database access error. Reason[Microsoft][SQL Server Native Client 10.0]Invalid cursor state..

Following messages appears In Central Management Server trace:

2012 06 01 07:20:11:512| | | 2344| 716|(.\SQLServerStatement.cpp:187) ExecDirect: SQL: EXEC sp_helpindex "dbo.CMS_InfoObjects7"
2012 06 01 07:20:11:512|A| | 2344| 716|assert failure: (.\SQLServerDatabase.cpp:173). (SQL_SUCCEEDED( rc ) : no message).
2012 06 01 07:20:11:512|A| | 2344| 716|assert failure: (.\SQLServerStatement.cpp:214). ((SQL_SUCCEEDED(rc) && numColumns) : ).
2012 06 01 07:20:11:512| | | 2344| 716|(.\SQLServerStatement.cpp:330) CSQLServerStatement::FetchNext: error [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2012 06 01 07:20:11:512| | | 2344| 716|(.\SQLServerDatabase.cpp:122) SQLServer error found: ErrorMessage([Microsoft][ODBC SQL Server Driver]Invalid cursor state), ErrorCode(0)
2012 06 01 07:20:11:512| | | 2344| 716|(.\TransactionManager.cpp:154) DBConnectionHolder - Caught retryable error with Code 0, Msg: [Microsoft][ODBC SQL Server Driver]Invalid cursor state. Number of retryable errors on connection 1 is 1.
2012 06 01 07:20:11:512|E|X| 2344| 716|DatabaseSubsystem::Connect(): 0.062
2012 06 01 07:20:11:512|E|X| 2344| 716|Loading: database subsystem: 0.078
2012 06 01 07:20:11:512|E|X| 2344| 716|CSubsystemManager::Init: 0.078
2012 06 01 07:20:11:528| | | 2344| 716|SIServerController:run: Fail to initialize or uninitialize. Reason is The root server reported an error Initialization Failure. (Reason: Database access error. Reason [Microsoft][ODBC SQL Server Driver]Invalid cursor state.Database access error. Reason [Microsoft][ODBC SQL Server Driver]Invalid cursor state. Error committing transaction for AddIndex_Dynamically.
).:Database access error. Reason [Microsoft][ODBC SQL Server Driver]Invalid cursor state. Error committing transaction for AddIndex_Dynamically.

Environment

SAP Business Objects Business intelligence Platform 4.0
Microsoft SQL Server

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence, Edge edition 4.0, version with data integration

Keywords

KBA , BI-BIP-DEP , Webapp Deployment, Networking, Vulnerabilities, Webservices , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.