Solved

Facing error in On-prem setup of sch

  • 17 May 2023
  • 4 replies
  • 47 views

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?

icon

Best answer by XavierV 24 May 2023, 09:00

View original

4 replies

Thank you @XavierV for you help.

The error was due to encoding issue, my databases weren’t created with UTF-8 encoding.

Now its working fine.

Hi @saikat_chatterjee , this looks like an encoding error.

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 @XavierV, I am trying to create it from scratch.

 

Hi, saikat_chatterjee. Are you trying to upgrade an existing instance, or are you starting from scratch?

Reply