#1 2020-10-05 12:50:08

quintg
Member
Registered: 2016-10-19
Posts: 30

Postgres emulated datasource

When I try to connect to a Incorta via their Postgres interface (https://docs.incorta.com/4.9/connect-power-bi-desktop/) I am getting this error: ERROR: java.sql.SQLException: Failed to parse query SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED.
Reason is that it is not a real Postgres database and this statement is not implemented (although part of SQL standard). I addressed this at the vendor but meanwhile, is there a workaround from RS to prevent/ignore this error?
By the way, if I set up this his datasource in DBeaver I have no problems querying.

Offline

#2 2020-10-05 13:23:04

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,789
Website

Re: Postgres emulated datasource

Hi quintg,

pls check here: https://forum.reportserver.net/viewtopi … 6735#p6735

can you set this as a server-level parameter as well somehow? I am not sure how this could be done specifically in Incorta, though.

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB