cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Summary

This article gives information about the DB migration script.

Synopsis

When performing DB upgrade from older to newer version of FNMS it fails with an error message "Migration cannot continue until all objects are owned by dbo. Please refer to article KB100977 in the knowledge base center of flexera. See attach screenshot.
.

Discussion

User-added image

Additional Information

To resolve this issue run the following script :

ALTER AUTHORIZATION ON CreateRefsNoCheck to dbo
ALTER AUTHORIZATION ON TableGetFromCommaSeparatedString to dbo
ALTER AUTHORIZATION ON ReportApplicationsAcrossVersions to dbo
ALTER AUTHORIZATION ON ReportSavingsThroughProductRightsDW to dbo
ALTER AUTHORIZATION ON ReportComplianceTrend to dbo
ALTER AUTHORIZATION ON ReportIBMPVULicenseConsumption to dbo
ALTER AUTHORIZATION ON SharedTableLegacyMap to dbo
Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Apr 07, 2018 12:59 PM
Updated by: