March 10, 2014 at 8:28 am
Hi Friends,
Msg 22832, Level 16, State 1, Procedure sp_cdc_enable_table_internal, Line 623
Could not update the metadata that indicates table [dbo].[tablename] is enabled for Change Data Capture. The failure occurred when executing the command '[sys].[sp_cdc_add_job] @job_type = N'capture''. The error returned was 22836: 'Could not update the metadata for database NorthShoreMidHydrant to indicate that a Change Data Capture job has been added. The failure occurred when executing the command 'sp_add_jobstep_internal'. The error returned was 14234: 'The specified '@server' is invalid (valid values are returned by sp_helpserver).'. Use the action and error to determine the cause of the failure and resubmit the request.'. Use the action and error to determine the cause of the failure and resubmit the request.
I am getting this above mentioned error while trying to enable CDC option in a table. Friends, could you please help me resolve this issue?
Any suggestions would be really appreciated.
March 10, 2014 at 8:29 am
How did you try to enable CDC?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2014 at 10:00 am
Hi Koen,
This is the script I used.
EXECUTE sys.sp_cdc_enable_db
go
EXECUTE sys.sp_cdc_enable_table
@source_schema = N'dbo',
@source_name = 'tablename',
@role_name = NULL
March 10, 2014 at 1:47 pm
You did not by any chance rename the server after enabling CDC? (quite a long shot)
Another possible cause could be a .NET update:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2014 at 3:41 am
No Koen, I did not rename anything.
Thanks,
Charmer
March 11, 2014 at 3:46 am
Koen, suggest me what should I do ? I did not rename the server. Assume that i had renamed the server, what would I do for that? explain me those ways, and i will try that at least to make sure that it's not an renamed server problem. Because updating the .net is not going to happen very soon.
Thanks,
Charmer
March 11, 2014 at 4:17 am
Charmer (3/11/2014)
Koen, suggest me what should I do ? I did not rename the server. Assume that i had renamed the server, what would I do for that? explain me those ways, and i will try that at least to make sure that it's not an renamed server problem. Because updating the .net is not going to happen very soon.
I see your Google skills are still intact...
Google for "Msg 22832, Level 16, State 1, Procedure sp_cdc_enable_table_internal, Line 623".
There are a lot of possible causes for this error, and you might want to try all suggested solutions until you find one that works for you.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2014 at 4:31 am
Ok Koen, Thank you for sharing this.
Thanks,
Charmer
March 13, 2014 at 12:25 am
did you check if the credentials have access to create a job in that server
cdc normally creates multiple job and some system table
did you check if anything has been created
It says @server variable wasnt having correct value
it can be a typo 😛 als
------------------------------------------------------------------------------------
Ashish
March 13, 2014 at 2:39 am
When your server is rebooted lastly?
Please ensure server should be rebooted after any .net updates or hotfixes.
Regards,
Kumar
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply