Some users may have issues creating a community account. For more information, please click here.

raghuvaran_ram
Active participant

DB upgrade failed

Jump to solution

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

 

 

1 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.

View solution in original post

8 Replies
mfranz
Trusted advisor

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.

Softline Group is Europe's leading independent expert in Software Asset Management.
0 Kudos

@mfranz 

 

Thanks for your reply,

 

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

0 Kudos
USE FNSMCompliance

SELECT *
FROM BeaconTarget_MT

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

Softline Group is Europe's leading independent expert in Software Asset Management.
0 Kudos

@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.

0 Kudos

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.

Softline Group is Europe's leading independent expert in Software Asset Management.

@mfranz 

 

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

0 Kudos

@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.

View solution in original post

ChrisG
Community Manager Community Manager
Community Manager

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.

(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
0 Kudos