CDC: CDC is working with one database for same server but not other database

Posted on 2015-02-02
Last Modified: 2015-03-15

I've one database server where CDC is enabled.
But I could not capture data in CDC tables in another database. In SQL agent job, it is giving below error:

"Change Data Capture has scanned the log from LSN{0006DC4E:000CE092:0001} to LSN{0006DC4E:000D61F0:0003}, 500 transactions with 14708 commands have been extracted. To report on the progress of the operation, query the sys.dm_cdc_log_scan_sessions dynamic management view."

Error # 22803

Could you please look into it?
Best Regards,
Mohit Pandit
Question by:MohitPandit
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 15

Accepted Solution

Aaron Shilo earned 500 total points
ID: 40593260

do you have CLOB , BLOB on that DB?
If a table that you are looking to enable CDC on has BLOB fields you will need to modify the "max text repl size" to it's maxiumum allowed value (2147483647) otherwise you will get truncation errors.  This is a replication setting but because CDC piggybacks on the functionality this is where you would need to make the change.

Author Comment

ID: 40598258
Okay, let me check on it & update you.

Best Regards

Author Closing Comment

ID: 40667352

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question