• State Suggested Answer
  • Replies 7 replies
  • Answers 1 answer
  • Subscribers 14 subscribers
  • Views 1548 views
  • Users 0 members are here
Options
Related

Exception being thrown by UpdateBlogPostViewCountsJob job

Former Member
Former Member

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]
Parents
No Data
Reply
  • Former Member
    0 Former Member in reply to Former Member

    The results are:

    Name Owner Type Created_datetime
    te_Blog_PostDailyStats dbo user table 2021-06-17 10:09:09.680

    Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
    PostId int no 4 10 0 no (n/a) (n/a) NULL
    ViewUtcDate datetime no 8 no (n/a) (n/a) NULL
    ViewCount int no 4 10 0 no (n/a) (n/a) NULL
    AggViewCount int no 4 10 0 no (n/a) (n/a) NULL

    Identity
    No identity column defined.

    RowGuidCol
    No rowguidcol column defined.

    Data_located_on_filegroup
    PRIMARY

    index_name index_description index_keys
    IX_te_Blog_PostDailyStats_PostId_Inc_ViewCount nonclustered located on PRIMARY PostId
    PK_te_Blog_PostDailyStats clustered, unique, primary key located on PRIMARY ViewUtcDate, PostId

    constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
    DEFAULT on column AggViewCount DF_te_Blog_PostDailyStats_AggViewCount (n/a) (n/a) (n/a) (n/a) ((0))
    DEFAULT on column ViewCount DF_te_Blog_PostDailyStats_ViewCount (n/a) (n/a) (n/a) (n/a) ((0))
    FOREIGN KEY FK_te_Blog_PostDailyStats_te_Blog_Posts Cascade No Action Enabled Is_For_Replication PostId
    REFERENCES RoyalNavy_Prod_Verint12_Content.dbo.te_Blog_Posts (PostId)
    PRIMARY KEY (clustered) PK_te_Blog_PostDailyStats (n/a) (n/a) (n/a) (n/a) ViewUtcDate, PostId

Children

About
Privacy Policy
Terms of use
Copyright 2025 Verint, Inc.
Powered by Verint Community