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 for Me (Login required).

Search for additional results

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