New Topic
CommunityTopicQuestionAdministration
Properties
Category Administration
Product Version 7.4

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

Daniel.Eyre shared this question 5 years 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?

2 The same question

Replies (5)

photo
1
Guest ● 5 years ago

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

Reply
photo
1
Daniel.Eyre ● 5 years ago

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


Thanks.

Reply
photo
1
Guest ● 5 years ago

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

regards,

David

Reply
photo
1
Daniel.Eyre ● 5 years ago

Worked like a treat.


Thanks for your help.

Reply
photo
1
Guest ● 5 years ago

that's great news Daniel!

Thanks for letting me know.

regards,

David

Reply
Leave a Comment
 
Attach a file