Can’t delete content categories
16 June, 2015
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
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
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 = '
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