- Realtime subscription failed for MSSQL table
- Error: "Error executing PreSql or PostSql command.;Error executing ALTER_REMOTE_SUBSCRIPTION_QUEUE with command: 'ALTER REMOTE SUBSCRIPTION "Subscription_Name" QUEUE'. ,exception 71000256: QUEUE: ***: Failed to add subscription for remote subscription *** in remote source <RemoteSource_Name>. Error: exception 151050: CDC add subscription failed: Failed to add the first subscription. Error: Failed to start LogReader because of failure to initialize LogReader. Error: XLog failed to automatically execute creation scripts in database <DB_NAME> because: Could not update the metadata that indicates database DB_NAME is enabled for Change Data Capture. The failure occurred when executing the command 'SetCDCTracked(Value = 1)'. The error returned was 15517: 'Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.'. Use the action and error to determine the cause of the failure and resubmit the request.
SAP HANA Smart Data Integration
SAP HANA 1.0 smart data integration ; SAP HANA smart data integration 2.0
SDI, MSSQL, owner, principal , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.