topic Re: PostgreSQL Query in Connectivity & Data Prep

PostgreSQL Query

jpjust — Fri, 06 Jan 2023 15:01:55 GMT

Hi - I am trying to run a query like below on the qsr PostgreSQL database in pgadmin

select * from public."LicenseProfessionalAccessTypes" , public."Users"
where public."LicenseProfessionalAccessTypes"."User_ID" = public."Users"."UserId"

But I get the following error:

ERROR: operator does not exist: uuid = character varying LINE 2: ...public."LicenseProfessionalAccessTypes"."User_ID" = public."... ^

HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. SQL state: 42883 Character: 129

Can some one please advice?

THanks

Re: PostgreSQL Query

Frank_S — Fri, 06 Jan 2023 19:45:13 GMT

Hi @jpjust,

Rather than trying to help you with your code...I am going to recommend that you use the built in license monitor (and Operations Monitor) applications which provide this type of information.

If your license monitor is not working, you can solve that likely by updating the 'data connections' user account associated with each internal rest data connection found in the QMC.

For more information see point 13 in the following article:

https://community.qlik.com/t5/Official-Support-Articles/How-to-troubleshoot-and-resolve-reload-and-task-issues-with/ta-p/1716553

Here is a look at just one sheet of my own vApp license monitor tool in Qlik Sense.

Kind regards...

Re: PostgreSQL Query

NadiaB — Tue, 10 Jan 2023 21:37:21 GMT

Hi @jpjust

The field UserId from Users table is varying(255) while User_ID from the licenses table is uuid, it looks you are trying to join the tables based on user id, the field from the Users table would be ID not UserId.

You can double check the values in both tables by doing a select * separately and make sure you are considering the correct fields.

Kind Regards.