AD Import of Security Groups starts failing with an arithmetic overflow error.

Products

• Client Management Suite
• IT Management Suite

Issue/Introduction

After upgrading from ITMS 8.5 RU2 to 8.5 RU4, the customer started seeing the below errors during AD imports.

Error 1:

SQL Exception details: code=8115, line=11, procedure=sp_Inv_Security_Groups_clean
Exception logged from:
at Altiris.NS.ResourceManagement.DataClassImporter.LoadInventory(System.Xml.XmlReader,
Boolean, Boolean, System.Guid)
at
Altiris.NS.StandardItems.Messaging.InventoryCaptureItem.ImportDataClassNode(Altiris.NS.Re
sourceManagement.MessagingResource, System.Xml.XmlTextReader,
Altiris.NS.ResourceManagement.ResourceImporter,
Altiris.NS.ResourceManagement.DataClassImporter)
....

Date: 2/5/2021 2:51:15 PM, Tick Count: 257384921 (2.23:29:44.9210000), Size: 13.72 KB
Process: AeXSvc (32672), Thread ID: 198, Module: Altiris.NS.dll
Priority: 1, Source: Altiris.NS.ResourceManagement.DataClassImporter.LoadInventory

 

Error 2:
SQL Exception details: code=8115, line=11, procedure=sp_Inv_Security_Groups_clean
Exception logged from:
at Altiris.NS.ResourceManagement.DataClassImporter.LoadInventory(System.Xml.XmlReader,
Boolean, Boolean, System.Guid)
at
Altiris.NS.StandardItems.Messaging.InventoryCaptureItem.ImportDataClassNode(Altiris.NS.Re
sourceManagement.MessagingResource, System.Xml.XmlTextReader,
Altiris.NS.ResourceManagement.ResourceImporter,
Altiris.NS.ResourceManagement.DataClassImporter)

Date: 2/5/2021 2:51:15 PM, Tick Count: 257385437 (2.23:29:45.4370000), Size: 13.07 KB
Process: AeXSvc (32672), Thread ID: 91, Module: Altiris.NS.dll
Priority: 1, Source: Altiris.NS.ResourceManagement.DataClassImporter.LoadInventory

Error 3:
NSE dispatch failed for: id=60010126, from: Smith, John @ TeamA, to: 'Directory Connector Inventory
Capture Item' (51fed64d-7d2f-44c3-a7eb-a2442c7964db)
Failed to load inventory.
 [Altiris.NS.Exceptions.AeXException @ Altiris.NS]
 at Altiris.NS.ResourceManagement.DataClassImporter.LoadInventory(XmlReader reader, Boolean
processData, Boolean forceSchemaValidation, Guid resourceGuidOverride)
 at Altiris.NS.StandardItems.Messaging.InventoryCaptureItem.ImportDataClassNode(MessagingResource
fromResource, XmlTextReader xmlReader, ResourceImporter resourceImporter, DataClassImporter
inventoryImporter)
 at Altiris.NS.StandardItems.Messaging.InventoryCaptureItem.ImportDataClassData(MessagingResource
fromResource, XmlTextReader xmlReader, ResourceImporter resourceImporter)
 at Altiris.NS.StandardItems.Messaging.InventoryCaptureItem.OnMessageImpl(String message, Boolean
useFilename)
 at Altiris.NS.StandardItems.Messaging.InventoryCaptureItem.OnMessageInternal(String message, Boolean
useFilename)
 at Altiris.NS.ClientMessaging.EventQueueDispatcher.DispatchWithinContext(String message, Boolean
useFilename, IItem item, IItemMessaging iim, MessageHeader header)
 at Altiris.NS.ClientMessaging.EventQueueDispatcher.DispatchWithinContext(Int32 eventQueueId, String
message, Boolean useFilename, Int64 fileSize, Int64 eventId, MessageHeader header)
 at Altiris.NS.ClientMessaging.EventQueueDispatcher.TryDispatch(Int32 eventQueueId, String message,
Boolean useFilename, Int64 fileSize, Int64 eventId)
Arithmetic overflow error converting expression to data type int.
Arithmetic overflow error converting expression to data type int.
Arithmetic overflow error converting expression to data type int.
Arithmetic overflow error converting expression to data type int.
Arithmetic overflow error converting expression to data type int.
Arithmetic overflow error converting expression to data type int.
Arithmetic overflow error converting expression to data type int.
Arithmetic overflow error converting expression to data type int.
Arithmetic overflow error converting expression to data type int.

