Error: "Unspecified Dataloader SQL Exception encountered for inventory data class: 'AeX AC Identification'"

Products

• Client Management Suite

Issue/Introduction

Without any known changes or issues occuring the following entries showed up in large quantities in the Notification Server logs:

Severity: 1
Date: 2/21/2024 1:27:44 PM
Tick Count: 1940554093
Host Name: [NSserver]
Process: AeXSvc (4360)
Thread: 215
Module: Altiris.NS.dll
Source: DataLoader
Description: Unspecified Dataloader SQL Exception encountered for inventory data class: 'AeX AC Identification' (c74002b6-c7b9-47bb-a5d6-3031af73bb8d)
DeleteResourceProcSql not set!

We also noticed lots of the following entries in the logs and when checking the EvtQueue folder NSEs were processing fine and there were never more than 5 or 6 NSEs present in the folder at any given time.  The error "DeleteResourceProcSql not set!" was common between these:

Severity: 1
Date: 2/21/2024 12:46:40 PM
Tick Count: 1938089984
Host Name: [NSserver]
Process: AeXSvc (4360)
Thread: 215
Module: Altiris.NS.dll
Source: EventQueueDispatcher
Description: [3/3] Failed to process event: # 1441229793, 56.49 KB, C:\ProgramData\Symantec\SMP\EventQueue\EvtQueue\870345a819ca4b0e912cef9c8ec961d1.nse
DeleteResourceProcSql not set!

Severity: 2
Date: 2/21/2024 12:46:39 PM
Tick Count: 1938089375
Host Name: [NSserver]
Process: AeXSvc (4360)
Thread: 367
Module: Altiris.NS.dll
Source: EventQueueDispatcher
Description: [1/3] Failed to process event, will retry: # 1441229811, 57.15 KB, C:\ProgramData\Symantec\SMP\EventQueue\EvtQueue\7119fa12ec834ecba3b1d8258468a5d1.nse
DeleteResourceProcSql not set!

Environment

ITMS 8.x

Cause

A thorough check was done of the Notification Server configuration and everything seemed to be functioning fine.

Resolution

The Notification Server hadn't been restarted for over 3 weeks so both the Notification Server and the SQL Server were rebooted and all the issues went away.