• State Suggested Answer
  • Replies 7 replies
  • Answers 1 answer
  • Subscribers 14 subscribers
  • Views 1301 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
  • Former Member
    0 Former Member

    Hi Steve, which exact Community version are you on? This job was removed in v11.1.7 / v12.0.1 as part of work to improve our ContentViews API and related features.

    Have you made any changes to the database or the installation recently? Please confirm that during your most recent upgrade, all the dlls were copied correctly.

  • Former Member
    0 Former Member in reply to Former Member

    We're running version 12.0.0.15013. No changes were made to the database or installation recently, and all dlls where copied correctly in our last upgrade

  • Former Member
    0 Former Member in reply to Former Member

    Can you provide results of the following query?

    SELECT * FROM te_SchemaVersion
ORDER BY InstalledAt DESC

  • Former Member
    0 Former Member in reply to Former Member

    Here are the results.

    12.0,TE-16421-RemoveFeatureArticlePermission,2021-06-17 09:09:42.2700000
    12.0,TE-16265-SupportAttachmentsOver2GB,2021-06-17 09:09:42.2433333
    12.0,TE-16378-DeafultArticleWidgets,2021-06-17 09:09:42.2166667
    12.0,IncreaseThrottlingKeyLength,2021-06-17 09:09:42.1300000
    12.0,TE-16136-EnableArticleNotifications,2021-06-17 09:09:42.1100000
    12.0,TE-15704-PageRoles,2021-06-17 09:09:42.0833333
    12.0,ScriptedEmbeddableTyping,2021-06-17 09:09:42.0500000
    12.0,TE-15860-AddRowVersionId-Article3,2021-06-17 09:09:42.0300000
    12.0,TE-15524-EnableNotificationsByDefault,2021-06-17 09:09:41.9966667
    12.0,TE-15788-GroupTypePermissionTemplatesCleanup,2021-06-17 09:09:41.9800000
    12.0,TE-15532-UrlRedirectUpdatedDate,2021-06-17 09:09:41.7533333
    12.0,TE-14794_BlogPostImageAlternateText,2021-06-17 09:09:41.7333333
    12.0,Reindex,2021-06-17 09:09:41.7166667
    12.0,TE-15576-ContentConversionRedirects,2021-06-17 09:09:41.7066667
    12.0,TE-15400-ScriptedEmbeddables,2021-06-17 09:09:41.6833333
    12.0,TE-15399-ContentFilteringInheritance,2021-06-17 09:09:41.6366667
    12.0,TE-15913-ArticleSuppressNotifications,2021-06-17 09:09:41.5100000
    12.0,TE-14824-DataAttributesInContentFiltering,2021-06-17 09:09:41.4700000
    12.0,TE-14797-NonResolvableSystemNotifications,2021-06-17 09:09:41.4333333
    12.0,TE-15701-NewIndexes,2021-06-17 09:09:41.3400000
    12.0,TE-15846-ArticleContentViews,2021-06-17 09:09:41.2833333
    12.0,TE-15355-EnableArticles,2021-06-17 09:09:41.0833333
    12.0,TE-15254-WikiToArticleMigration5,2021-06-17 09:09:41.0700000
    12.0,TE-15355-Articles26,2021-06-17 09:09:41.0333333
    12.0,TE-14186-EmailVerification,2021-06-17 09:09:40.7433333
    12.0,TE-14719-UpdateProfileFieldTypes,2021-06-17 09:09:40.7000000
    12.0,TE-14719-LegacyPropertyControls,2021-06-17 09:09:40.6666667
    12.0,TE-15428-DisableWikisOnNewInstalls,2021-06-17 09:09:40.6166667
    12.0,TE-9564-Auditing5,2021-06-17 09:09:40.5400000
    12.0,TE-15993-CaseIssuesWhenLookingUpUsers,2021-06-17 09:09:40.4566667
    12.0,TE-9223-AuthoredContentCount,2021-06-17 09:09:40.4033333
    12.0,TE-14998-AddRowVersionId-AbuseAppeal,2021-06-17 09:09:40.2766667
    12.0,TE-14799-ReduceEffectivePermissionsTableSize,2021-06-17 09:09:40.2666667
    12.0,TE-10051-GroupTypePermissionTemplates,2021-06-17 09:09:40.2500000
    11.1,TE-16143-EmojiTextRepresentation,2021-06-17 09:09:40.1933333
    11.1,TE-16009-NewIndex,2021-06-17 09:09:40.1300000
    11.1,TE-15941-SystemAccountContentDetails,2021-06-17 09:09:40.1066667
    11.1,TE-15563-SameSiteCookies,2021-06-17 09:09:40.0900000
    11.1,TE-15447-ModerationRejectedNotification,2021-06-17 09:09:40.0333333
    11.1,TE-15197-KMAuthChange,2021-06-17 09:09:40.0200000
    11.1,TE-15057_DupKeyConcurrentlySchedulingUsersRecommendationRecalculations,2021-06-17 09:09:40.0100000
    11.1,TE-14650-NewIndexesForPerformance,2021-06-17 09:09:39.9800000
    11.1,te-9718-AkismetImprovements,2021-06-17 09:09:39.7033333
    11.1,TE-14225-SingletonAutomations,2021-06-17 09:09:39.6900000
    11.0,TE-15049-SQLServerDeadlocksDeletingUsersConcurrently,2021-06-17 09:09:39.6633333
    11.0,TE-14773-SearchHistoryException,2021-06-17 09:09:39.6466667
    11.0,TE-14226-ConfiguredAutomationState,2021-06-17 09:09:39.6300000
    11.0,TE-14687-HigherUserCoverPhotoDimensions,2021-06-17 09:09:39.6133333
    11.0,Reindex,2021-06-17 09:09:39.6033333
    11.0,TE-14419-EffectiveGroupMembers,2021-06-17 09:09:39.5866667
    11.0,TE-12285-TrackLeaderboardCreatorsForReporting,2021-06-17 09:09:39.4300000
    11.0,TE-12327-RemoveSystemUserAchievements,2021-06-17 09:09:39.4133333
    11.0,AutomationHttpTrigger,2021-06-17 09:09:39.4066667
    11.0,TE-9533-GhostAuthorBlogPosts,2021-06-17 09:09:39.3933333
    11.0,TE12140_KMCategoryKey,2021-06-17 09:09:39.3433333
    11.0,TE-9505-SearchSynonyms,2021-06-17 09:09:39.3000000
    11.0,RuleMigration2,2021-06-17 09:09:39.2733333
    11.0,AutomationRunAsServiceUser,2021-06-17 09:09:39.2100000
    11.0,PointsAutomations,2021-06-17 09:09:39.1933333
    11.0,AutomationVersioning,2021-06-17 09:09:39.1766667
    11.0,RuleMigration,2021-06-17 09:09:39.1666667
    11.0,AchievementAutomations,2021-06-17 09:09:39.1566667
    11.0,TE-14218-ImproveCalendarEventRegistrationTracking,2021-06-17 09:09:39.1400000
    11.0,TE-12273-ReviewableContentWorkflows6,2021-06-17 09:09:39.1233333
    11.0,TE-12528-ImprovePointTransactionConsolidation2,2021-06-17 09:09:39.0833333
    11.0,TE-12531-AddTypeIdForPointTransactions2,2021-06-17 09:09:39.0366667
    11.0,JavascriptScriptingSupport,2021-06-17 09:09:39.0133333
    11.0,TE-5293-WikiPageAbuseBehaviour,2021-06-17 09:09:38.9900000
    11.0,TE-14244-SearchHistory2,2021-06-17 09:09:38.9666667
    11.0,TE-12517-NewApiFilters,2021-06-17 09:09:38.9300000
    11.0,AutomationStudio-CreateTables,2021-06-17 09:09:38.5933333
    11.0,TE-9912-RemoveCrossPostingReferences,2021-06-17 09:09:38.5733333
    10.3,TE-15435-VelocityThrottling,2021-06-17 09:09:38.4866667
    10.3,TE-15406-ForumThreadListWidgetConfiguration,2021-06-17 09:09:38.4633333
    10.3,TE-15049-SQLServerDeadlocksDeletingUsersConcurrently,2021-06-17 09:09:38.4466667
    10.3,TE-9514-Throttling,2021-06-17 09:09:38.3300000
    10.3,TE-14727-ResetKMIndex,2021-06-17 09:09:38.3166667
    10.3,TE-14705-ForumThreadListPerformance,2021-06-17 09:09:38.3033333
    10.3,TE-14625-NotificationCleanup,2021-06-17 09:09:38.2200000
    10.3,TE-14707-GetRecentForumThreadsByForumPerformance2,2021-06-17 09:09:37.7366667
    10.3,TE-14338-CleanupNotificationActors,2021-06-17 09:09:37.6800000
    10.3,TE-12293-KMLastFailedColumn,2021-06-17 09:09:37.6333333
    10.3,TE-12204_MultipleKMEmbeds,2021-06-17 09:09:37.6200000
    10.3,TE-12316-FixBadAutoCreatedFields,2021-06-17 09:09:37.5866667
    10.3,TE-14131-BlogPostContentCreatedDate,2021-06-17 09:09:37.5733333
    10.3,TE-5522-UnreadNotificationFix,2021-06-17 09:09:37.5600000
    10.3,TE-12255-ActivityStreamQueryPerformance,2021-06-17 09:09:37.5200000
    10.3,TE-14132-Ideations-FixAllowMultipleVotesDefault,2021-06-17 09:09:37.4000000
    10.3,AddRowVersionId-Leaderboards,2021-06-17 09:09:37.3900000
    10.3,TE-5020-GroupRoleMemberPermissions,2021-06-17 09:09:37.3733333
    10.3,AddRowVersionId-KnowledgeManagement,2021-06-17 09:09:37.3466667
    10.3,104663-CleanupOrphanedWikiPageCoreContentRecords,2021-06-17 09:09:37.3300000
    10.3,106274-SqlDeadlockDetetingNotifications,2021-06-17 09:09:37.1700000
    10.3,104707-ImprovePerformanceFetchingContentForSearchIndexing,2021-06-17 09:09:37.1500000
    10.2,107109_KMIdToIndex_Reindex,2021-06-17 09:09:37.0000000
    10.2,TE-10355-CleanupOrphanedIdeas,2021-06-17 09:09:36.9833333
    10.2,106708_RemoveEventFormattedDescription,2021-06-17 09:09:36.5933333
    10.2,ThreadedCommentsSqlPerformance,2021-06-17 09:09:36.5666667
    10.2,ThreadedRepliesSqlPerformance,2021-06-17 09:09:36.5133333
    10.2,ThemeStudio-RemoveConfigurationScript,2021-06-17 09:09:36.4566667
    10.2,ThemeStudio-MigrationPreparation3,2021-06-17 09:09:36.4400000
    10.2,ThemeStudio-MigrationPreparation2,2021-06-17 09:09:36.3366667
    10.2,ThemeStudio-MigrationPreparation,2021-06-17 09:09:36.3100000
    10.2,IdeaCategories2,2021-06-17 09:09:36.2800000
    10.2,IdeaCategories,2021-06-17 09:09:36.2166667
    10.2,106098-IdeationVotingEnabledColumn,2021-06-17 09:09:36.1900000
    10.2,104698-RemoveStatusFromIdeaTable,2021-06-17 09:09:36.1700000
    10.2,104533-IdeaStatusIdForIdeaTable,2021-06-17 09:09:36.1433333
    10.2,104459_VoteTypeChange,2021-06-17 09:09:36.1300000
    10.2,106627-CleanupContainerTypesAndApplicationTypes-2,2021-06-17 09:09:35.9200000
    10.2,ThemeStudio-AddConfiguredContentFragmentContextId,2021-06-17 09:09:35.8466667
    10.2,ThemeStudio-AddLastModifiedFields,2021-06-17 09:09:35.8200000
    10.2,ThemeStudio-CreateExpiredPathsTable,2021-06-17 09:09:35.8000000
    10.2,ThemeStudio-PaletteConfiguration,2021-06-17 09:09:35.7733333
    10.2,ThemeStudio-CreateTablesAndStageMigration,2021-06-17 09:09:35.7566667
    10.2,AddRowVersionId-Content-Containers,2021-06-17 09:09:35.6900000
    10.2,106916_knowledgemanagment_Api_Changes,2021-06-17 09:09:35.6666667
    10.2,105986_DupKeyConcurrentRecentContent,2021-06-17 09:09:35.5033333
    10.2,106546-EnableDataExportCleanup,2021-06-17 09:09:35.4766667
    10.2,knowledgemanagement-updates,2021-06-17 09:09:35.4433333
    10.2,knowledgemanagement,2021-06-17 09:09:35.4100000
    10.2,106022-StoryTypeNamesInTypeTables,2021-06-17 09:09:35.1300000
    10.1,106536_CleanCrossDomainIdentityJob,2021-06-17 09:09:35.0733333
    10.1,105892_MetricAgingJobEnabled2,2021-06-17 09:09:35.0600000
    10.1,106333-FixRootGroupType,2021-06-17 09:09:35.0400000
    10.1,107658-DeadlockDeletingUserWithNotifications,2021-06-17 09:09:34.8533333
    10.1,106142-FixCalendarContextEnum,2021-06-17 09:09:34.8366667
    10.1,106217-AchievementStoryShouldBeDisableable,2021-06-17 09:09:34.8100000
    10.1,106728_RemoveUserArchiveService,2021-06-17 09:09:34.7966667
    10.1,106542_ConsentTOSUpdates_RemoveConsent,2021-06-17 09:09:34.7466667
    10.1,106542_ConsentTOSUpdates_defaults,2021-06-17 09:09:34.6633333
    10.1,106542_ConsentTOSUpdates,2021-06-17 09:09:34.6266667
    10.1,105949-SqlMessageBus,2021-06-17 09:09:34.5766667
    10.1,105951-EmailDigestTokensMoveTranslations,2021-06-17 09:09:34.5466667
    10.1,104704-ImprovePerformanceFetchingThreadsAndRepliesForSearchIndexing,2021-06-17 09:09:34.5333333
    10.1,104574-ActivityStoryStreamListPerformance,2021-06-17 09:09:34.4466667
    10.1,104631-ContentUserLikes-cs_User-ForeignKey,2021-06-17 09:09:34.4266667
    10.1,105745-HostlessProtocolValidation,2021-06-17 09:09:34.3900000
    10.1,107685_DupKeyErrorDownloadingFile,2021-06-17 09:09:34.3766667
    10.1,104709-UrlHostValidation,2021-06-17 09:09:34.2433333
    10.1,103321-FixIdeaCalendarAppTypeAndCategory,2021-06-17 09:09:34.2166667
    10.1,100163-ContentPageSearchCategory,2021-06-17 09:09:34.1900000
    10.1,103183-DeadlockUpdatingForumThreadStats,2021-06-17 09:09:34.1800000
    10.1,103186-cs_Groups_Query-Performance,2021-06-17 09:09:34.1633333
    10.1,107662-RemoveForeignKeyConstraintsOnObsoleteTable,2021-06-17 09:09:34.1466667
    10.1,102355-RemoveMgEmailQueue,2021-06-17 09:09:34.1133333
    10.1,102971-NewDBIndexesForPerformance,2021-06-17 09:09:34.0966667
    10.1,102410-IdeaStatusStoryUpdater,2021-06-17 09:09:33.7633333
    10.1,102114-GalleryAndMediaActivityStoryTypes2,2021-06-17 09:09:33.7500000
    10.1,102269-IndexBlogPostByBlogIdPostName,2021-06-17 09:09:33.7400000
    10.1,102336-EnhanceDistributedVersion,2021-06-17 09:09:33.7233333
    10.1,101854-ThreadQualityVoting,2021-06-17 09:09:33.7066667
    10.1,102181-AddRowVersionIdColumns,2021-06-17 09:09:33.6900000
    10.1,101938-OptimizeStatusMessageReindexQuery,2021-06-17 09:09:33.6000000
    10.1,101303_AddCoverPhotoActivityStory,2021-06-17 09:09:33.5833333
    10.1,101888-AddCreatedDateUserIdToAllApplicationTables,2021-06-17 09:09:33.5700000
    10.1,101890_ImproveForumGetThreadPerf,2021-06-17 09:09:33.4766667
    10.1,101885-AddRowVersionToIdeationsAndCalendars,2021-06-17 09:09:33.4600000
    10.1,101697-ActivityStoryUpdaters,2021-06-17 09:09:33.4366667
    10.1,101768-AddGenerticNameValueTableType,2021-06-17 09:09:33.4166667
    10.1,101822-RemoveUnusedBlogFollerFeedColumns,2021-06-17 09:09:33.4033333
    10.1,101743_AddThreadQualityVoting,2021-06-17 09:09:33.3700000
    10.1,101185_DupKeyConcurrentlySchedulingUsersForPointRecalculations,2021-06-17 09:09:33.0600000
    10.1,101470-DupKeyFlaggingMetricsOrScoreForRecalculation,2021-06-17 09:09:33.0366667
    10.1,101349-DeadlocksDeletingUsersConcurrently,2021-06-17 09:09:32.9000000
    10.1,101206-ThreadAutoLocking,2021-06-17 09:09:32.8633333
    10.1,100996-ImprovedPerformanceGettingPagedSetOfThreadsAndReplies,2021-06-17 09:09:32.8166667
    10.1,100933-DistributedLockMachineName,2021-06-17 09:09:32.7433333
    10.1,100931_PreventOrphanedUsers,2021-06-17 09:09:32.7266667
    10.1,97121-ReindexLeaderboardComments,2021-06-17 09:09:32.6333333
    10.1,100857-FixOAuthPluginAssemblies_2,2021-06-17 09:09:32.6200000
    10.1,100845-RemoveUnusedIndexes,2021-06-17 09:09:32.5833333
    10.0,105725-CalendarEventUtcConversion2,2021-06-17 09:09:32.5600000
    10.0,101450-CleanupOrphanedContentViews,2021-06-17 09:09:32.5300000
    10.0,100991-CalculatingGroupEffectiveMembersPerformance,2021-06-17 09:09:32.5200000
    10.0,101691_ImproveGettingGroupMemberIdPerformance,2021-06-17 09:09:32.5100000
    10.0,101003_ThreadedReplyHierarchy2,2021-06-17 09:09:32.4866667
    10.0,101003_CommentHierarchy2,2021-06-17 09:09:32.4300000
    10.0,ImproveGettingContentToIndexPerformance2,2021-06-17 09:09:31.5266667
    10.0,100407_RenameIndexesToIncludeUTC,2021-06-17 09:09:31.3166667
    10.0,100476_DuplicateCensorshipWordSupport,2021-06-17 09:09:31.1033333
    10.0,95158_MigrateBlogAutoCreateConfiguration,2021-06-17 09:09:31.0566667
    10.0,100408_FixTruncationIpv6Addresses,2021-06-17 09:09:31.0166667
    10.0,100391_Migrate_Core_Application_Enablement,2021-06-17 09:09:30.9900000
    10.0,100406_RemoveSettingIdFromExceptions,2021-06-17 09:09:30.9733333
    10.0,100363_CensorshipUpdates,2021-06-17 09:09:30.9466667
    10.0,100262_SystemNotificationSecurity,2021-06-17 09:09:30.9233333
    10.0,100336_UserPresenceAdministration,2021-06-17 09:09:30.8433333
    10.0,97802_Remove_EnablePostPoints,2021-06-17 09:09:30.8300000
    10.0,100307_DeadlocksCreatingThreadReplies,2021-06-17 09:09:30.7966667
    10.0,100151_GeocodingPluginsMerge,2021-06-17 09:09:30.7500000
    10.0,99577_FixBookmarkIssues,2021-06-17 09:09:30.7366667
    10.0,99937_Drop-cs_url-table,2021-06-17 09:09:30.6933333
    10.0,99593_UpdateCreatedUtcDateInContentDetailsTable,2021-06-17 09:09:30.6666667
    10.0,Default_Content_Filtering,2021-06-17 09:09:30.6366667
    10.0,100155_FixControlTypeAssemblies,2021-06-17 09:09:30.6133333
    10.0,100073_Achievements_UpdateBadgeIconUrls,2021-06-17 09:09:30.5966667
    10.0,Fix_Plugin_Assemblies_6,2021-06-17 09:09:30.5800000
    10.0,99662_LanguageDetection2,2021-06-17 09:09:29.8066667
    10.0,96145_SearchReindexForSolr6,2021-06-17 09:09:29.7966667
    10.0,99270_WidgetTypeMove,2021-06-17 09:09:29.7800000
    10.0,100005_SupportDeletingCommentsRepliesWithChildren,2021-06-17 09:09:29.7700000
    10.0,99983_UserInvitationStatus,2021-06-17 09:09:29.7300000
    10.0,99739_ConversationSearch,2021-06-17 09:09:29.5433333
    10.0,99703_AddThreadReplyQualityVoting,2021-06-17 09:09:29.5066667
    10.0,99670_PrioritizedNotifications,2021-06-17 09:09:29.2166667
    10.0,99717_ErrorWhenLoggingException,2021-06-17 09:09:29.1566667
    10.0,99611-GenericCfsUrlForAchievements,2021-06-17 09:09:29.1333333
    10.0,99797_ArchivedUsers,2021-06-17 09:09:29.1233333
    10.0,99255_AddHiddedThreadsToAbusiveContentTable,2021-06-17 09:09:29.1100000
    10.0,99675-Ideation-Configuration_2,2021-06-17 09:09:29.0966667
    10.0,99747_MoveGroupPluginToCalendarApp,2021-06-17 09:09:29.0833333
    10.0,99560_AddCommentVoting_3,2021-06-17 09:09:29.0600000
    10.0,98697_EventDatesToUTC,2021-06-17 09:09:28.8433333
    10.0,100652_RegistrationUpdates,2021-06-17 09:09:28.8100000
    10.0,100845-RemoveUnusedIndexes,2021-06-17 09:09:28.7666667
    10.0,100647_NavigationUpdate,2021-06-17 09:09:28.7433333
    10.0,100328_Fix_DocPreview_Plugin_Assemblies,2021-06-17 09:09:28.7333333
    10.0,Emoticons_7,2021-06-17 09:09:28.6766667
    10.0,99769_SupportNestedThreadReplies2,2021-06-17 09:09:16.2833333
    10.0,99737_ContentFiltering,2021-06-17 09:09:16.1666667
    10.0,99692_RenameColumnsToIncludeUTC,2021-06-17 09:09:16.1500000
    10.0,99489_NewConversationTables_4,2021-06-17 09:09:14.4500000
    10.0,98949-API-dates-are-not-consistent,2021-06-17 09:09:14.0800000
    10.0,94394_SupportNestedComments,2021-06-17 09:09:14.0066667
    9.2,101392-EmailNotificationsNotDisabledWhenUpgrading2,2021-06-17 09:09:13.9466667
    9.2,101844_ForceCalendar_Ideas_Reindex,2021-06-17 09:09:13.8666667
    9.2,99662_LanguageDetection2,2021-06-17 09:09:13.8400000
    9.2,100593_ImproveCalculateDailyStatsPerformance,2021-06-17 09:09:13.8266667
    9.2,95246-ActivityStoryActors-TableType,2021-06-17 09:09:13.7833333
    9.2,95222-CreateTable_te_SystemNotifications_2,2021-06-17 09:09:13.7633333
    9.2,99160 Some Wiki Page names cause Page Not Found Due to Url Format,2021-06-17 09:09:13.7300000
    9.2,99258_RootGroupNameCanBeChanged,2021-06-17 09:09:13.7133333
    9.2,99052_RevertSharedOptionsInPageEdit,2021-06-17 09:09:13.6966667
    9.2,98064-ForumMostRecentPostDate,2021-06-17 09:09:13.6766667
    9.2,99111_AddMissingClusteredIndex,2021-06-17 09:09:13.4000000
    9.2,92787_MailGateway_RecipientEmailAddresses,2021-06-17 09:09:13.3033333
    9.2,99058_UserAvatarStoryBuiltinAccountsFix,2021-06-17 09:09:13.2600000
    9.2,98203_ConversationIndicatorAfterUserDeleted,2021-06-17 09:09:13.1600000
    9.2,100422_SiteTerm_RemoveExtraSpaces,2021-06-17 09:09:13.1300000
    9.2,98439_CorrectFileCreatedDate,2021-06-17 09:09:12.6633333
    9.2,98441_DropTable_te_Content_ViewUrl,2021-06-17 09:09:12.6633333
    9.2,98635_RemoveExcessScoringOrphans,2021-06-17 09:09:12.6633333
    0.0,Initial,2021-06-17 09:09:12.6633333

  • Former Member
    0 Former Member in reply to Former Member

    Could you provide results of the following?

    sp_help N'dbo.te_Blog_PostDailyStats'

Reply Children
  • 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

  • Former Member
    0 Former Member in reply to Former Member

    We've uncovered an issue specific to your version that can cause this exception. The exception is resolved in version 12.0.1. We recommend you upgrade at least to this version, but preferably to the latest 12.0 hotfix version (12.0.3).

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