Forum

This content is now out of date.

Visit Our Community

Can’t delete content categories

I've delete or moved all the reports and dashboards out of a content category, however I cannot delete the category - yellowfin insists there are still reports in the category.

Looking through the forum it looks like a known bug to do with sub-queries. Do you have a fix for this?

Cheers
Hi There,

Thank you for submitting this. You are correct, this is a known defect, and there currently is an open task for this: Task ID#155203. The following forum post outlines this:

Delete content category...orphaned sub-query

In the mean time, you can run the following SQL query against your Yellowfin configuration database to resolve this. Please keep in mind we recommend backing up your Yellowfin configuration database prior to making changes to the database.

To manually delete orphaned sub queries run the following:

[code]UPDATE reportheader
SET reportstatuscode = 'DELETED'
WHERE rolecode = 'SUBQUERY' AND categorycode = '';[/code]

If you run into troubles please let me know and we can troubleshoot accordingly. Have a great day!

Cheers,

Dustin

Best regards,

The Yellowfin Support Team

Contact Us:
Email: support@yellowfin.bi
Wiki: wiki.yellowfin.com.au/display/USER71/Home
Community Forum: www.yellowfinbi.com/YFForum.i4

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.