---
title: "SQLException: [SQLITE_ERROR] SQL error or missing database (no such table: forest_view)"
url: "https://openforis.support/questions/1533/sqlexception-sqlite_error-sql-error-or-missing-database-no-such-table-forest_view"
tags: ["saiku"]
status: "answered"
score: 0
answer_count: 3
asked: "2017-12-14T02:48:21"
last_activity: "2017-12-16T05:05:36"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# SQLException: [SQLITE_ERROR] SQL error or missing database (no such table: forest_view)

Asked by Rajkumar on 2017-12-14

Hi OFT,
I am facing a problem when saiku generates the database. it always says this type of msg **Generating Saiku Database
FAILED
Error processing RDB generation events** . When I start saiku and try to drag and drop attributes this type of msg **SQLException: [SQLITE_ERROR] SQL error or missing database (no such table:forest_ view)** appears. I browse the data with sqlite DB manager. There were table and its attribute but not the data. the data was promoted for analysis and the user was as admin.What should I do to overcome from this problem. I am using latest collect 3.20.9. however I have faced this problem from previous version, but in another computer it works fine. Thank you very much.


## Answer (score 0, by Stefano (OF) on 2017-12-15)

Link: https://openforis.support/questions/1533/sqlexception-sqlite_error-sql-error-or-missing-database-no-such-table-forest_view/1535

Hi Rajkumar,  
Please try to refresh the cubes in Saiku by pressing the refresh button on the right of Cubes heading ![alt text][1]  
Probably **forest** was the name of an entity that you renamed into something different and Saiku still reads the old survey structure.  
If you installed the latest version of Collect (3.20.9) from scratch (not updating it) the refresh will be automatic every time you start Saiku, otherwise you should do it "manually" every time you generate the Saiku database from Collect user interface.  
Many thanks,  
Open Foris Team


  [1]: http://www.openforis.org/support/upfiles/Saiku_cubes_refresh_button.png


## Answer (score 0, by Rajkumar on 2017-12-15)

Link: https://openforis.support/questions/1533/sqlexception-sqlite_error-sql-error-or-missing-database-no-such-table-forest_view/1536

Hi OFT, I have already done you suggested. I uninstalled it first, deleted all remaining files in C and user folder and reinstalled collect again. It did not work. I will try to avoid duplicate entity names in different surveys and try it again and let you know after that. Thank you very much for your prompt response.


## Answer (score 0, by Rajkumar on 2017-12-16)

Link: https://openforis.support/questions/1533/sqlexception-sqlite_error-sql-error-or-missing-database-no-such-table-forest_view/1537

Hi OFT, I did again what you suggested and My problem solved. Thank you very much.