My Oracle Support Banner

ADD TRANDATA fails for SQL Server with Error 15517: Failed to Execute SetCDCTracked(Value=1) (Doc ID 2439950.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 12.3.0.1.3 and later
Microsoft Windows x64 (64-bit)

Symptoms

Problem Summary
---------------------------------------------------
GG CDC setup on SQL 2008 sp4 - Error 15517. Failed to execute SetCdCTracked(Value = 1)

When users execute "add trandata dbo.tablename" they get following error:

2018-06-26 17:10:59 ERROR OGG-05268 Change data capture failed for the table 'dbo.joepk' in the database 'ESR_MANAGMENT': error: SQLCODE 50000. SQL Error [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Could not update the metadata that indicates database ESR_MANAGMENT 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 r.

2018-06-26 17:10:59 ERROR OGG-05278 Failed to enable logging of supplemental log data for table: dbo.joepk.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.