2014-08-20 09:33 AM
On WFA 2.2 server, I have started getting this error on acquisition of my OCUM 5.2 server.
Cannot delete or update a parent row: a foreign key constraint fails (`storage`.`nfs_export`, CONSTRAINT `fk_storage_nfs_export_qtree_id` FOREIGN KEY (`qtree_id`) REFERENCES `qtree` (`id`) ON DELETE SET NULL)
Troubleshooting so far:
I reinstalled the wfa database user on OCUM server
I did a dfm purge on events
I did an backup and restore of the dfm database
None of these things seem to work. Any ideas or suggestions on what to do next?
2014-08-20 09:46 PM
Can you pls open a case with NetApp Support ? BTW is this is OCUM 5.2 7Mode right ?
ESP against the bug 835921 ?
You are facing this issue due to a stale or duplicate entry in your OCUM database.
2014-08-20 10:27 PM
As adai has mentioned, it is because of a duplicate entry in DFM DB.
If you can raise a case and upload the WFA ASUP and DFM DB backup, i will help you out.