Coming soon...New Support-Specific categorization of Knowledge Articles in the NetApp Knowledge Base site to improve navigation, searchability and your self-service journey.

Home
Advice and Troubleshooting
Data Protection and Security
SnapCenter
SC delete backup job fails with: Cannot delete a parent row: a foreign key constraint fails

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

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Views:: 119

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)