50
Hello!
I'm trying to figure out why a user's marketing lists are missing. They were there last week and now they are gone. They aren't deactivated - just gone. No one else has experienced this. Unfortunately, I didn't have auditing turned on for marketing lists so I don't have any info in the Audit Logs.
Is there any way to find out what caused this and how to recover them? It's as if they never existed.
Thanks,
Adil
Hi, I know this is an old question, but I have seen this happen before. The trigger was always a revert of the CRM database to a (recent) point in time restore.
The Marketing portion of CRM is in another database and is not restored in line with CRM resulting in several Marketing List en Template issues. Lesson learned: Do not revert to a backup when Marketing is enabled.
Hello Adil365,
In regards with this post, the pieces of information below are applicable for all entities, not only for marketing lists.
In terms of the technical background of this issue, marketing lists records, those which had been there from years in Legacy client under Marketing->Marketing list and the only way to trace them back is via Audit.
If your organization is on premises you can try something similar with this on SQL level:
select * from listbase where listname like '%your_marketing_list_name%'
together with something similar with the replies to this particular post:
As the design of our tables did not change too much since 2011, that should be ok in terms of tracking down that list.
If on the other hand the organization is online, Web API might be able to help, you have below the entity type to help you understand the filtering criteria for those:
The filtered list does not have an Web API does not have a correspondent in there.
The only way you can try to understand what happened with those lists is to verify the modified on and modify by, which are part of the results of the queries above, if they will return any result.
In terms of possible reasons for the behaviour:
- it can have a relationship with an organization reset/restore
- it might be an automatic process, like for example a bulk delete performed on the incorrect criteria
- or a manual delete
Without an entry for the list record in the query provided above there's no way to understand why the list does not exist anymore, unless you have some tracking in an external system or something similar, but out of the box, only Audit if it is enabled might help.
In terms of how to recover them, it depends, an organization restore, keeping in mind that organization restore will also remove the records created between the time of your last backup and the time of the restore unless you have a way to trace those and to export them prior to the restore in order to import them back after the restore.
On the other hand, if the record exists and it is only disabled, this would be the perfect situation, as the only thing you need to do is to reactivate it, but the chances are small, based on the description above.
Thank you,
Madalina Toma
Microsoft D365 CE Support
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,253
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
