OneStream Adapter & Business Rules Change log

This page contains a change log of CXO’s OneStream Adapter and Business Rules as a curated, chronologically ordered list of notable changes for each version. The format is based on Keep a Changelog.

Please note, while following numbering syntax, the release versioning does not adhere to Semantic Versioning rules.

OneStream Adapter 24.3.0

Date: 25-03-2024

Security

Improved long term security by updating to .net 8 and updating the intaller

OneStream Adapter 23.4.0

Date: 25-03-2024

Fixed

Incremental metadata load issue when two or more leaf members with different parents are added in the same dimension.

OneStream Adapter 23.3.1

Date: 29-11-2023

Added

Increased OS adapter max request size

OneStream Adapter 23.3.0

Date: 13-10-2023

Fixed

Standalone metadata refresh removing existing loaded data

OneStream Adapter 23.2.23195.02

Date: 18-07-2023

Added

Standalone metadata refresh for update members and Scheduled Extractions

OneStream Adapter 23.2.23186.1

Date: 05-07-2023

Added

Standalone metadata refresh for add and delete members

OneStream Adapter 22.4.23003.1

Date: 17-01-2023

Security

• Update application to .NET 6

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 before installing the .NET 6 hosting bundle

• Download the .NET 6 hosting bundle and install it on the server

  • Download .NET 6.0 (Linux, macOS, and Windows)

• Execute the CXO.Adapter.OneStream.msi installer

• For test servers that do not have an SSL certificate set up to communicate with the database

  • 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

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

Note: Using versions priore of http://ASP.NET Core Runtime 6.0,  can cause problems with the processing service.