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 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

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 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 3
Badge

Hi @woodyg84 

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

Userlevel 3
Badge

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

Userlevel 7
Badge

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

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 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 3
Badge

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

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