Audit Events Not Tracked After Fresh Installation of NPrinting (February 2025 SR2 & February 2024 SR6)

[Jamie_Gregory]

Description of the Issue

We have identified a degradation in the event auditing functionality in NPrinting, tracked in QCB-32819. Specifically, audit events are not being tracked after a fresh installation of the following versions:

• February 2025 SR2
• February 2024 SR6

It is important to note that this issue only occurs with new installations of these versions. If the system is upgraded from a previous version, the problem does not manifest.

Effects Observed

• Audit events are not being tracked.
• The following API endpoints fail with the error:
  • api/v1/audit/logs
  • api/v1/audit/events

500 Internal Server Error : An unhandled exception occurred; check the log for more information.

• The log file located at %ProgramData%\NPrinting\Logs\nprinting_audit.log shows this error message:

Unable to start Audit service. ERROR: System.AggregateException: One or more errors occurred. ---> System.InvalidOperationException: Could not export the testing database. ---> Npgsql.PostgresException: 42501: permission denied for schema public

Workaround

In addition to performing an upgrade from a previous version instead of a fresh installation, the following steps can be taken to work around the issue:

1. Stop all NPrinting Server services except QlikNPrintingRepoService (otherwise PGAdmin will not find the connection to the DB).

2. Download and install PGAdmin, and connect to the NPrinting Server database.

3. Navigate to the nprinting_audit database and execute the following command:

GRANT ALL PRIVILEGES ON SCHEMA public TO nprinting_audit;

4. Run the following command as administrator:

net start QlikNPrintingAuditService /setup

5. Start all NPrinting server services.

This will allow the audit service to start correctly and resume tracking audit events.