Species list empty in Saiku

  • Asked
  • Active
  • Viewed 4024 times
0

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!!

asked

wexxo 97●2●33●46 accept rate: 4%

0

Accepted answer

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

permanent link

answered

Stefano (OF) ♦♦ 5.7k●1●1●9 accept rate: 19%

Your answer

Insert an image

Say what the image shows, for people who can't see it.
At least 50 characters

Powered by the Open Foris edition of OSQA Content licensed under CC BY-SA 3.0

This Q&A software is free and open source (GPL). Any organisation can run it for its own community: get the code and instructions at github.com/openforis/osqa.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.