SAP Knowledge Base Article - Preview

1814644 - Error: "Failed to retrieve cluster name from the database.........[Microsoft][SQL Native Client]Invalid cursor state." in SIA Configuration tab in BOE XI 3.1

Symptom

  • Error: "Cannot access the repository. (USR0013)  

[repo_proxy 13] SessionFacade::openSessionLogon with user info has failed(Unable to log on: Could not connect to server IOMRPT01:6400.  Please check that the server name is correct, and that the server is running.(hr=#0x80042a01)" when logon to client tools.

Errors in Event Viewer:

  • "Server Intelligence Agent: CMS <SIA_Name>.CentralManagementServer has failed and the Server Intelligence Agent has not been able to connect to the cluster. Please verify your CMS port and database settings are correct."
  • "The root server reported an error Initialization Failure. (Reason: Database access error. Reason [Microsoft][SQL Native Client]Invalid cursor state.Database access error. Reason [Microsoft][SQL Native Client]Invalid cursor state. Error committing transaction for AddIndex_Dynamically."
  • "CMS is unstable and will shut down immediately. Reason: Database access error. Reason [Microsoft][SQL Native Client]Invalid cursor state."


Read more...

Environment

  • SAP BusinessObjects Enterprise (BOE) XI 3.1
  • MS SQL Server 2005
  • Windows Server

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

ccm, cluster, fail, unable, logon, config, repo, proxy, repository, index, connect, sql, schema, cms , 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.