Solved

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

Posted on 2015-02-02
3
81 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
[X]
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
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

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

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

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

738 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