A new Flexera Community experience is coming on November 18th, click here for more information.
Hi,
While upgrading 202 R1 from 2019 R2 , getting the below error.
Jul 12, 2020 04:12 AM
Jul 12, 2020 07:19 PM - edited Jul 15, 2020 03:41 PM
This likely means that someone has customized your FlexNet Manager Compliance database. The error indicates that there is a database table that should have 0 rows, but 5 rows are found.
If you manually run the "schemacheck.sql" script with SQL Server Management Studio, you may be able to narrow down the data condition causing the error.
Jul 13, 2020 06:11 AM
Hi,
It sounds like there could be objects in the database that are not the default schema (dbo).
Best regards,
Markward
Jul 22, 2020 06:54 AM
@kclausen
Thanks for the recommendation, to run the check script manually . I got this in the log file:
-------------------------------------------------------------------------------------------------------------------------
Running 'ComplianceSchema_schemacheck.sql'.
Returned row: MigrationErrors:
There was an error while attempting to run 'ComplianceSchema_schemacheck.sql'.
Returned row count 1 does not equal expected row count 0
Stack Trace
at ManageSoft.Database.Update.FileStep.ExecuteReader(SqlConnection p_SqlConnection)
-------------------------------------------------------------------------------------------------------------------------
You see the error message was empty --> Returned row: MigrationErrors:
The reason was the result of one query was NULL. So, the check script was very helpful.
FNMSInventory -> Running 'schemacheck.sql'
FNMSCompliance -> Running 'ComplianceSchema_schemacheck.sql'
FNMSDataWarehouse -> Running 'DataWarehouseSchema_schemacheck.sql'
Kind regards
Oct 15, 2020 09:06 AM - edited Oct 15, 2020 09:14 AM
User | Count |
---|---|
8 | |
7 | |
3 | |
3 |