What are these tables and can I delete them? EMAIL_DATA_######

Rick Root
Rick Root
Tenth Anniversary Kudos 2 Name Dropper Participant
in Blackbaud CRM Developer Discussions

Just wondering what these tables are.

I have 19 of them in the DB, and only one of them has been updated since 2022-03-01. 17 of them were created between 2017 and 2019. one created before, one after.

Seems likely to be coming from one of the CMS email processes but it's curious that there are only 19 of these tables.

d722035c22ec862883e7b2dd7d8ec417-huge-sc

Comments

  • William Burke
    William Burke
    Third Anniversary Kudos 1 Name Dropper Participant

    @Rick Root Hi Rick - I asked a couple of my colleagues about this and while they didn't have a ready answer they suggested that if you are still looking for guidance on this, you can open a ticket so our support team can investigate further. Thanks.

  • Chris Whisenhunt
    Chris Whisenhunt
    Fourth Anniversary Name Dropper Participant Facilitator 1

    @Rick Root I suggest looking into email processes with the ID of 55407. Looks like it's a biz proc that's running and creating/populating these tables, that is pretty standard CRM functionality. I believe that the email services global changes were migrated over to SQL Server jobs so that might be why you don't see anything new.

Categories