Changing SQL Query Error messages from French to English?

Options
oatz00
oatz00 Registered Posts: 6 ✭✭✭✭

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

Best Answer

  • oatz00
    oatz00 Registered Posts: 6 ✭✭✭✭
    Answer ✓
    Options

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

Answers

  • Sergey
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 Dataiker
    Options

    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
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron
    Options

    @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
    oatz00 Registered Posts: 6 ✭✭✭✭
    Options

    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
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 Dataiker
    Options

    @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
    oatz00 Registered Posts: 6 ✭✭✭✭
    Options

    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
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 Dataiker
    Options

    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
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron
    Options

    @sergeyd
    ,

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

  • Sergey
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 Dataiker
    Options

    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
    oatz00 Registered Posts: 6 ✭✭✭✭
    Options

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

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

  • Sergey
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 Dataiker
    Options

    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
    oatz00 Registered Posts: 6 ✭✭✭✭
    Options

    Thanks! Will try it out.

Setup Info
    Tags
      Help me…