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.