ReportServer Forum

quintg

Member

Registered: 2016-10-19

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.

IF_Eduardo

Administrator

Registered: 2016-11-01

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

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Postgres emulated datasource

Hi quintg,

we tested ReportServer (4.5.0) with Incorta (in the cloud) and everything works as expected, no error. Maybe the newer Incorta versions allow the same configuration ? Can you pls check ?
Are you using Incorta on the Cloud? Maybe you use an older version.
My connection URL is similar to:
jdbc:postgresql://incorta-4439.sqli.cloud4.incorta.com:9603/default

Anyway, ReportServer 4.6.0 will probably include Incorta support, but as I mentioned, the error you got is not reproducible.

Regards,
Eduardo

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Postgres emulated datasource

Hi quintg,

https://forum.reportserver.net/viewtopi … 295#p10295

in your error stack I see many entries containing:

net.sf.jsqlparser

This is *not* included in reportserver. You seem to have additional libraries other than the shipped ones. This is probably the cause of the error.
Using the official Postgres driver (shipped with ReportServer) I don't get any errors with Incorta.
Pls double check your additional libraries (in the external config dir) and also in web-inf/lib (these should not be modified!)

Regards,
Eduardo

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Postgres emulated datasource

Hi quintg,

pls. note that ReportServer 4.6.0 adds Incorta support, but as I mentioned, the error you got is not reproducible.

Here the release notes: https://reportserver.net/releasenotes/RS4.6.0.html

Regards,
Eduardo