Notification for Identified challenges with VIP AuthHub 3.4 upgrade

Products

• VIP Authentication Hub

Issue/Introduction

VIP AuthHub product team has identified a potential schema issue that may impact your upgrade to VIP AuthHub version 3.4. This issue is most likely to affect you if you have been upgrading your systems from 2.x versions.

To determine if your system is affected, we recommend checking your tables for incorrect character encoding . You can use the following query to identify any tables that may cause an error during the upgrade process:

Run the following SQL command and substitute the actual DB scheme name

SELECT TABLE_SCHEMA  , TABLE_NAME  , COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLLATION_NAME ='utf8mb4_0900_ai_ci' and TABLE_SCHEMA='*** REPLACE WITH SCHEMA NAME ***';
If the results contain a table name other than flyway_schema_history’, please let us know what it is. See examples below and likely table identified -  IA_ENTP_RISK_RULE

Results without issue

mysql> SELECT TABLE_SCHEMA  , TABLE_NAME  , COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLLATION_NAME ='utf8mb4_0900_ai_ci' and TABLE_SCHEMA='iamauth';
+--------------+-----------------------+--------------------+
| TABLE_SCHEMA | TABLE_NAME            | COLLATION_NAME     |
+--------------+-----------------------+--------------------+
| iamauth      | flyway_schema_history | utf8mb4_0900_ai_ci |
| iamauth      | flyway_schema_history | utf8mb4_0900_ai_ci |
| iamauth      | flyway_schema_history | utf8mb4_0900_ai_ci |
| iamauth      | flyway_schema_history | utf8mb4_0900_ai_ci |
| iamauth      | flyway_schema_history | utf8mb4_0900_ai_ci |
+--------------+-----------------------+--------------------+
5 rows in set (0.00 sec)

Results with issue

 TABLE_SCHEMA | TABLE_NAME            | COLLATION_NAME     |
+--------------+-----------------------+--------------------+
| iamauth      | IA_ENTP_RISK_RULE     | utf8mb4_0900_ai_ci |
| iamauth      | IA_ENTP_RISK_RULE     | utf8mb4_0900_ai_ci |
| iamauth      | flyway_schema_history | utf8mb4_0900_ai_ci |
| iamauth      | flyway_schema_history | utf8mb4_0900_ai_ci |
| iamauth      | flyway_schema_history | utf8mb4_0900_ai_ci |
| iamauth      | flyway_schema_history | utf8mb4_0900_ai_ci |
| iamauth      | flyway_schema_history | utf8mb4_0900_ai_ci |
+--------------+-----------------------+--------------------+

Environment

VIP Authentication (Auth) Hub

Release: 3.4

Resolution

If upgrade is urgent for you and you identify any tables with incorrect character encoding, please reach out via a support case to VIP Authentication Hub product support team so that we can provide quick guidance on how to correct the schema.  We will address this issue in the upcoming 3.4.1 patch which will be release soon.