IBM Support

Arithmetic overflow error converting expression to data type bigint" error from data collector.

Question & Answer


Question

Arithmetic overflow error converting expression to data type bigint" error from data collector.

Answer

Contents
Problem
"Arithmetic overflow error converting expression to data type bigint" error from data collector.
An error has occurred: "Error aggregating canister statistics for server: 1 - Error occurred while aggregating PATH_STAT: Error occurred while executing the non-query command: Arithmetic overflow error converting expression to data type bigint".? The key message is: "Arithmetic overflow error converting expression to data type bigint".

The statement has been terminated. - SQL: pr_AggregateRS_PATH

Solution

In some cases the data collected by the data collection process results in numbers too large to match the maximum calculation allowed by SQL Server.? In this case the referenced data requires purging from the SQL Server database. With the calculations no longer requiring completion things should resume with normal functionality.? This is usually caused by a time problem between your Canister or Capture Servers.? The system times on both require synchronization.
Article Reference
00001281
Applies to version(s):? 8.0;8.1;8.2;8.3;8.4
"
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSERNK","label":"Tealeaf Customer Experience"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

More support for:
Tealeaf Customer Experience

Software version:
All Versions

Document number:
778141

Modified date:
08 December 2018

UID

ibm10778141

Manage My Notification Subscriptions

Page Feedback