....

SQL Exception details: code=8115, line=11, procedure=sp_Inv_Security_Groups_clean
Exception logged from:
 at Altiris.NS.ClientMessaging.EventQueueDispatcher.TryDispatch(Int32, String, Boolean, Int64, Int64)
 at Altiris.NS.ClientMessaging.EventQueueDispatcher.PerformDispatch(Altiris.NS.ClientMessaging.EventQueueDispa
tcher+DispatchSlot, Boolean&) 
....

Date: 2/5/2021 2:51:15 PM, Tick Count: 257385437 (2.23:29:45.4370000), Size: 13.38 KB
Process: AeXSvc (32672), Thread ID: 91, Module: Altiris.NS.dll
Priority: 1, Source: Altiris.NS.ClientMessaging.EventQueueDispatcher.TryDispatch

 

Error 4:
SQL Exception details: code=8115, line=11, procedure=sp_Inv_Security_Groups_clean
Exception logged from:
 at
Altiris.NS.ClientMessaging.EventQueueDispatcher.HandleException(Altiris.NS.ClientMessaging.EventQueueDispa
tcher+DispatchSlot, Int32, Exception, String&, Boolean&, Int32&)
 at
Altiris.NS.ClientMessaging.EventQueueDispatcher.PerformDispatch(Altiris.NS.ClientMessaging.EventQueueDispa
tcher+DispatchSlot, Boolean&)
 at
Altiris.NS.ClientMessaging.EventQueueDispatcher.WorkerDispatchStep(Altiris.NS.ClientMessaging.EventQueueDi
spatcher+DispatchSlot, Altiris.Common.Threading.IAutoCallContextSnapshot)
 at
Altiris.NS.ClientMessaging.EventQueueDispatcher.PerformDispatchSlotLoop(Altiris.NS.ClientMessaging.EventQu
eueDispatcher+DispatchSlot, String&)
 at
Altiris.NS.ClientMessaging.EventQueueDispatcher.PerformDispatchSlotLoop(Altiris.NS.Logging.EventLog+IMeas
ureOperation, Altiris.NS.ClientMessaging.EventQueueDispatcher+DispatchSlot)
 at Altiris.NS.ClientMessaging.EventQueueDispatcher.DispatchSlotThreadProc(Object)
 at System.Threading.ThreadHelper.ThreadStart(Object)
User [US\us_svc_AeXNSApp06], Auth [US\us_svc_AeXNSApp06], AppDomain [AeXSVC.exe]
-----------------------------------------------------------------------------------------------------
Date: 2/5/2021 2:51:15 PM, Tick Count: 257385437 (2.23:29:45.4370000), Size: 13.47 KB
Process: AeXSvc (32672), Thread ID: 91, M

 

The count in the table is 4805737730.

Environment

ITMS 8.5 RU4

Cause

Known issue. We found that the stored procedure _ID field is a "bigint" in the Inv_Security_Groups table, but the stored procedure that references the table, sp_Inv_Security_Groups_clean, defines the _ID field as an "int". Changing the stored procedure to define it as a "bigint" solved the issue. 

Resolution

This issue has been fixed in our next ITMS 8.6 release.

Workaround:

Please use/execute the two attached modified SQL stored procedures.|

Make a copy of these original stored procedures before trying to update the modified ones:

spDataLoaderProcCreater
sp_Inv_Security_Groups_clean