I can't delete old reports (including drafts) from former employee

Daniel.Eyre shared this question 3 months ago
Answered

Hi guys,

A former colleague of mine has left a considerable legacy of draft reports and copies of old reports on our servers.

Unfortunately when I attempt to delete them (and save space) via the API I get the error:

"Oh no! An error has occurred during processing, please try again later"

/Bz+lBjfKYMLBAAAAAElFTkSuQmCC

I've searched previous inquiries of this error and it seems to be related to reports using calculated fields now broken or something. However when I attempt to even open thse old reports I get the same error message.

Is there some way that I can just get these old reports mass-dumped?

Comments (5)

photo
1

Hi Daniel,

yes you could run a query like the following:

UPDATE ReportHeader 
SET ReportStatusCode = 'DELETED' 
WHERE ReportName = 'Draft Report'


(or you could use ReportId if you wanted to be specific).

And if you're trying to save space you may as well physically remove the records by using DELETE instead of UPDATE.

As we remind all our clients who are going to modify their Yellowfin configuration database via the backend - please remember to back it up immediately beforehand!

regards,

David

photo
1

Okay I'll try this soon and let you know if there's any problem (or close the ticket if there isn't).


Thanks.

photo
1

OK Daniel, I'll keep the ticket open with the "Awaiting Response" status.

regards,

David

photo
1

Worked like a treat.


Thanks for your help.

photo
1

that's great news Daniel!

Thanks for letting me know.

regards,

David