CDC get all changes function error issue

• inayatkhan

  SSC Eights!

  Points: 844

  More actions

  November 13, 2014 at 6:12 am

  #298353

  I have setup CDC on 50 tables and then in one SP I’m calling all cdc function like below issue is I'm getting error “an insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes ... .” as error is not mentioning for which capture instance I'm getting this error so not able to find.

  select * from cdc.fn_cdc_get_all_changes_<capture_instance>(@from_lsn, @to_lsn, 'all update old') union all

  select * from cdc.fn_cdc_get_all_changes_<capture_instance>(@from_lsn, @to_lsn, 'all update old') union all

  select * from cdc.fn_cdc_get_all_changes_<capture_instance>(@from_lsn, @to_lsn, 'all update old') union all

  select * from cdc.fn_cdc_get_all_changes_<capture_instance>(@from_lsn, @to_lsn, 'all update old') union all

  select * from cdc.fn_cdc_get_all_changes_<capture_instance>(@from_lsn, @to_lsn, 'all update old') union all

  select * from cdc.fn_cdc_get_all_changes_<capture_instance>(@from_lsn, @to_lsn, 'all update old') union all

  select * from cdc.fn_cdc_get_all_changes_<capture_instance>(@from_lsn, @to_lsn, 'all update old')

  Is anyone know how to find which capture instance is failing?

  Thanks

• Lowell

  SSC Guru

  Points: 323518

  More actions

  November 13, 2014 at 8:33 am

  #1758259

  according to this msdn, it seems like the range you are choosing for your LSN start and end are invalid, and it raises that exact error:

  could it be that your code is supplying invalid parameters? maybe a null or something?

  http://msdn.microsoft.com/en-us/library/bb510627.aspx

  Remarks

  If the specified LSN range does not fall within the change tracking timeline for the capture instance, the function returns error 208 ("An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes.").

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• inayatkhan

  SSC Eights!

  Points: 844

  More actions

  November 13, 2014 at 10:07 am

  #1758323

  like I'm validating before calling these function so for that reason I don't think so its invalid or null.

  Thanks