2605573 - CCDB Extractor error "EXTR_ERROR SQL error 229: The SELECT permission was denied on the object" - SAP Solution Manager 7.2

Symptom

The CCDB Extractor for CONFIGURATION ADD (ABAP) - DBCON is not collecting information due to error "Upload failed 'Extractor Error'":

"SQL error 229: The SELECT permission was denied on object"

The ConfigStores affected: MSSQL_PARAMETER - MSS

CCDB extractor.jpg

Environment

SAP Solution Manager 7.2

Product

SAP Solution Manager 7.2

Keywords

KBA , SV-SMG-DIA-APP-CA , Change Analysis + Reporting, Configuration Validation, CCDB , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , 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.