April 12, 2011 at 8:33 am
Hi all,
When i try to enable CDC on one of the DBs, i am getting the error below. I had successfully enabled CDC on a DB named ZMDB a couple of days back. Now, when i try to enable it on ZCI, it is giving me this error. Can anyone please help me out on this?
Thanks a ton.
Msg 3930, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 178
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 186
Could not update the metadata that indicates database zci is enabled for Change Data Capture. The failure occurred when executing the command 'CREATE TABLE dbo.systranschemas'. The error returned was 916: 'The server principal "S-1-9-3-768927421-1125121078-4071390369-355688714." is not able to access the database "zmdb" under the current security context.'. Use the action and error to determine the cause of the failure and resubmit the request.
Msg 266, Level 16, State 2, Procedure sp_cdc_enable_db_internal, Line 0
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Msg 266, Level 16, State 2, Procedure sp_cdc_enable_db, Line 0
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Msg 3998, Level 16, State 1, Line 1
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
June 1, 2011 at 12:30 am
Please check if there are any database triggers & disable them. After CDC is enabled, the database triggers (if any) could be enabled.
January 8, 2015 at 10:05 pm
Thanks Mohan, that helped me out.
Regards,
D.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply