Skip to main content
NetApp Knowledge Base

SC delete backup job fails with: Cannot delete a parent row: a foreign key constraint fails

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

Applies to

SnapCenter (SC)

Issue

  • When attempting to remove a stuck backup job with command Remove-SmJobs -JobId <JobId_Number>, no error message appears on screen; however the following error message is reported in the Job Monitor for the corresponding removal Job ID:
 
An error occurred while updating the entries. See the inner exception for details. InnerException Cannot delete or update a parent row: a foreign key constraint fails (`nsm`.`nsm_cobackupinfo`, CONSTRAINT `FK_nsm_CoBackupInfo_nsm_Backup1` FOREIGN KEY (`nsm_CoBackup_Id`) REFERENCES `nsm_Backup` (`nsm_Backup_Id`) ON DELETE NO ACTION ON UPDATE NO ACTION)
 
 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device