Skip to main content

NetApp_Insight_2020.png 

NetApp Knowledgebase

NDB fails to delete policy due to "An error occurred while updating the entries. See the inner exception for details."

Views:
197
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

  • NetApp Data Broker (NDB) 1.0.x
  • SnapCenter Plug-in for VMware vSphere (SCV) 4.3.x

Issue

  • NDB/SCV is unable to delete policy due to the following error.

Unable to delete policy with name <Policy Name> from SnapCenter Server : An error occurred while updating the entries. See the inner exception for details.

  • ProtectionService-<YYYYMMDD>.log shows the following error.

[ERR] [ServiceName:Policy] [RequestId:XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX] [CorrId:] [JobId:] 
  Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. 
  ---> MySql.Data.MySqlClient.MySqlException: Cannot delete or update a parent row: a foreign key constraint fails (`nsm`.`nsm_ProtectionNode`, CONSTRAINT `FK_nsm_ProtectionNode_nsm_Policy` FOREIGN KEY (`nsm_PolicyId`) REFERENCES `nsm_Policy` (`nsm_Policy_Id`)) 
  ---> MySql.Data.MySqlClient.MySqlException: Cannot delete or update a parent row: a foreign key constraint fails (`nsm`.`nsm_ProtectionNode`, CONSTRAINT `FK_nsm_ProtectionNode_nsm_Policy` FOREIGN KEY (`nsm_PolicyId`) REFERENCES `nsm_Policy` (`nsm_Policy_Id`))
   at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in C:\projects\mysqlconnector\src\MySqlConnector\Core\ResultSet.cs:line 42
   --- End of inner exception stack trace ---

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support