...
Update application to .NET 6
Breaking changes
...
Install steps
Open CXO Server Configuration - Maintenance
Stop CXO OneStream IIS application pool
Stop OneStream Adapter Processing Service
Open Add or Remove Programs
Uninstall .Net Core 2.0 hosting bundle
Important: Do this beforeinstalling the .NET 6 hosting bundle
Download the .NET 6 hosting bundle installed and install it on the server
Disable encryption for Execute the CXO.Adapter.OneStream.msi installer
For test servers that store connection string with plain-text username and passwords (e.g. on demo environments):
All connection strings need to have encryption manually disabled now
Note: This was set to false by default in previous versions so it is the situation before the upgrade. It is now set to true by default https://learn.microsoft.com/en-gb/sql/connect/ado-net/introduction-microsoft-data-sqlclient-namespace?view=sql-server-ver15#breaking-changes-in-40
Add the following at the end of the connection string: ;Encrypt=False
Connection strings can be found in the following files
<Path to Adapter>\Web API\appsettings.json
<Path to Adapter>\Processing Service\appsettings.json
In the database the changes need to be done in the following tables
In dbo.application_variables table, av_value for av_name = ‘OneStream Adapter: Configuration Connection String’
In dbo.applications for all entries in connection_string column
After install (optional)
.NET Core 2.0 hosting bundle can be uninstalled from the serverStart the services again in CXO Server Configuration
Verify install
Open IIS and click browse to the Onestream website
Browser should show 404 but not a 500 error
If log level is set to information in appsettings.json then the logs will show “Checking if there are any pending database migrations“ (can be temporarily set to information to check this)
Open Windows Services
Check that CXO-Cockpit OneStream Adapter Processing Service is running
Logs can also be set to info to see a message saying “Checking for pending tasks started” every minute