article QEM Analytics Repository specify Schema in Official Support Articles

QEM Analytics Repository specify Schema

Steve_Nguyen — Tue, 05 Jan 2021 19:18:02 GMT

Question:

How do I setup Analytics Repository connection from QEM, to specify the schema to by Postgres Database?

Answer:

One can use the : Additional connection properties in the connection:

currentSchema = String

example:

currentSchema=awsschema

This would create the QEM tables in the awsschema schema.

Link for more Postgres connection string.

Postgres connection strings

Re: QEM Analytics Repository specify Schema

AnneVo — Mon, 09 May 2022 20:53:29 GMT

The connection test was successful with the additional properties as seen in the debug log:

"connectionProps": "role=cdc_qem_admin;currentSchema=cdc_qem"

but the initialization failed:

26 2022-05-09 16:37:03 [Host ] [DEBUG] Invoking service operation DropCreateRepository on request
26 2022-05-09 16:37:03 [AttInfrastructure] [DEBUG] DoWebRequest: RequestUri https://localhost:3102/rest/analytics/server/replicate/repository?action=drop_create, with the following diagnostic context 3343238d-c265-481a-93bd-a3390ed4f321
26 2022-05-09 16:37:03 [Host ] [DEBUG] Leaving service operation DropCreateRepository on request
26 2022-05-09 16:37:03 [WebLog ] [DEBUG] REST DropCreateRepository response 200 OK content: '{
"$type": "DropCreateRepositoryRespDto",
"successful": false,
"error_message": "ERROR: no schema has been selected to create in"
}'

It worked on our DEV database, but not on the newly built UAT database. Would you know why ?

Thank you

Re: QEM Analytics Repository specify Schema

Sonja_Bauernfeind — Fri, 13 May 2022 10:19:17 GMT

Hello @AnneVo

I would recommend posting about this issue in the appropriate product forum to gain additional visibility and assistance from our active engineers and customers. The appropriate board would be here: Qlik Enterprise Manager.

All the best,
Sonja