Issues with Harvest.Tasks.IncrementalUpdateQueryTask

Hi,

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: 3.0.0.7573)

Telligent Community 5.5.133.9594

 

Any Help much appreciated,

thanks.

Related