Deleting relational tables
Deleting a relational table within Acoustic Campaign may cause the browser to hang and might generate the following error.
The following relational table cannot be deleted. TABLENAME (the actual name of your relational table shows here) cannot be deleted. It is referenced in one or more queries, queries within programs, or dynamic content (in an email or asset library).
Resolving the problem
To resolve the issue, you must remove the queries that are associated with the Relational Table within the Acoustic Campaign.
- Go to Relational Tables.
- Open the relational table
- Click Queries and select all.
- Delete associated queries.
- Delete Relational Table.
If you need to find which items a relational table is associated to, open a support case and a list will be provided.
Note: Relational table queries do not need to be deleted in order for a relational table to be deleted. If you delete a Relational Table, the data cannot be retrieved. The best course of action is to re-import the data if you have it.
Comments
2 comments
Hello
Is there a way of finding which items a relational table is associated to?
I am trying to delete a relational table and the failure error says that there are mailing items associated.
How do I find these mailing items?
Thanks
Joe
Hello Joe,
I reached out to our Customer Support team and have found that you will have to open a case with the Customer Support team and they can provide a list for you.
https://help.goacoustic.com/hc/en-us/articles/360045577553-Open-a-support-case-April-1-and-beyond-
Thank you
Jeri
Please sign in to leave a comment.