Foglight upgrade to version 5.7.5.8 failed. The failure appeared in the database upgrade portion of the installation. There are errors in the log about failed to upgrade database schema.
The upgrade wizard failed with the following message:
Running the suggested command "fms.exe -Dfoglight.database.upgrade=true" does not help and does not provide more details - from the log file:
INFO Database Upgrade Service Starting...
INFO A database schema upgrade is required. Current version = 5.7.5.9. Expected version = 5.7.5.17.
ERROR Failed to generate the SQL statements to perform the schema update.
ERROR Upgrade step from 5.7.5.9 to 5.7.5.10 failed.
ERROR The database upgrade has failed.
FATAL Unexpected error during server startup, exiting
According to the DatabaseUpgrade_{timestamp}.log the database upgrade is failing due to an incompatible configuration in SQL Server:
ERROR [main] com.quest.nitro.upgrade.db.UpdateSchemaObjectsTask - Failed to generate the SQL statements to perform the schema update.
org.hibernate.exception.SQLGrammarException: could not get table metadata: sec_user
....
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Common language runtime (CLR) execution is not supported under lightweight pooling. Disable one of two options: "clr enabled" or "lightweight pooling".
Based upon Microsoft documentation, you can not have Common language runtime (CLR) and lightweight pooling options enabled simultaneously. Common language runtime execution is not supported under lightweight pooling.
Disable one of two options: "clr enabled" or "lightweight pooling".
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center