aake version 24.2, error ODBCVAR must contain client_encoding=UTF-8

[Omer Nuri]

Hi all!

We are trying to deploy AAKE version 24.2 on Azure, we followed the documentation provided by broadcom found in:

https://academy.broadcom.com/hubfs/ESD/ESD_Academy/ESD_FY21_Academy/ESD_FY21_Academy_Files/ESD_FY21_Academy_Files_AIOps/Installing%20Automic%20Automation%20Kubernetes%20Edition%20on%20Microsoft%20Azure%20(v1.1).pdf

Everything went well, when we got to the last step, we performed the "helm install" command and got an error:
java.lang.IllegalStateException: ODBCVAR must contain client_encoding=UTF-8

The database section in the values.yaml file is as follows:
databases:
  # automationEngine contains db connection parameters for the Automation Engine
  automationEngine:
    # secretName the name of the secret within the same namespace that contains the database connection details
    secretName: ae-db

And the secret created as follows:

kubectl create secret generic ae-db --from-literal=host=<host> --from-literal=vendor=postgres --from-literal=port='5432' --from-literal=user=<user> --from-literal=db=ae --from-literal=password=<password> --from-literal=data-tablespace-name=pg_default --from-literal=index-tablespace-name=pg_default --from-literal=additional-parameters="connect_timeout=10 client_encoding=UTF8”

Searched online and couldnt find any good explanation to why this error occurre,

Does anyone has a suggestion?

Thank you for your help!
Omer.

[Oana Botez]

Hi Omer,

There is a typo in the command to create the ae-db secret, the client_encoding should be UTF-8, not UTF8.

BR,
Oana

[Omer Nuri]

Thank you, this was the problem, but we follow the documentation, and there it is written "UTF8".

[Oana Botez]

Thank you for pointing this out Omer, we will update the documentation.

BR,
Oana