Arithmetic overflow error when running dbo.UnusedAntibodyIdFinder or dbo.UnusedFileNameIdFinder or dbo.UnusedPathNameIdFinder

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

Error seen with stored procedures dbo.UnusedFileNameIdFinder or dbo.UnusedPathNameIdFinder or dbo.UnusedAntibodyIdFinder similar to:

Msg 8115, Level 16, State 2, Procedure dbo.UnusedAntibodyIdFinder, Line 99 [Batch Start Line 0]
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.

Msg 8115, Level 16, State 2, Procedure dbo.UnusedFilenameIdFinder, Line X [Batch Start Line 0]
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.

Msg 8115, Level 16, State 2, Procedure dbo.UnusedPathnameIdFinder, Line 99 [Batch Start Line 0]
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.

Environment

• App Control Server: 8.7.x - 8.10.4

Cause

Incorrect DECLARE statement

Resolution

1. Within SQL Navigate to Das > Programmability > Stored Procedures
2. Right click > Modify on dbo.UnusedAntibodyIdFinder:
   • On line 18 replace "@reuseAntibodyLastId INTEGER" with "@reuseAntibodyLastId BIGINT"
3. Right click > Modify on dbo.UnusedFileNameIdFinder:
   • On line 16 replace "@reuseFilenameLastId INTEGER" with "@reuseFilenameLastId BIGINT"
4. Right click > Modify on dbo.UnusedPathNameIdFinder:
   • On line 16 replace "@reusePathnameLastId INTEGER" with "@reusePathnameLastId BIGINT"

Additional Information

This change will also be addressed with server version 8.11+ via EPCB-20506