Changing SQL Query Error messages from French to English?

oatz00

I just downloaded the free vm version of dataiku and it works great except SQL error messages (and only the errors) are in French. Does anyone know how to switch this to English?

Here's an example:

Recipe validation

Errors were encountered

• ERROR
  ERR_RECIPE_VALIDATION_FAILED

  Validation failed

  Query failed: ERREUR: la colonne « legendary » n'existe pas Position: 22

oatz00

This worked. Thank you!! Gave this a shot.

The config file for the VM for download on Dataiku's webpage is located: /var/lib/pgsql/data/postgresql.conf

Will need to use sudo to find and edit the file.

I changed lc_messages, lc_numeric, lc_time to = 'en_US.UTF-8' and default_text_search_config to = 'pg_catalog.english'

Rebooted (reboot) and English error messages!

Good learning experience...

Sergey

Hi @oatz00

This error is coming from the underlying DB the connection to which you are using for this SQL query. DSS has nothing to do here. This means that the DB server has a French locale or messaging is set to French like mentioned here for the PostgreSQL:

https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-LC-MESSAGES

tgb417

@oatz00
,

Welcome to the Dataiku Community. This is a great question. Which I don't know the answer to. I don't know if this is a DSS issue or the underlying SQL server issue. I'm guessing that this might be an underlying SQL server issue.

I don't have the free VM installed at this time, so I don't know what SQL server you are connecting to? DSS can connect to a lot of different types of SQL servers. My guess is that the VM has a PostgreSQL server installed. Does that seem right to you given what you know and are doing?

I found this youtube video that shows a way to change the error language on PostgreSQL server.

https://www.youtube.com/watch?v=U6CuRc4qNkQ

It has to do with finding and editing the postgresql.conf file to change the error language of PostgreSQL.

That said finding and editing this particular file on the VM may be a bit of a challenge. You will likely need a bit of Linux terminal/shell skill to do this.

Depending on the version of Linux the VM is based on the file may be in /etc/postgresql/12/main/postgresql.conf

P.S. You likely already know this. But, this particular error message translates to the following according to Google Translate:

Query failed: ERROR: column "legendary" does not exist Position: 22

Let us know how you get on with this.

cc: @CoreyS

oatz00

Thanks. It seems I can't change these values without recreating the databases. Definitely way over my head.

I'm surprised the preconfigured Dataiku VM has the postgres collate and ctype locale set to fr_FR.UTF-8

Sergey

@oatz00

What preconfigured DSS VM are you talking about? Are you using Dataiku Online but you mentioned that you have downloaded it so the answer is probably no. So we left with the OVA image, right?

oatz00

Yes. I used the OVA image. Was able to fix it by updating the postgresql.conf file. I forgot to use sudo before trying to edit the file.

Sergey

This might be indeed the case that OVA has default French locale for PostgreSQL. To be honest I didn't know we have installed PostgreSQL there

tgb417

@sergeyd
,

Is there an opportunity to get the OVA on one consistent language the next time that this is re-released?

Sergey

Hi @tgb417

I just tested the latest 9.0.4 image and everything is already set to en_US.UTF-8:

oatz00

I downloaded it around noon EST today, and it was version 9.0.1.

https://www.dataiku.com/product/get-started/virtualbox/

Sergey

Hi @oatz00

The link might not be updated so we will fix that. You can use this one instead:

https://downloads.dataiku.com/public/studio/9.0.4/dataiku-dss-9.0.4.ova

As 9.0.4 contains quite a lot of new features, you might want to try it out:

https://doc.dataiku.com/dss/latest/release_notes/9.0.html#version-9-0-4-june-21st-2021

oatz00

Thanks! Will try it out.