SAP Knowledge Base Article - Preview

2177281 - "select permission was denied on ra_ddl_trig_" - SAP SRS (RSO)

Symptom

  • After installing Replication Agent for Microsoft SQLServer (RAM), the following error is reported from user applications:

"select permission was denied on ra_ddl_trig_"

  • Using SQL Profiler, Immediately before the above problem the following errors are reported: 

"User Error Message CREATE SCHEMA failed due to previous errors", the statement:

DELETE from ra_ddl_trig_ WHERE ddlid=(SELECT SCOPE_IDENTITY());


Read more...

Environment

  • SAP Replication Server (SRS)
  • SAP Replication Server (SRS) Heterogeneous Edition
  • SAP Replication Server Option (RSO) for Microsoft SQL Server

Product

SAP Replication Server all versions ; SAP Replication Server, heterogeneous edition all versions ; SAP Replication Server, option for Microsoft SQL Server all versions

Keywords

RAX, RAX/MSSQL, RepAgent, RAM , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , BC-SYB-REP-RSO , Rep Server Options (RSO) , BC-SYB-REP-ME , Replication Server Messaging Edition (RSME) , 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.