Hi,

I have a question regarding a situation where a database was dropped and a different database with the same name (different tables) was created.

When I realized what happened (saw that the view had "unknown tables", marked with red borders) i switched back to the original database but now the view is OK (no errors or unknown tables/columns) but all the reports/dashboards based on this view show this message :

"Error retrieving results
An error occurred retrieving the results from the database."

I checked the view and the scheme is ok, But in step2 (View fields) i see a lot of Fields (columns) are missing from categories.

is there a reason why this is happening?
How can i fix this ?


appreciate any help in the matter

Shaul