Skip to main content
Question

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


Forum|alt.badge.img

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

Forum|alt.badge.img

Hi @woodyg84 

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


Troy Vars
Semi-Pro I
Forum|alt.badge.img+2
  • Semi-Pro I
  • 54 replies
  • January 11, 2024

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

Forum|alt.badge.img
  • Jr Varsity III
  • 60 replies
  • January 23, 2024

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


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • January 24, 2024

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. 


Forum|alt.badge.img
  • Jr Varsity III
  • 60 replies
  • January 24, 2024

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. 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

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.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 28 replies
  • January 26, 2024
 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)

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 28 replies
  • January 26, 2024

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


Forum|alt.badge.img
  • Jr Varsity III
  • 60 replies
  • January 26, 2024

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


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • March 19, 2024

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings