NS log error "The string was not recognized as a valid DateTime"
search cancel

NS log error "The string was not recognized as a valid DateTime"

book

Article ID: 177331

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

The following error appears in the a.log files on a number of Notification servers:

Oct 16 23:14:05 E Failed to load inventory. [The string was not recognized as a valid DateTime. There is a unknown word starting at index 1.] Altiris.NS.ResourceManagement.DataClassImporter.LoadInventory_Impl

Oct 16 23:14:05 E Unspecified Dataloader Exception encountered for inventory data class 13e79855-4226-4524-8d0a-84500cdbe6a7! ( Unhandled exception. Type=System.FormatException Msg=The string was not recognized as a valid DateTime. There is a unknown word starting at index 1. Src=mscorlib StackTrace= at System.DateTimeParse.Lex(Int32 dps, __DTString str, DateTimeToken dtok, DateTimeRawInfo raw, DateTimeResult result, DateTimeFormatInfo& dtfi) at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.DateTime.Parse(String s, IFormatProvider provider, DateTimeStyles styles) at System.DateTime.Parse(String s, IFormatProvider provider) at System.DateTime.Parse(String s) at System.Convert.ToDateTime(String value) at Altiris.NS.ResourceManagement.DataClass.GetHashStrings(DataClassRows rows) at Altiris.NS.ResourceManagement.DataClassRowCollection.CommitData_Impl(IDataLoaderConnection connection) at Altiris.NS.ResourceManagement.DataClassRowCollection.CommitData(IDataLoaderConnection connection) ) Altiris.NS.ResourceManagement.DataClassRowCollection.CommitData

Cause

The AeXAMInventory.txt file contains three instances of msiexec.exe where the "last start" date is empty. The .NSE that gets generated from this file fills this field with "unknown". When the NS attempts to process the .NSE, SQL doesn't recognize this as a valid date/time entry and throws the error. It appears that the data processes correctly.

Resolution

Development indicates that this must be reproducible for them to look at it. The current fix is to disable the Application Metering monitor "All Applications" so that this data is not sent to the server.


Applies To

NS 6.0 SP2 Hotfix 19, Application Metering 6.0.1023