|
I wonder if problem is here: deleting variant metrics followed by delete of push message metrics
delete from VariantMetricInformation vmi where vmi.pushMessageInformation.id in (select pmi FROM PushMessageInformation pmi WHERE pmi.submitDate < :oldest)
|
It seems that variant informations should be actually deleted in cascade:
So at the end simpler delete would be needed:
delete FROM PushMessageInformation pmi WHERE pmi.submitDate < :oldest
|
|