T03-2026 BIOVIA Notebook: Username not recorded in user audit trail on SQL Server database

Program

BIOVIA Notebook 2026, only when SQL server database is used

Operating System

All supported operating systems

Background

An issue has been found when SQL server database is used, where the username of the current user is not recorded in the user audit trail. This leads to audit trail records for experiment changes that are missing the information on what user that made the change.

When viewing the Experiment audit trail for an open experiment, or when viewing User audit trail in Administration, the User column incorrectly displays “- (imported)” instead of the full name of the user.

The reason is a new bug in a database procedure for retrieving the current Notebook user name.

This issue does not apply to Notebook installations using Oracle database.

Solution

We are currently working on a hotfix to address this issue. Alternatively, the workaround below fixes the problem.

Workaround

Attached to this document are two SQL scripts that fix the two affected stored procedures in the SQL Server database. The changes may be applied while Notebook is running.

Install them as follows:

1. Connect to the Notebook SQL Server database using SQL Server Management Studio, as a user that has administration privileges on the Notebook database.
2. Take a backup of the Notebook database.
3. Open the attached file InsertAccesslog.sql in a query window.
4. Make sure the connected database is the Notebook database (typically “ELN”).
   1. In case the schema name of the Notebook database is different from the default “ELN”, then replace all occurrences of [eln] with the actual schema name.
5. Execute the script.
6. Repeat steps 3-6 with the file 2-CurrentAuthenticatedUser.sql.
7. Check that no errors occurred while executing the two scripts.

Steps to verify:

8. Log in to Notebook web client as a regular user, create a new experiment or open an unsubmitted experiment from “Me as author.” Then, make a change to for example a section title.
9. Go to cog wheel and select “Audit trail” from the dropdown menu. The records created after the fix was applied will show the correct user full name in the User column.

IMPORTANT

The solution steps resolve the problem for audit trail records created after applying this fix. Existing user audit trail records, created with Notebook 2026, will remain incorrect and cannot be repaired.

Existing user audit trail records, created with any earlier Notebook version, are not affected.

The Security audit trail is not affected by this problem.

Jira Change Request :  CELN-15103

How to contact BIOVIA Support

If you have any questions, please contact BIOVIA Support.