QEM Analytics Repository specify Schema

[Steve_Nguyen]

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 

[AnneVo]

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

[Sonja_Bauernfeind]

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