An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_

Question

Seemingly valid code for querying the latest tracked changes in the table Fields:

DECLARE @Begin_LSN BINARY(10), @End_LSN BINARY(10)
SET @Begin_LSN = sys.fn_cdc_get_min_lsn('Fields')
SET @End_LSN = sys.fn_cdc_get_max_lsn()
SELECT * FROM cdc.fn_cdc_get_all_changes_ordering_Fields (@Begin_LSN, @End_LSN, N'all')
GO

generates the following error message:

Msg 313, Level 16, State 3, Line 5
An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_ ... .

However, if I check for actual values they all seem to be valid (not null), the query

SELECT @Begin_LSN, @End_LSN, N'all';

returns

0x00000000000000000000  0x00002594000002130001  all

score 44 · Accepted Answer · edited May 23 '17 at 10:34

44

This error message is somewhat misleading and basically hints that some parameters might be out of bound. The message is not further customized because of the limitation of table functions.

The zero value (0x00000000000000000000) is not a valid one. The sys.fn_cdc_get_min_lsn() returns this value if it cannot find the appropriate capture instance name. This name might deviate from the actual table name. See this question for more details

See the following question for more details.

edited May 23 '17 at 10:34

Community

1
1

answered Apr 30 '13 at 12:02

Alexander Galkin

12,086
12
63
115

3

This can also happen , when the supplied @Begin_Lsn value is not present in the change table – Sujith Jun 15 '17 at 04:49
2

In my case the lsns are valid. still get this error – Beingnin Feb 20 '19 at 11:54
1

`select * from [cdc].[fn_cdc_get_net_changes_CM_Attachments](null,null,'all')` without lsn also fires the same error – Beingnin Feb 20 '19 at 12:17

score 3 · Answer 2 · answered Nov 21 '18 at 06:50

3

In my case this error was because of multiple time Enable/Disable CDC at table level and created two capture instance for same table. I fixed this by disabling CDC at database level and enabled again, then it works fine.

answered Nov 21 '18 at 06:50

Tej kumar

41
1

if its a test/dev database, drop and restore the db again fresh and run the scripts.. error resolved in my case... – HydPhani Aug 02 '22 at 13:48

score 1 · Answer 3 · answered Nov 26 '19 at 14:28

The above answers are correct, but I figured I would add what it was in my case. I was saving the last processed LSN for future runs. But this was a dev database and it was restored from prod. The CDC scripts were re-applied, but I had lost my history. What I needed to do was just remove that last processed LSN so it would go back to getting the minimum LSN for the capture instance and that put me back on the right track. Unfortunately this is not an extremely useful error message.

score -4 · Answer 4 · edited Oct 13 '14 at 09:10

I had a similar problem to yours. My problem is easier than yours but I want to write here for the case of someone receiving an error code like it.

When I called a function which has parameters, I forgot to enter those parameter. In a windowsform dataset I must use something like Select * from func_for_something(@id, @name). But if I write on dataset with Select * from func_for_something() without parameters, in visual studio I had no attemption . However when I triggered this function somewhere in the program I see an error message like yours.

So in conclusion: don't forget to add parameters when you use a function which has parameters. :) Sorry for my insufficent English

An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_

4 Answers4

Linked