---
title: "Species list empty in Saiku"
url: "https://openforis.support/questions/2409/species-list-empty-in-saiku"
tags: ["saiku", "collect"]
status: "accepted"
score: 0
answer_count: 1
asked: "2019-07-09T13:41:27"
last_activity: "2019-08-02T12:17:05"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# Species list empty in Saiku

Asked by wexxo on 2019-07-09

Hi OF Team,

I included a short species list in my survey, imported data and would like to show the recorded species grouped by another variable in Saiku (OF Collect). However, clicking the filter of the scientific name or code variable shows an empty box. When I try to group species according to another variable, I get the following error:

SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such column: household_view.fw_species_code)

Any hint that could help?

Thanks a lot!!


## Accepted answer (score 0, by Stefano (OF) on 2019-08-02)

Link: https://openforis.support/questions/2409/species-list-empty-in-saiku/2445

Dear Alex,  
The problem can be related to the use of a multiple "Taxon" attribute, that is not yet fully supported by the Saiku database generator.  
Please try to convert the structure of your schema into a multiple entity with a single Taxon attribute inside of it.  
Many thanks,  
Open Foris Team