Issues with Harvest.Tasks.IncrementalUpdateQueryTask


A public community space for Developers, IT Professionals, Architects, and System Administrators to engage and help each other, share knowledge and best practices, find product documentation and Q&A, and discuss technology oriented topics.

Issues with Harvest.Tasks.IncrementalUpdateQueryTask

This question is answered


We have just realised recently that a file with name Exceptions.txt was being created in C:\\Windows\system32\. The error that is appearing there is

Exception occurred @ 13/01/2011 16:35:34 : Source: .Net SqlClient Data Provider Message: 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. StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Harvest.Tasks.TaskSqlDataProvider.ExecuteNonQuery(String sql)
   at Harvest.Tasks.IncrementalUpdateQueryTask.DataManagement(TaskDataProvider



Regarding the versions we are using

Telligent Analytics (Build:

Telligent Community


Any Help much appreciated,


Verified Answer
All Replies