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
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.
SAP Knowledge Base Article - Preview