Question

Error: Inserting 'Email Activity' record raised at least one error. Please review the errors.

  • 21 December 2023
  • 10 replies
  • 142 views

Userlevel 2
Badge

Recently we start to have this error for incoming emails, not often, but couples a week. The email actually were processed into case activity and created records with cancelled status, and email itself are with failed status and won’t get re-processed 

Version: 23R1 110.0025


10 replies

Userlevel 3
Badge

Hi @woodyg84 

Can you provide us the error trace ? So we can check this further.

Userlevel 4
Badge +2

We are getting this now also

 

 

 Exception Type:
PX.Data.PXOuterException
 Message:
Error: Inserting  'Email Activity' record raised at least one error. Please review the errors.
 Stack Trace:
 at PX.Data.PXFirstChanceExceptionLogger.ProfilerFirstChanceException(Object o, FirstChanceExceptionEventArgs args) at PX.Data.PXUIFieldAttribute.CommandPreparing(PXCache sender, PXCommandPreparingEventArgs e) at PX.Data.PXCache.OnCommandPreparing(String name, Object row, Object value, PXDBOperation operation, Type table, FieldDescription& description) at PX.Data.PXProjectionAttribute.PersistInserted(PXCache sender, Object row) at PX.Data.PXCache`1.PersistInserted(Object row, Boolean bypassInterceptor) at PX.Data.PXCache`1.Persist(PXDBOperation operation) at PX.Data.PXGraph.Persist() at PX.Objects.EP.CommonMailReceiveProvider.MailProcessor.PersistAM() at PX.Objects.EP.CommonMailReceiveProvider.MailProcessor.PostProcessActivity() at PX.Objects.EP.CommonMailReceiveProvider.MailProcessor.ProcessMessage() at PX.Objects.EP.CommonMailReceiveProvider.MailProcessor.Proccess() at PX.Objects.EP.CommonMailReceiveProvider.MailProcessor.Proccess(PXGraph graph, EMailAccount account, IEmailProcessorsProvider emailProcessorsProvider, SMEmail email) at PX.Objects.EP.CommonMailReceiveProvider.Process(Object message) at PX.Objects.CR.CREmailActivityMaint.ProcessEmailMessage(SMEmail message) at PX.SM.EmailProcessingMaint.<>c.<InitializeProcessing>b__8_0(List`1 messages) at PX.Concurrency.CancellationIgnorantExtensions.RunWithCancellationViaThreadAbort(Action method, CancellationToken cancellationToken) at PX.Data.PXProcessingBase`1.<>c__DisplayClass90_0.<SetProcessDelegate>b__1(List`1 list, CancellationToken cancellationToken) at PX.Data.PXProcessingBase`1.<>c__DisplayClass89_0.<SetProcessDelegateCore>g__ProcessList|0(List`1 list, PXProcessingMessagesCollection`1 perrowmessage, CancellationToken cancellationToken) at PX.Data.PXProcessingBase`1.<>c__DisplayClass89_0.<SetProcessDelegateCore>b__1(List`1 list, CancellationToken cancellationToken) at PX.Data.PXProcessing`1.<>c__DisplayClass82_0.<Process>b__1(CancellationToken cancellationToken) at PX.Concurrency.Internal.PXLongOperationPars.PopAndRunDelegate(CancellationToken cancellationToken) at PX.Concurrency.Internal.RuntimeLongOperationManager.PerformOperation(PXLongOperationPars p) 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at PX.Concurrency.Internal.PXThreadPool.RunItem(RequestItem item) at PX.Concurrency.Internal.PXThreadPool.Run() 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart()
   PX.Data.PXException 2024-01-11 18:41:42 UTC
 
 Exception Type:
PX.Data.PXException
 Message:
Error: The transaction has been silently rolled back before a database update operation.
 Stack Trace:
 at PX.Data.PXFirstChanceExceptionLogger.ProfilerFirstChanceException(Object o, FirstChanceExceptionEventArgs args) at PX.Data.PXTransactionScope.RegisterActivity() at PX.Data.PXDatabase.Update[Table](PXDataFieldParam[] pars) at PX.Data.UserRecords.UserRecordsDBUpdater.UpdateVisitedRecordsCachedContentForAllUsers(Nullable`1 transactionID, ModifiedDacEntryForUserRecordsUpdate dacEntry, String entityType) at PX.Data.UserRecords.UserRecordsDBUpdater.UpdateUserRecordsForChangedDACs(Nullable`1 transactionID, IEnumerable`1 updatedDacEntries) at PX.Data.UserRecords.UserRecordsDBUpdater.UpdateUserRecords(IReadOnlyCollection`1 modifiedDacEntries) at PX.Data.PXTransactionScope.Complete(PXGraph graph) at PX.Objects.EP.CommonMailReceiveProvider.MailProcessor.ProcessMessage() at PX.Objects.EP.CommonMailReceiveProvider.MailProcessor.Proccess() at PX.Objects.EP.CommonMailReceiveProvider.MailProcessor.Proccess(PXGraph graph, EMailAccount account, IEmailProcessorsProvider emailProcessorsProvider, SMEmail email) at PX.Objects.EP.CommonMailReceiveProvider.Process(Object message) at PX.Objects.CR.CREmailActivityMaint.ProcessEmailMessage(SMEmail message) at PX.SM.EmailProcessingMaint.<>c.<InitializeProcessing>b__8_0(List`1 messages) at PX.Concurrency.CancellationIgnorantExtensions.RunWithCancellationViaThreadAbort(Action method, CancellationToken cancellationToken) at PX.Data.PXProcessingBase`1.<>c__DisplayClass90_0.<SetProcessDelegate>b__1(List`1 list, CancellationToken cancellationToken) at PX.Data.PXProcessingBase`1.<>c__DisplayClass89_0.<SetProcessDelegateCore>g__ProcessList|0(List`1 list, PXProcessingMessagesCollection`1 perrowmessage, CancellationToken cancellationToken) at PX.Data.PXProcessingBase`1.<>c__DisplayClass89_0.<SetProcessDelegateCore>b__1(List`1 list, CancellationToken cancellationToken) at PX.Data.PXProcessing`1.<>c__DisplayClass82_0.<Process>b__1(CancellationToken cancellationToken) at PX.Concurrency.Internal.PXLongOperationPars.PopAndRunDelegate(CancellationToken cancellationToken) at PX.Concurrency.Internal.RuntimeLongOperationManager.PerformOperation(PXLongOperationPars p) 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at PX.Concurrency.Internal.PXThreadPool.RunItem(RequestItem item) at PX.Concurrency.Internal.PXThreadPool.Run() 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart()
Userlevel 3
Badge

Do we need to open a ticket? or wait to see if someone replies to this  thread?

Userlevel 7
Badge

Hi @cwomack98 you should always contact your support when needed. The community experts are all fellow member volunteers. There's no guarantee of a solution. 

Userlevel 3
Badge

Thank you @Chris Hackett was hoping someone already dealt with this and I could try some stuff on my own before getting support involved since it isn’t every time it might be hard to recreate and didn’t want to waste their time. 

Userlevel 7
Badge +12

Hi @cwomack98 This error will appear if the system was unable to successfully perform a task and instead will silently rollback the change to prevent data corruption

 

Please open a case with Acumatica, if you have schedulers setup for sending emails Please review the schedulers once.

Userlevel 2
Badge
 Category:
Trace
 Message:
Error: Inserting  'Email Activity' record raised at least one error. Please review the errors.
 Stack Trace:
 at PX.Objects.CR.CREmailActivityMaint.ProcessEmailMessage(SMEmail message) at PX.Objects.CR.CREmailActivityMaint.<>c__DisplayClass50_0.<Process>b__0() at PX.Concurrency.CancellationIgnorantExtensions.RunWithCancellationViaThreadAbort(Action method, CancellationToken cancellationToken) at PX.Concurrency.CancellationIgnorantExtensions.<>c__DisplayClass1_0.<ToCancellationViaThreadAbort>b__0(CancellationToken cancellationToken) at PX.Concurrency.Internal.PXLongOperationPars.PopAndRunDelegate(CancellationToken cancellationToken) at PX.Concurrency.Internal.RuntimeLongOperationManager.PerformOperation(PXLongOperationPars p)
Userlevel 2
Badge

I’ve been using SQL to correct those record, but for sure that is not ideal solution

Update CRActivity set UIStatus='CD' where CreatedDateTime>='2024/01/01' and UIStatus='CL' and DeletedDatabaseRecord=0 and RefNoteID is not null and noteid in (Select RefNoteID from SMEmail where CreatedDateTime>='2024/01/01' and MPStatus='FL' and DeletedDatabaseRecord=0)


Update SMEmail set MPStatus='PD', Exception=Null where CreatedDateTime>='2024/01/01' and MPStatus='FL' and DeletedDatabaseRecord=0 and mailfrom not like 'MAILER-DAEMON' and Exception like 'Error: Inserting  ''Email Activity'' record raised at least one error. Please review the errors.'
--

Userlevel 3
Badge

@woodyg84 I will show this to my resident coder dude and see if this makes sense. Thank you very much. 

Userlevel 7
Badge

Hi @woodyg84 were you able to find a solution? Thank you!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved