Recover deleted view

Paul Thornton ●

Hi Page,

I am going to see if I can answer both of your tickets here in regards to the View issue and Yellowfin Configuration question. In order to recover a view you would need to connect to the Yellowfin Configuration Database. Depending on what Database you configured initially will ultimately decide on the right SQL tool to use as you will have to connect to the DB using something like DBeaver or DBVisualiser etc.

When you installed Yellowfin you selected a DB, this information goes into the web.xml file which is located in /yellowfin_install/appserver/webapps/ROOT/WEB-INF/web.xml. In this file are a few lines which look like the following and shows you which database is your yellowfin config DB.

    <init-param>
      <param-name>JDBCUrl</param-name>
      <param-value>jdbc:postgresql://localhost:5432/my_database</param-value>
    </init-param>

Using a tool such as PgAdmin or DBeaver etc, you then need to connect to this database to make a manual backend change. (Please note that backend / direct changes are not supported, so please backup your DB first in-case something goes wrong and you need to recover)

The table you are interested in is ReportView

To find the deleted view run

SELECT * FROM ReportView WHERE ViewStatusCode='DELETED';

To restore the deleted view run

UPDATE ReportView SET ViewStatusCode='OPEN' WHERE ViewId=xxxx;

You then need to restart Yellowfin and the view will be back.

Please let me know if that all makes sense.

Regards,

Paul

Hi Page,

I am going to see if I can answer both of your tickets here in regards to the View issue and Yellowfin Configuration question. In order to recover a view you would need to connect to the Yellowfin Configuration Database. Depending on what Database you configured initially will ultimately decide on the right SQL tool to use as you will have to connect to the DB using something like DBeaver or DBVisualiser etc.

When you installed Yellowfin you selected a DB, this information goes into the web.xml file which is located in /yellowfin_install/appserver/webapps/ROOT/WEB-INF/web.xml. In this file are a few lines which look like the following and shows you which database is your yellowfin config DB.

    <init-param>
      <param-name>JDBCUrl</param-name>
      <param-value>jdbc:postgresql://localhost:5432/my_database</param-value>
    </init-param>

Using a tool such as PgAdmin or DBeaver etc, you then need to connect to this database to make a manual backend change. (Please note that backend / direct changes are not supported, so please backup your DB first in-case something goes wrong and you need to recover)

The table you are interested in is ReportView

To find the deleted view run

SELECT * FROM ReportView WHERE ViewStatusCode='DELETED';

To restore the deleted view run

UPDATE ReportView SET ViewStatusCode='OPEN' WHERE ViewId=xxxx;

You then need to restart Yellowfin and the view will be back.

Please let me know if that all makes sense.

Regards,

Paul

Reply URL

1

Page ●

Hi Paul,

Thanks for the quick response. I wasn't the person who originally configured yellowfin. I login to yellowfin via the online portal and when i do i can see the attached options.

I have created a datasource that connects to a AWS DB and i have been able to create a view from that datasource and run a report.

I haven't connected to the Yellowfin configuration DB before. Can i grab the connection details via the online portal with my administrator login? Do you need to connect to the configuration DB via a SQL developer tool or can i run queries against it via the online portal?

Thanks

Rebecca

Files:

URL

1

Paul Thornton ●

Hi Page,

You cannot see the Yellowfin configuration from the Admin console, unless someone has specifically created a datasource to it. You can only find the information as previously explained and someone who has access to the AWS DB should be able to connect and execute the SQL commands to restore the view. You cannot run the queries using the Yellowfin interface.

Regards,

Paul

URL

1

Page ●

Hi Paul,

Ok thanks, I will contact the person that created the yellowfin instance and see if i can get access to the db.

Thanks

Rebecca

URL

1

Paul Thornton ●

Hi Rebecca,

I think this will be the best option and should resolve the issue you are having. Is there anything else I can help you with or are you happy to close this off for now. You can always just respond to this ticket and it will re-open.

Thanks,

Paul

URL

1

Paul Thornton ●

Hi Rebecca,

Hope you're having a good week.

Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?

Regards,

Paul

Reply URL

1

Paul Thornton ●

Hi Rebecca,

I hope things are going well over there.

Just wanted to let you know I'll be closing this request due to inactivity. However, if you ever wanted to re-visit this or have anything else I can help you with, please let me know.

Regards,

Paul

Reply URL

Recover deleted view

Replies (3)