We're running the latest Smartertrack (12.2)
We've noticed that the Errors.log files in the App_Data\Logs can often get quite large.
In reviewing some of the recent log files we are seeing these two recurring errors and are wanting to know if there is anything we need to be doing to resolve these errors.
1)
Exception in the Task Watcher Thread Process
String or binary data would be truncated.
The statement has been terminated.
System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at SmarterTrack.Data.SqlHelperInternal.ExecuteReader(SqlConnection #CTc, SqlTransaction #SZc, CommandType #cH, String #Bbc, SqlParameter[] #TZc, #XZc #1Pi)
at SmarterTrack.Data.SqlHelperInternal.ExecuteReader(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at SmarterTrack.Data.SqlHelper.ExecuteReader(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at SmarterTrack.Data.EventReminderEntityBase.Save_SQL(IDbConnection& connection)
at SmarterTrack.Data.EventReminderEntityBase.Save(IDbConnection& connection)
at SmarterTrack.Data.EventReminderEntityBase.Save()
at SmarterTrack.Data.EventReminderEntity.Save()
at SmarterTrack.HelperClasses.Threads.Processes.TaskWatcherProcess.#7Lc()
at SmarterTrack.HelperClasses.Threads.Processes.TaskWatcherProcess.DoWork()
ClientConnectionId:6529363a-7377-4a90-bdb1-db4e9842c63b
Error Number:8152,State:13,Class:16
2)
Unhandled error
- Page: [http://xxxxxxxxx/SmarterCommunicator.ashx?handshakeToken=]
- Referrer: []
- User Agent: [] - IP: [xxx.xxx.xxx.xx]
Handshake is a required parameter.
System.ArgumentException: Handshake is a required parameter.
at SmarterTrack.HelperClasses.HTTPHandlers.SmarterCommunicator.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Thank you