Hi!
We want to delete Page views (Clickdimensions data) from CRM 2011 (on-prem), as it is filling a lot (around 7 million records in our database). We set up a bulk delete job in CRM for all of the records. It looks nice and starts to run (even though before it starts counting it throws a failed record that gives a SQL time out error), but runs only up to 150.000 or 33.000 and then calls the job as succeeded. Even though it is long from succeeded.
How to troubleshoot this issue? We can't seem to find any specific reason why the system thinks the job is completed successfully although it has only deleted a small bunch of the records.
We are wondering if the system is going through the following scenario: 1) Trying to fetch data before starting the process 2) then gets a timeout 3) adds that to failed 4) stops looking for more records and deletes the records it found until then 5) closes the job as succeeded.
If we are on the right track with our thoughts, then how do we resolve this issue? It is a long way to 7 million, if we have to make a new job after every 30.000 records.
Thank you!
*This post is locked for comments
I have the same question (0)
