3819![]()
3819179 Append 1 3915963 56412 10/24/2018 6:11 ARCHIVED 3772443 Append 1 3773591 40792 9/6/2018 5:23 ARCHIVED 3769721 Append 1 3769759 40792 9/4/2018 11:51 ARCHIVED 3769442 Append 1 3769778 40792 9/4/2018 11:56 ARCHIVED 2968508 Append 1 2968512 20681 9/15/2017 8:15 ARCHIVED 2958517 Append 1 2958521 20681 9/15/2017 8:15 ARCHIVED 2957576 Append 1 2957605 20681 9/15/2017 5:36 ARCHIVED 2957711 Append 1 2957713 20681 9/15/2017 5:36 ARCHIVED 2958743 Append 1 2958747 20681 9/15/2017 8:15 ARCHIVED 179 Append 1 3915963 56412 10/24/2018 6:11 ARCHIVED 3772443 Append 1 3773591 40792 9/6/2018 5:23 ARCHIVED 3769721 Append 1 3769759 40792 9/4/2018 11:51 ARCHIVED 3769442 Append 1 3769778 40792 9/4/2018 11:56 ARCHIVED 2968508 Append 1 2968512 20681 9/15/2017 8:15 ARCHIVED 2958517 Append 1 2958521 20681 9/15/2017 8:15 ARCHIVED 2957576 Append 1 2957605 20681 9/15/2017 5:36 ARCHIVED 2957711 Append 1 2957713 20681 9/15/2017 5:36 ARCHIVED 2958743 Append 1 2958747 20681 9/15/2017 8:15 ARCHIVED
The same question
Hi Padurang,
Thanks for reaching out to support with your question.
Keep in mind that queries against the configuration DB are not technically covered in the Support Agreement; as such please assure you have good backups and a rollback plan before attempting the following.
It looks like based on an old ticket, you ran into a similar issue previously and this was a possible solution (please review, there may be syntax issues):
Hello YF team,
I have changed quary as above.
I think it shod clear cached filter values of deleted and archived reports.
Delete FROM CachedFilterValueWHERECachedFilterIdIN
(
SELECTCachedFilterIdFROM CachedFilterWHEREReportIdIN
(
SELECTReportIdFROM
(
SELECTReportName,h.ReportId,ReportStatusCode
FROM
CachedFilterr,
CachedFilterValueC,
ReportHeaderh
WHERECachedFilterTypeCode='CACHEDFILTER'
ANDc.CachedFilterID=r.CachedFilterID
ANDr.ReportId=h.ReportId
andReportStatusCodein('DELETED','ARCHIVED')
GROUPBYh.ReportId,ReportName,ReportStatusCode
)
)
);
Does this give you the results you're looking for?
Thanks,
Eric
Hi Padurang,
Thanks for reaching out to support with your question.
Keep in mind that queries against the configuration DB are not technically covered in the Support Agreement; as such please assure you have good backups and a rollback plan before attempting the following.
It looks like based on an old ticket, you ran into a similar issue previously and this was a possible solution (please review, there may be syntax issues):
Hello YF team,
I have changed quary as above.
I think it shod clear cached filter values of deleted and archived reports.
Delete FROM CachedFilterValueWHERECachedFilterIdIN
(
SELECTCachedFilterIdFROM CachedFilterWHEREReportIdIN
(
SELECTReportIdFROM
(
SELECTReportName,h.ReportId,ReportStatusCode
FROM
CachedFilterr,
CachedFilterValueC,
ReportHeaderh
WHERECachedFilterTypeCode='CACHEDFILTER'
ANDc.CachedFilterID=r.CachedFilterID
ANDr.ReportId=h.ReportId
andReportStatusCodein('DELETED','ARCHIVED')
GROUPBYh.ReportId,ReportName,ReportStatusCode
)
)
);
Does this give you the results you're looking for?
Thanks,
Eric
Hi Padurang,
Just wanted to check in to see if you were able to get things cleaned up here?
Thanks,
Eric
Hi Padurang,
Just wanted to check in to see if you were able to get things cleaned up here?
Thanks,
Eric
Hi Padurang,
I'm going to go ahead and mark this as Answered due to inactivity. Feel welcome to re-open with a reply if you have further related inquiries.
Thanks,
Eric
Hi Padurang,
I'm going to go ahead and mark this as Answered due to inactivity. Feel welcome to re-open with a reply if you have further related inquiries.
Thanks,
Eric
Replies have been locked on this page!