saiku – wrong column name for multi-language label

  • Asked
  • Active
  • Viewed 3707 times
0

Dear developers,

we have found an error when saiku (CE version 1.8.0 build 2019-04-12) tries to get label of lookup table with multi-language labels:

PSQLException: ERROR: column c_fra_class_code_fra_class_code_code.c_fra_class_code_fra_class_code_label_ does not exist Rada: Perhaps you meant to reference the column "c_fra_class_code_fra_class_code_code.c_fra_class_code_fra_class_code_label". Pozice: 98

saiku generates column name 

c_fra_class_code_fra_class_code_label_ (note finale underscore)

but available columns are 

c_fra_class_code_fra_class_code_label
c_fra_class_code_fra_class_code_label_en
c_fra_class_code_fra_class_code_label_ru

screenshots (not able to upload directly here :-/ uploading images is limited to users with >60 reputation points):

Is it possible to somehow tell saiku which language to use? Or to use default label (without final _en for example)?

workaround:

It is possible to rename column in rddcollectsaiku schema to contain final underscore. After that saiku is working fine.

asked

jurafejfar 142●9●15 accept rate: 0%

1

Accepted answer

Hello,

Thank you very much for reporting and investigating the issue.

We introduced this error a couple of versions ago in Open Foris Collect. The cube definition is actually generated when the user exports the survey as a CEP file (inside the CEP file a file called collectEarthCubes.xml.fmt is generated, this is a freemarker template file)

We have fixed this issue on the latest version of Collect.

So the easiest way to get rid of it is to update to Collect 3.24.19 and afterwards export the CEP file again.

Thank you again!

permanent link

answered

Open Foris ♦♦ 1.1k●5●7●14 accept rate: 10%

Thanks, update of Collect solved the issue.

BTW, I am not able to upvote your answer nor award points to you because of not enough reputation. Those rules seems very restrictive to me.

jurafejfar jurafejfar

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.