OGG-05258 Could not retrieve the current Change Data Capture settings for database testdb

Symptom:
2018-09-11 02:00:06 INFO OGG-05264 Opening DSN connection: testdb, Server: mssqlvm01, Database: testdb.
2018-09-11 02:00:06 WARNING OGG-05265 The SQL Agent on server mssqlvm01 is not running. SQL Server CDC requires that the SQL Agent be running to capture change records.

Source Context :
SourceModule : [ggmssqlcdcvam.mssqlcdctable]
SourceID : [ggmssqlcdcvam/MSSqlCDCTable.cpp]
SourceMethod : [mssqlcdcvam::MSSqlCDCJobSettings::ReportCDCCaptureJob]
SourceLine : [668]
ThreadBacktrace : [24] elements
: [E:\OGG4MSSQL\extract.exe(ERCALLBACK)]
: [E:\OGG4MSSQL\gglog.dll(?CreateMessage@CMessageFactory@@QEAAPEAVCMessage@@PEAVCSourceContext@@IZZ)]
: [E:\OGG4MSSQL\gglog.dll(?_MSG_Pointer@@YAPEAVCMessage@@PEAVCSourceContext@@HPEBXW4MessageDisposition@CMessageFactory@@@Z)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [E:\OGG4MSSQL\extract.exe(ERCALLBACK)]
: [C:\Windows\SYSTEM32\MSVCR100.dll(?_is_exception_typeof@@YAHAEBVtype_info@@PEAU_EXCEPTION_POINTERS@@@Z)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [E:\OGG4MSSQL\extract.exe(ERCALLBACK)]
: [E:\OGG4MSSQL\extract.exe(ERCALLBACK)]
: [E:\OGG4MSSQL\extract.exe(VAMVersion)]
: [E:\OGG4MSSQL\extract.exe(VAMMessage)]
: [E:\OGG4MSSQL\extract.exe(_ggTryDebugHook)]
: [E:\OGG4MSSQL\extract.exe(GGDataBufferGetNextChunk)]
: [E:\OGG4MSSQL\extract.exe(GGDataBufferGetNextChunk)]
: [C:\Windows\System32\KERNEL32.DLL(BaseThreadInitThunk)]
: [C:\Windows\System32\KERNEL32.DLL(BaseThreadInitThunk)]
: [E:\OGG4MSSQL\extract.exe(ERCALLBACK)]
: [E:\OGG4MSSQL\extract.exe(_ggTryDebugHook)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [E:\OGG4MSSQL\extract.exe(ERCALLBACK)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [C:\Windows\System32\KERNEL32.DLL(BaseThreadInitThunk)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
2018-09-11 02:00:06 ERROR OGG-05258 Could not retrieve the current Change Data Capture settings for database testdb. Ensure that the database is enabled for Change Data Capture. For information regarding enabling supplemental logging, see Installing and Configuring Oracle GoldenGate for SQL Server.
2018-09-11 02:00:06 ERROR OGG-01668 PROCESS ABENDING.

Cause:
Not create CDC jobs and dbo.cdc_jobs table in database.

Solution:
1. Enable CDC
USE MyDB
GO
EXEC sys.sp_cdc_enable_db
GO
2. Create CDC jobs:
USE AdventureWorks2012;
GO
EXEC sys.sp_cdc_add_job @job_type = N’capture’;
GO

USE AdventureWorks2012;
GO
EXEC sys.sp_cdc_add_job
@job_type = N’cleanup’
,@start_job = 0
,@retentio

Leave a Reply

Your email address will not be published. Required fields are marked *