Post reply

Issue in Enabling CDC on a DB

  • April 12, 2011 at 8:30 am

    #238358

    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?

    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.

  • April 12, 2011 at 8:39 am

    #1310424

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1092126-1550-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 12, 2011 at 8:41 am

    #1310429

    Sorry, i thought i had posted in the wrong forum. hence reposted it.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply