After upgrading to Strategy December 2024, Strategy Administrators may encounter that the upgraded Intelligence Server cannot connect to the Metadata anymore. When reviewing the DSSErrors.log file, the following error message appears:
"Connect failed. Disconnected.
Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [HY000:-1: on SQLHANDLE] [Strategy][ODBC Oracle Wire Protocol driver][Oracle]ORA-12650: No common encryption or data integrity algorithm"
The Metadata database platform and version of the above error is Oracle 19c, and this error is also returned when performing a connection test with Strategy tools such as DB Query Tool and ODBC Test Tool or with any database client software.
This error message is a showstopper to continue with the upgrade tasks such as the Metadata Update, causing a big disruption.
The experienced behavior is expected. The error message is returned by the Oracle driver version shipped Out of the Box with Strategy ONE December 2024 because this driver version no longer supports certain encryption and integrity algorithms. This change was implemented by the driver vendor and it is due to the change to OpenSSL 3.0.
The data integrity types should be changed on the database side to SHA2 to improve data security. Once the change is in place, the connection to the database can be established without issues.
