Starting at about 3:16 this morning, we are seeing an exception being thrown by the UpdateBlogPostViewCountsJob. The exception is thrown roughly every 5 - 10 minutes.
The exception is:
UnknownException: An error occurred whilst executing the job UpdateBlogPostViewCountsJob (An error occurred while executing a background job. The error has been logged for the administrator to review.) ---> System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'AggViewCount'. 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.WeblogSqlDataProvider.UpdateDailyStatsAggViewCount(IEnumerable`1 views) at Telligent.Evolution.Blogs.Components.WeblogPostDataService.UpdateDailyStatsAggViewCount(IEnumerable`1 views) at Telligent.Evolution.Blogs.Components.UpdateBlogPostViewCountsJob.(JobData ) ClientConnectionId:5a88b399-6c77-4356-99cc-85fec220d5a1 Error Number:207,State:1,Class:16 --- End of inner exception stack trace --- at Telligent.Evolution.Platform.Logging.ErrorLogger.JobError[T](Exception ex) at Telligent.Evolution.Blogs.Components.UpdateBlogPostViewCountsJob.(JobData ) at Telligent.Evolution.Blogs.Components.UpdateBlogPostViewCountsJob.Execute(JobData context) at Telligent.Evolution.Components.Jobs.EvolutionJobRunner.SubExecute(JobExecutionContext context) at Telligent.Evolution.Components.Jobs.BaseJobRunner.Execute(JobExecutionContext job) at ...() 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()
Has anyone else seen this?
Thanks
Steve
Tried to fix formatting
[edited by: steve.bentley at 9:25 AM (GMT 0) on Tue, Oct 19 2021]
