Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

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_ret on Jul 11, 2016

Views: 8 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