CDC Capture Job Failed with Error 217

All replies

• 

  

  0

  Sign in to vote

  Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
  

  Is there a user defined trigger on the table? This error comes when a trigger causing an other trigger to fire, which ends in an infinite loop; SQL Server raise then an error.

  https://www.mssqltips.com/sqlservertip/1713/maximum-stored-procedure-function-trigger-or-view-nesting-level-exceeded-limit-32/

  BTW, SQL Server related forums moved to Q&A: https://docs.microsoft.com/en-us/answers/products/sql-server
  

  ---

  Olaf Helper

  [ Blog] [ Xing] [ MVP]

  • Proposed as answer by Dave PatrickMVP Friday, October 2, 2020 12:21 PM
  • Marked as answer by Dave PatrickMVP Monday, October 5, 2020 1:35 AM

  Friday, October 2, 2020 10:56 AM
• 

  

  0

  Sign in to vote

  Hi, 

  Yes. There is another trigger function is enabled for the table. The trigger function to capture who updated the table.

  We enable CDC and Trigger function since the beginning around last year Oct, no issue at all until this year June has the replication issue due to the transaction log growth and cause the space issue. That time we disable the CDC and shrink the database. After that enable again, no issue until recently it has this error where we are not able to enable the CDC function. 

  Sunday, October 4, 2020 11:57 PM
• 

  

  1

  Sign in to vote

  I'd try asking for help in migrated QnA forums.

  https://docs.microsoft.com/en-us/answers/products/sql-server

   

   

  ---

  
  Regards, Dave Patrick ....
  Microsoft Certified Professional
  Microsoft MVP [Windows Server] Datacenter Management
  
  Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.
  

  • Proposed as answer by KHURRAM RAHIM Saturday, November 28, 2020 10:22 PM

  Monday, October 5, 2020 1:34 AM