Event log error

Wei Wang asked on February 4, 2021 19:39

Hi,

We are using Kentico 11 portal engine for public website. Since we split the marketing database to it's separate entity, we saw this error popping up on the event log all the time.

In production environment, the error looks like this: Source: ContactActionsLogWorker

EventCode: Processing contact actions

UserID: 65

UserName: public

EventDescription: Unexpected exception occurred while processing activities. Message:

Proc_OM_ActivityRecalculationQueue_FetchActivityIDs

Caused exception: Violation of PRIMARY KEY constraint 'PK__#A3D0910__07D9BBC3873860C1'. Cannot insert duplicate key in object 'dbo.@DeletedIDs'. The duplicate key value is (0).

Exception type: System.Exception Stack trace: at CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, Exception ex) at CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) at CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query) at CMS.DataEngine.GeneralConnection.RunQueryWithRetry(QueryParameters query, Int32 retryCount) at CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query, Int32& totalRecords) at CMS.DataEngine.DataQueryBase1.GetDataFromDBInternal() at CMS.DataEngine.DataQueryBase1.GetDataFromDB() at CMS.DataEngine.DataQueryBase1.GetData() at CMS.DataEngine.DataQueryBase1.get_Result() at CMS.DataEngine.ConnectionHelper.ExecuteQuery(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns, Int32 offset, Int32 maxRecords, Int32& totalRecords) at CMS.OnlineMarketing.SqlActivityQueueRecalculationProvider.Dequeue() at CMS.ContactManagement.ContactActionsQueueProcessor.ProcessAllContactActions() at CMS.ContactManagement.ContactActionsLogWorker.ProcessActions()

Message: Violation of PRIMARY KEY constraint 'PK__#A3D0910__07D9BBC3873860C1'. Cannot insert duplicate key in object 'dbo.@DeletedIDs'. The duplicate key value is (0).

Exception type: System.Data.SqlClient.SqlException Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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, 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, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 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.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)

While in test environment the error looks like: Source:ContactActionsLogWorker Event code:Processing contact actions User ID:65 User name:public IP address: Description:Unexpected exception occurred while processing activities. Message:

Proc_OM_ActivityRecalculationQueue_FetchActivityIDs

Caused exception: The EXECUTE permission was denied on the object 'Proc_OM_ActivityRecalculationQueue_FetchActivityIDs', database 'ClevelandMetroparksMarketing', schema 'dbo'.

Message: The EXECUTE permission was denied on the object 'Proc_OM_ActivityRecalculationQueue_FetchActivityIDs', database 'ClevelandMetroparksMarketing', schema 'dbo'.

Any suggestions on how to resolve this?

thanks Wei Wang

event log database

Correct Answer

Dmitry Bastron answered on February 5, 2021 10:16

Hi Wei,

This was already answered in here. Please install 11.0.49 hotfix to solve this issue.

1 votesVote for this answer Unmark Correct answer

Recent Answers

Wei Wang answered on February 5, 2021 14:01

thank you!

0 votesVote for this answer Mark as a Correct answer