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

book

Article ID: 208513

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

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, Danny @ Operations, 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.

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. 

Environment

ITMS 8.5 RU4

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 the original ones before trying the modified ones:
spDataLoaderProcCreater
sp_Inv_Security_Groups_clean

Attachments

1613165627389__fixed_spDataLoaderProcCreater.sql get_app
1613165619105__fixed_sp_Inv_Security_Groups_clean.sql get_app