---
title: "saiku – wrong column name for multi-language label"
url: "https://openforis.support/questions/2268/saiku-wrong-column-name-for-multi-language-label"
tags: ["saiku"]
status: "accepted"
score: 0
answer_count: 1
asked: "2019-04-17T11:10:57"
last_activity: "2019-04-23T07:26:47"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# saiku – wrong column name for multi-language label

Asked by jurafejfar on 2019-04-17

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][1]
* db state: [https://drive.google.com/open?id=1YN4RJ5E15F95n74d_MUOcSAiM3tJKqzf][2]


  [1]: https://drive.google.com/open?id=1AVQHdk3VUKxs9yCG6RhNn-mclfOIblBC
  [2]: 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 (score 1, by Open Foris on 2019-04-17)

Link: https://openforis.support/questions/2268/saiku-wrong-column-name-for-multi-language-label/2269

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!

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