Question

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

  • 21 December 2023
  • 10 replies
  • 125 views
W
Rank
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

manikantad18
Rank
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.

Acumatica Functional Consultant
W
Rank
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.'
--

Chris Hackett
Rank
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. 

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
C
Rank
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. 

M
Rank
Userlevel 3
Badge

Hi @woodyg84 

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

C
Rank
Userlevel 3
Badge

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

Chris Hackett
Rank
Userlevel 7
Badge

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Troy Vars
Rank
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()
W
Rank
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)
C
Rank
Userlevel 3
Badge

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

Reply


Terms & ConditionsCookie settings
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