2459928 - BI 4.2 SP3 installation setup creates CMS and Audit tables in MS SQL Server 'master' database | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2459928 - BI 4.2 SP3 installation setup creates CMS and Audit tables in MS SQL Server 'master' database

Symptom

  • Post installation of SAP BusinessObjects Business Intelligence 4.2 Support Pack 3, the CMS and Audit database does not reflect any related tables.
  • SAP BusinessObjects Business Intelligence 4.2 Support Pack 3 installation setup created all the CMS and Audit database related tables under the 'master' database (which is a system database in SQL Server 2014) instead of the respective CMS and Audit database.

“Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP BusinessObjects Business Intelligence 4.2 Support Pack 3
  • SQL Server Database 2014
  • Supported Windows Operating System

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SBOP BI PLATFORM 4.3

Keywords

SAPBO BOBJ BI4 4.0 4.1 4.2 installation prerequisite required permission role setupengine Microsoft best practice CMS_Aliases7 CMS_IdNumbers7 CMS_InfoObjects7 CMS_LOCKS7 CMS_RELATIONS7 CMS_Sessions7 CMS_VersionInfo ADS_APPLICATION_TYPE_STR ADS_AUDITEE ADS_CLUSTER ADS_CLUSTER_STR ADS_EVENT ADS_EVENT_CATEGORY_STR ADS_EVENT_DELETES ADS_EVENT_DETAIL ADS_EVENT_DETAIL_DELETES ADS_EVENT_DETAIL_TYPE_STR ADS_EVENT_TYPE ADS_EVENT_TYPE_STR ADS_OBJECT_TYPE_STR ADS_SERVER_NAME_STR ADS_SERVER_TYPE_STR ADS_SERVICE_TYPE_STR ADS_STATUS_STR ADS_SUPPORTED_EVENTS ADS_TENANT ADS_USER COMMENTARY_MASTER INCOMPLETE_EVENT database user account right , KBA , BI-BIP-DEP , SBOP Web Application Deployment, Wdeploy , BI-BIP-INS , Enterprise (BI platform) installation, upgrade, patching , 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.