We are encountering an error while upgrading the database from 2020 R1 to 2020 R2.
Error message : there was an error while attempting to run cm-migr1600-migpost.sql
However, we have successfully upgraded the Inventory and warehouse database and facing issue while upgrading compliance DB.
I have raised a case and the solution provided was very similar to what you suggested, I was asked to delete only that specific entry that was causing the error, so post that I was able to complete the upgrade successfully.
exec BeaconTargetRemoveByNameInternal 'Known virtual cluster servers', 1
DELETE FROM BeaconTarget_MT WHERE [Name] = 'Known virtual cluster servers'
Thanks to everyone who replied to this query.
Looks like the migrations steps would like to insert existing values into the BeaconTarget_MT table. If you remove all entries from this table, the migration script should insert everything with new IDs.
USE FNSMCompliance SELECT * FROM BeaconTarget_MT
As you're in the middle of a migration, I assume you have database backups 😉
Yes. I'm testing this upgrade in the backup DB. I have deleted the entries in the entire table and retriggered the upgrade and it got completed successfully, but it did not bring back all the items. Attached the screenshot for your reference.
I have lost all the custom targets used for rules, I have attached the before and after screenshot for your reference, is there any other option as I need to have all those targets when I do the same activity in production.