Can’t delete content categories
16 June, 2015
Looking through the forum it looks like a known bug to do with sub-queries. Do you have a fix for this?
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:
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!
The Yellowfin Support Team
Community Forum: www.yellowfinbi.com/YFForum.i4