saiku – wrong column name for multi-language label

Question

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):

saiku error: https://drive.google.com/open?id=1AVQHdk3VUKxs9yCG6RhNn-mclfOIblBC
db state: https://drive.google.com/open?id=1YN4RJ5E15F95n74d_MUOcSAiM3tJKqzf

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.

Accepted Answer

1

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 17 Apr '19, 11:16

Open Foris ♦♦
1.0k●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.

(23 Apr '19, 07:26) jurafejfar

saiku – wrong column name for multi-language label

Follow this question

Related questions