Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

Home > Success Center > Netflow Traffic Analyzer (NTA) > Error while executing script - Difference of two datetime columns caused overflow at runtime

Error while executing script - Difference of two datetime columns caused overflow at runtime

Created by Norsolihati Selamat, last modified by Steven Bansil on Jul 11, 2016

Views: 1 Votes: 0 Revisions: 5

Overview

This article describes the issue when upgrading to NTA 3.9 fails with the following error on the Configuration Wizard:

Error while executing script - Difference of two datetime columns caused overflow at runtime.

Environment

  • NTA 3.9

Resolution

  1. Run the following SQL queries against the Orion database:
    DELETE cbQoSStats
    WHERE YEAR(EndDate) > 9000
     
    UPDATE STATISTICS dbo.cbQoSStats
  2. Re-run the Orion Configuration Wizard.
     

Not: MMake sure a good database backup has already been done before making direct changes to the database.

 

 

Last modified
00:30, 11 Jul 2016

Tags

Classifications

Public