Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > Netflow Traffic Analyzer (NTA) > The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.

The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.

Created by Daniel Phillipps, last modified by Aileen de Lara_ret on Jul 12, 2016

Views: 8 Votes: 0 Revisions: 3

Updated July 12, 2016

Overview

This article provides brief information on the following error when upgrading the NTA poller:

The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.

Environment

NTA version 4.x

 

Cause 

The Date field in the cbQoSStats is out of range and does not corelate to the other ranges.

Resolution

Run the following query:

DELETE cbQoSStats
WHERE YEAR(EndDate) > 9000
UPDATE STATISTICS dbo.cbQoSStats

 

 

 

Last modified

Tags

Classifications

Internal Use Only