Solved

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

Posted on 2015-02-02
3
70 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

911 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

23 Experts available now in Live!

Get 1:1 Help Now