ProcessEventRules - Arithmetic overflow error converting expression to data type int.

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

To collect logs for the error:

DatabaseConnectionWrapper - Database task SQL exception: ProcessEventRules - Arithmetic overflow error converting expression to data type int.

Environment

• App Control Server: All Supported Versions
• Microsoft SQL Server: All Supported Versions

Cause

Unknown at this time

Resolution

1. Start high debug server logging
2. Manually execute the task:
   1. Log into SQL Management Studio as the Service Account
   2. Navigate to Query > Results To > Grid
   3. Run the query:

      select task_id,task from das.dbo.scheduled_tasks with(nolock) where task = 'ProcessEventRules'

   4. Note the "Task_id" from the query result
   5. Run the query:

      exec das.dbo.ProcessEventRules @task_id = X
      --Replace X with result from step C

   6. Right click in the "results" pane > Save Results As
3. Stop / Capture the high debug server logs
4. Provide the server logs and query result to Support.

Additional Information

This error is seen in the parityreporter.log file when high debug logging is enabled.