Changing SQL Query Error messages from French to English?

Solved!
oatz00
Level 2
Changing SQL Query Error messages from French to English?

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:

1 Solution
oatz00
Level 2
Author

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

View solution in original post

12 Replies
sergeyd
Dataiker

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

 

0 Kudos
oatz00
Level 2
Author

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

0 Kudos
sergeyd
Dataiker

@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?

0 Kudos
oatz00
Level 2
Author

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.

0 Kudos
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 

--Tom
0 Kudos
oatz00
Level 2
Author

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

sergeyd
Dataiker

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 ๐Ÿ™‚ 

0 Kudos
tgb417

@sergeyd ,

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

 

--Tom
0 Kudos
sergeyd
Dataiker

Hi @tgb417 

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

Screenshot 2021-07-09 at 00.08.58.png

oatz00
Level 2
Author

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

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

0 Kudos
sergeyd
Dataiker

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
Level 2
Author

Thanks! Will try it out.

0 Kudos