SAP Knowledge Base Article - Preview

2786412 - The cluster key is incorrect updating CMS DB credentials

Symptom

  • Error message 'The cluster key is incorrect.' generated in Central Configuration Manager (CCM) when updating the Central Management Server (CMS) database credentials
  • Following trace generated in the SvcMgr logs when enabled as per KBA 2190489

    (DatabaseSubsystem_impl.cpp:2175) DatabaseSubsystem::CheckDBCredentialsOnTable(<database schema name>.CMS_VersionInfo)
    assert failure: (..\..\SQLGenerator.cpp:231). (insertColumns.GetSize() > 0 && !table.isEmpty() : no message).
    (..\ODBCStatement.cpp:188) Prepare: SQL: INSERT INTO <database schema name>.CMS_VersionInfo () VALUES()
    assert failure: (..\ODBCStatement.cpp:743). (numCols > 0 : no message).
    (..\ODBCStatement.cpp:197) Prepared statement Execute
    (..\ODBCDatabase.cpp:158) ODBC error found: ErrorMessage([Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ')'.), ErrorCode(102)
    (TransactionManager.cpp:154) DBConnectionHolder - Caught retryable error with Code 102, Msg: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ')'.. Number of retryable errors on connection 1 is 1.
    (dbutils.cpp:652) Caught DatabaseSubystem Error: Database access error. Reason [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ')'..
    DatabaseSubsystem::Shutdown()



Read more...

Environment

  • SAP BusinessObjects Business Intelligence (BI) Platform 4.2 
  • Central Configuration Manager (CCM)

Product

SAP BusinessObjects Business Intelligence platform 4.2

Keywords

KBA , BI-BIP-SRV , CMS / Auditing issues (excl. 3rd Party Authentication) , Problem

About this page

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

Search for additional results

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