"SQL Update" errors when running Network Discovery
Hi all,
am running a new (first) Scan Group in Network Discovery, and the process seems to kick off aok, but when i check Discovered Devices, there's no items found, and the NS log is full of errors like -
Log File Name: C:\Program Files\Altiris\Notification Server\Logs\a7.log
Priority: 1
Date: 25/01/2012 10:02:16 AM
Tick Count: 42885531
Host Name: Server
Process: aexsvc.exe (1404)
Thread ID: 5812
Module: AltirisNativeHelper.dll
Source: NetworkDiscovery
Description: SQL Update Failed.
Row Count = 0
SQL = System.Data.SqlClient.SqlCommand
Error =
Log File Name: C:\Program Files\Altiris\Notification Server\Logs\a7.log
Priority: 1
Date: 25/01/2012 10:02:16 AM
Tick Count: 42885609
Host Name: Server
Process: aexsvc.exe (1404)
Thread ID: 5812
Module: AltirisNativeHelper.dll
Source: NetworkDiscovery
Description: Error storing discovery statistics: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
Have found http://www.symantec.com/docs/TECH25602 but we're way past the recommeded fix rev. (currently 6.0.2120). The service account is set for a non-U.S. date format, anyone know if there's a config file somewhere i can check what format Network Discovery is trying to use?
regards,
Justin