Symptom
After back-end system is refreshed, recreating the remote source again from the administrative UI failed with error below:
REPLICATION TEST CASE: T002C replication not completed.
…
CDC open session failed: RS[<remote source name>]
Failed to add the first subscription. Error: com.microsoft.sqlserver.jdbc.SQLServerException: CREATE TABLE permission denied in database ‘XXX’.
Read more...
Environment
SAP Configuration and Pricing Services
Product
Keywords
REPLICATION TEST CASE: T002C replication not completed, CDC open session failed, Failed to add the first subscription, CREATE TABLE permission denied in database, SDI_USER, mssql_trigger_based_init.sql, DP agent , KBA , LOD-CPS-AUS , Data Replication and Admin UI , 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.