Yesterday I upgraded HCL SafeLinx to the latest version 1.4.5 and during the restart I could see the following error message in the wg.log:


20667:3158308416 (May 27 2026/08:59:55.8228)[ERROR] DBManager::get_sql_error — database error report —
SQL ERROR -1 (FATAL ERROR) occurred for ALTER TABLE ACTIVESESSIONATTRIBUTE ADD (BEARERTOKEN TEXT, REFRESHTOKEN TEXT, BEARERTOKENEXP BIGINT).
SQLSTATE: HY000
Native Error Code: 1142
[MySQL][ODBC 8.0(w) Driver][mysqld-8.0.43]ALTER command denied to user ‘WGDB’@’localhost’ for table ‘ACTIVESESSIONATTRIBUTE’
— end error report —

20667:3158308416 (May 27 2026/08:59:55.8228)[LOG] Trap: ‘accounting minor error’ (safelinx.dr-sauer.com/ )
20667:3158308416 (May 27 2026/08:59:55.8228)[ERROR] DBManager: SQL call ALTER TABLE failed for object ACTIVESESSIONATTRIBUTE (Generic error — -1)
20667:3158308416 (May 27 2026/08:59:55.8229)[LOG] DBManager::ModifyTableColumns – WGDATA ACTIVESESSIONATTRIBUTE: (return), rc=-1
20667:3158308416 (May 27 2026/08:59:55.8229)[LOG] DBManager::CloseTables – WGDATA: (entry)
20667:3158308416 (May 27 2026/08:59:55.8229)[LOG] DBManager::CloseTables – WGDATA: (return), rc=0
20667:3158308416 (May 27 2026/08:59:55.8230)[ERROR] ODBC_ActiveSessionManager::DefineTables – table_schema_updates failure for table ACTIVESESSIONATTRIBUTE!
20667:3158308416 (May 27 2026/08:59:55.8230)[ERROR] ODBC_ActiveSessionDB: DBManager DefineTables failed
20667:3158308416 (May 27 2026/08:59:55.8230)[LOG] ODBC_ActiveSessionDB::open: (return), rc=-1
20667:3158308416 (May 27 2026/08:59:55.8230)[ERROR] ODBC_ActiveSessionDB: failed to open database (WGDATA)


After opening a case HCL support delivered a script ( wgdata-bearer.sql ) which solved the issue.

I completed the following steps:

> ran the script ( mysql -u <admin-user of MySQL> -p < wgdata-bearer.sql )
> upgraded HCL SafeLinx to 1.4.5 ( install –force )

And now no more errors have been reported in the wg.log.

There will be an official KB entry and the content of the DDL script will be included in the next release. The script is running the following commands:

********************

USE WGDATA;

— adds BEARERTOKEN, REFRESHTOKEN and BEARERTOKENEXP columns to ACTIVESESSIONATTRIBUTE —

ALTER TABLE ACTIVESESSIONATTRIBUTE ADD (BEARERTOKEN TEXT, REFRESHTOKEN TEXT, BEARERTOKENEXP BIGINT);

********************