I was trying to do the on-prem setup of SCH in which I have completed till configuring the control hub, relational databases, system data collector etc.
Now when I am going to create the required tables for each databases using “sudo dev/01-initdb.sh” command the tables are getting created for the first database i.e. “Security” and it is throwing error in the next database i.e. “PipelineStore”
From the marked red arrow the error is staring.
Can someone help me regarding this?
Best answer by XavierV
Hi
The error message mentions `\xE2\x9E\x9C` that is UTF-8 for an arrow , and is part of the description of one of the sample pipelines.
>>> print(b'\xE2\x9E\x9C'.decode('utf-8'))
➜
Can you verify that you have created the databases with UTF-8 encoding and review the unicode settings that you have used in your DB instance?
https://docs.streamsets.com/portal/controlhub/latest/onpremhelp/controlhub/UserGuide/Install/CreatingDBs.html#task_w3j_sll_kcb
-Xavier
Hi, saikat_chatterjee. Are you trying to upgrade an existing instance, or are you starting from scratch?
Hi
The error message mentions `\xE2\x9E\x9C` that is UTF-8 for an arrow , and is part of the description of one of the sample pipelines.
>>> print(b'\xE2\x9E\x9C'.decode('utf-8'))
➜
Can you verify that you have created the databases with UTF-8 encoding and review the unicode settings that you have used in your DB instance?
https://docs.streamsets.com/portal/controlhub/latest/onpremhelp/controlhub/UserGuide/Install/CreatingDBs.html#task_w3j_sll_kcb
-Xavier
Thank you
The error was due to encoding issue, my databases weren’t created with UTF-8 encoding.
Now its working fine.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
