Symptom
- Execute sp_recompile @objname='dbo.table' in a Warm Standby (WS) or MSA replication system.
- DSI EXEC starts getting the following permission errors after upgraded to SRS 16.0 SP04:
-
ERROR #13040 DSI EXEC(141(1) SDS.SDB) - neric/useful/cmapp.c(709)
Failed to set a property in the connection structure for a connection handle. See Connector error message for more information. -
ERROR #1028 DSI EXEC(141(1) SDS.SDB) - neric/useful/cmapp.c(709)
Message from server: Message: 10331, State 2, Severity 14 -- 'Permission denied, database master, owner dbo. You need the following permission(s) to run this command: SET PROXY.
Read more...
Environment
SAP Replication Server (SRS) 16.0 SP04 and up
Product
Keywords
dsi_replication_ddl; dsi_replication; , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Product Enhancement
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.
SAP Knowledge Base Article - Preview