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