AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
(really) deleting e...
 
Notifications
Clear all

Questions (really) deleting emails

 
Everything Else
Last Post by atiu 5 years ago
3 Posts
2 Users
1 Reactions
2,769 Views
RSS
atiu
Posts: 7
 atiu
Topic starter
June 11, 2021 6:12 pm
(@atiu)
Active Member
Joined: 5 years ago

This is for a private cloud installation for Acumatica, so I have full access to the database.

 

Hello.

 

I was testing email functionality in our client's Acumatica system and temporarily used my Gmail as the System Email account.

I got my personal email working to test email sending from Acumatica, but it ended up importing 5000 of my old, personal emails into Acumatica. 

I went through the chore of manually deleting all of them in the interface, but all the emails still exist in SMEmail, and whatever attachments in UploadFileRevision.

The problem is that now a full snapshot has gone from 4MB to about 300MB only because of these bunk emails and attachments that persist in the SQL Server database.

 

Question:

Can I simply truncate SMEmail? I do not wish to keep any emails sent thus far in the system, as we are still in the early stages of implementation and no "real" emails have been sent yet, so all emails in the system can be deleted.

 

Thanks ahead.


2 Replies
Tim Rodman
Posts: 3199
 Tim Rodman
Admin
June 12, 2021 12:34 am
(@timrodman)
Famed Member
Joined: 10 years ago

I personally don't think it will cause critical errors, but of course truncate at your own risk.


Reply
atiu
 atiu
(@atiu)
Joined: 5 years ago

Active Member
Posts: 7
June 12, 2021 8:15 am
Reply toTim RodmanTim Rodman

@timrodman thanks for the feedback!


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,528 Topics
  • 10.9 K Posts
  • 48 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Credit Reference Report Needed
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×