DB upgrade failed

[raghuvaran_ram]

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.

Regards

Raghu

[mfranz]

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.

[raghuvaran_ram]

@mfranz 

Thanks for your reply,

Do you mind helping me in sharing the query to find the table?

[mfranz]

USE FNSMCompliance

SELECT *
FROM BeaconTarget_MT

As you're in the middle of a migration, I assume you have database backups 😉

[raghuvaran_ram]

@mfranz 

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.

[mfranz]

I would assume that the scripts target only default tagets. They seem to be marked with "1" in the Internal column.

USE FNSMCompliance

SELECT *
FROM BeaconTarget_MT
WHERE Internal = 1

 Maybe it's enough to remove these.

[raghuvaran_ram]

@mfranz 

Thanks once again. I will restore the DB once again and have it tested tomorrow and share the results.

[raghuvaran_ram · Accepted solution]

@mfranz 

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.

[ChrisG]

There was a change in the 2020 R2 release to address to the problem discussed in the following thread which was related to the specific record shown in your error message: Any changes on Inventory setting page is throwing error while trying to save. It may be that this change isn't working well in your particular migration scenario.

If you can't work out how to get past the problem then you may wish to raise a case with Flexera Support to dig further.