Skip to main content
NetApp Response to Russia-Ukraine Cyber Threat
In response to the recent rise in cyber threat due to the Russian-Ukraine crisis, NetApp is actively monitoring the global security intelligence and updating our cybersecurity measures. We follow U.S. Federal Government guidance and remain on high alert. Customers are encouraged to monitor the Cybersecurity and Infrastructure Security (CISA) website for new information as it develops and remain on high alert.
NetApp Knowledge Base

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

Views:
563
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 and later

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.

remove-policy.png

  • 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 ---

Scan to view the article on your device
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