Deleted view still marked as "OPEN" in YF db, not visible in Admin view browser

Billy Jarnagin shared this problem 3 years ago
Resolved

This subject sort of explains everything we're having trouble with here, so that begs the question:

What specific queries do I need to execute to delete a view and its associated reports from the Yellowfin database?


The UI-specific issues we're encountering here are that

  1. Since the view was deleted, it no longer appears in the view browser in the Admin page
  2. Since the view is still marked as OPEN in the database, its associated reports are visible from the browse page, however
  3. Attempting to access those reports simply redirects to the browse page.


We would like to just mark this stuff as deleted and attempt to reimport the report programmatically, as the view/report were initially imported from the API.


We are on the 7.2 September 8 build.

Comments (2)

photo
1

Hi Billy,


Thanks for your email.

Please try to delete those reports manually, if you cannot delete them, then try this below update statement on the Yellowfin DB:


UPDATE ReportHeader SET ReportStatusCode = 'DELETED' where reportname = <name of the report>


This will update the report status, so that they doesn't appear again.

Please let me know how did this go and if you have any questions.


Regards,


Mahe

photo
1

Hi Billy,


Can you please update me on how did you go with my advise?


Let me know if you still have an issue or if you have any questions.


Regards,


Mahe