Skip to main content
Solved

Is it safe to Clean SMEmail table in Database, because Emails can NOT be truly deleted from Screen.


Forum|alt.badge.img+5
  • Captain II
  • 398 replies

Hello,

      We use Acumatica to send emails often, and the outing going emails are actually not needed. It takes me a lot time and effort to delete them twice on screen “All emails” CO409070.     

      But I happened to find these records, even if I have clicked delete twice on screen to delete(first time make processed to deleted, second time makes it disappeared from screen.)

          The table space usage are NOT actually reduced. 
Because it is still in DB, just with “DeletedDatabaseRecord =1 ”.

        I am not quite understand why this is designed this way. My question is,  if we just 
Delete * from SMEmail where CreatedDateTime <='2022-09-30 20:30:55.027' and DeletedDatabaseRecord =1 .  
      Would it be OK?

Best answer by ray20

To whom also be interested, I have tried in both test and production environment,
If I run 
Delete * from SMEmail where CreatedDateTime <='2022-09-30 20:30:55.027' and DeletedDatabaseRecord =1 .
It looks like no issue be brought in.  
But please keep in mind, you should be extremely careful to run this script and better with fully data backup. 

View original
Did this topic help you find an answer to your question?

5 replies

Forum|alt.badge.img+5
  • Author
  • Captain II
  • 398 replies
  • Answer
  • June 6, 2023

To whom also be interested, I have tried in both test and production environment,
If I run 
Delete * from SMEmail where CreatedDateTime <='2022-09-30 20:30:55.027' and DeletedDatabaseRecord =1 .
It looks like no issue be brought in.  
But please keep in mind, you should be extremely careful to run this script and better with fully data backup. 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2658 replies
  • June 6, 2023

Thank you for sharing your solution with the community @ray20 !


nhorvathNAW
Freshman II
Forum|alt.badge.img
  • Freshman II
  • 34 replies
  • October 25, 2024
ray20 wrote:

To whom also be interested, I have tried in both test and production environment,
If I run 
Delete * from SMEmail where CreatedDateTime <='2022-09-30 20:30:55.027' and DeletedDatabaseRecord =1 .
It looks like no issue be brought in.  
But please keep in mind, you should be extremely careful to run this script and better with fully data backup. 

Hey @ray20, what about all the file attachments? Won’t those remain behind?

 

I came across this post and the scripts in the replies:

 

Clear Email Queue | Community

 

 


ramuv9
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 18 replies
  • January 15, 2025

Hi ​@ray20 

Yes, you can delete this table able it won't cause any problems.


  • Acumatica Employee
  • 3 replies
  • January 21, 2025

Hi ​@nhorvathNAW The files would remain, there is a different script to delete upload files


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