An error has occurred while retrieving information; you may need to refresh the page. Error ID: 1af6fad8-934b-41da-8b3b-af22834dbc12

[tallal85]

Hi,

We have migrated our environment to the new version 2022 R2, and we have a on the website.

The  installation of the application has passed successfully. (the PS script passed successfully too).

Attached the error.

Regards,

[dbeckner]

Have you reviewed the WebUI log on the web server? It will have more information on the specific error you are encountering.

It will be located in C:\ProgramData\Flexera Software\Compliance\Logging\WebUI

Thanks,

Dan

[tallal85]

Hi,

The log has not been updated for 6 hours, it's weird. here is the last error in the log :

[ERROR 2023-03-23 14:33:46,972 12844ms UnhandledErrors       ] An unexpected error occurred (47a16ae6-c186-4dff-a118-6d116dee8995)
System.Data.SqlClient.SqlException (0x80131904): Cannot find either column "dbo" or the user-defined function or aggregate "dbo.SimpleValueDecode", or the name is ambiguous.
Could not use view or function 'dbo.Grid_EntitlementTransactionUnprocessed' because of binding errors.

[ChrisG]

The "dbo.SimpleValueDecode" function referenced in the error message here is a SQL CLR function (defined in a .NET DLL). The error message possibly implies that something has gone wrong or not been executed in the database configuration steps of the upgrade, or maybe that the CLR configuration of SQL Server is not working.

You might try running the 2022 R2 database setup scripts again, and check other log files for any messages that look like they may be related to problems in the database.