SAP Knowledge Base Article - Preview

1670457 - BI 4.x auditing error: No CMS is configured as an auditor

Symptom

When configuring  auditing section in CMC and enter below configuration

  • Connection Name:
  • Type:
  • User Name:
  • Password:

It throws the following error:  "No CMS is configured as an auditor"

  • Error in CMS logs:

2024 12 02 15:33:24:394|CMS_BI|(AuditDatabaseSubsystem_impl.cpp:218) DatabaseHolder - (AuditDB) - Caught retryable error with Code 262, Msg: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]CREATE TABLE permission denied in database 'BI_Auditing'..  Number of retryable errors on this connection is 1 (at AuditDatabaseSubsystem_impl.cpp:3918)

2024 12 02 15:33:24:394|cms_BI|Unable to load audit database subsystem: Database access error. Reason [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]CREATE TABLE permission denied in database 'BI_Auditing'.. Error creating Audit Event table.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence 4.x
  • MS SQL Server as Auditing database
  • MS Windows Server Operating System

Product

SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3

Keywords

auditing BI, BOE, no cms, BI, 4.x, 4.2, 4.3, auditeen auditer, ADS. , KBA , BI-BIP-SRV , CMS / Auditing issues (excl. 3rd Party Authentication) , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , 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.