Solved

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

Posted on 2015-02-02
3
69 Views
Last Modified: 2015-03-15
Hello,

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
0
Comment
Question by:MohitPandit
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 500 total points
ID: 40593260
hi

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.
0
 
LVL 5

Author Comment

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

Best Regards
0
 
LVL 5

Author Closing Comment

by:MohitPandit
ID: 40667352
thanks
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

744 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now