ERROR DB Query Reader

**pio** · January 10, 2020, 2:23pm

Hi,
I am using DBeaver to connect to a server to read a query. Every time I run it , I get the following error

Execute failed: Query failed (#20200110_141034_01758_784i4): Session properties cannot be overridden once a transaction is active

What should I do to get it working?

**ipazin** · January 14, 2020, 9:24am

Hi there @pio,

to what database are you connecting and what does your query look like?

Br,
Ivan

**pio** · January 14, 2020, 4:09pm

Hi @ipazin,
I am connecting to presto Dbeaver

**ipazin** · January 15, 2020, 10:52am

Hi there @pio,

and your SQL statement looks like what? I found this issue that is still open: https://github.com/prestodb/presto/issues/8199

Now I don’t know if you are trying to change some property with SQL or KNIME does something it shouldn’t

Br,
Ivan