This exception shows up in my logs many, many times per day and I have no idea what it is or how to fix it.
UnknownException: An error occurred while recalculating a metric (An unexpected error prevented your requested action from completing. The error has been logged for the administrator to review.) ---> System.Data.SqlClient.SqlException (0x80131904): The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 3 ("@Value"): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.
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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, 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& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Telligent.Evolution.Data.ProfiledSqlCommand.ExecuteNonQuery()
at Telligent.Evolution.Data.ScoringSqlDataProvider.UpdateCalculatedMetric(CalculatedMetric calculatedMetric)
at Telligent.Evolution.Scoring.Services.ScoringService.CalculateAndUpdateMetric(Guid metricId, Guid contentId, Guid contentType)
at Telligent.Evolution.Scoring.Services.ScoringService.RecalculateFlaggedMetrics(Int32 maxResults, Nullable`1 cancellationToken)
ClientConnectionId:56e524d1-5a11-4524-baa4-7ba775b9a65f
Error Number:8023,State:1,Class:16
--- End of inner exception stack trace ---
at Telligent.Evolution.Scoring.Services.ScoringService.RecalculateFlaggedMetrics(Int32 maxResults, Nullable`1 cancellationToken)
at Telligent.Evolution.Scoring.Jobs.MetricRecalculationJob.Execute(JobData data)
at Telligent.Evolution.Components.Jobs.EvolutionJobRunner.SubExecute(JobExecutionContext context)
at Telligent.Evolution.Components.Jobs.BaseJobRunner.Execute(JobExecutionContext job)
at Telligent.Jobs.JobConsumer.<>c__DisplayClass20_0.<Consume>b__0()
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
at System.Threading.Tasks.Task.ExecutionContextCallback(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
at System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
at System.Threading.Tasks.Task.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()
