SAP Knowledge Base Article - Preview

2848690 - Error: "Cannot execute as the database principal because the principal "dbo" does not exist" for subscription

Symptom

  • 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.


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA 1.0 smart data integration ; SAP HANA smart data integration 2.0

Keywords

SDI, MSSQL, owner, principal , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.