Reason why transaction errors are seen when connecting to Presto/Trino data source through TIBCO Spotfire Information Designer

book

Article ID: KB0071082

calendar_today

Updated On:

Products	Versions
Spotfire Server	10.10 and higher

Description

You may notice following error when connecting to Presto/Trino data sources via Information Designer,

Error while connecting to Trino via JDBC: Error retrieving metadata: Query failed" "Client does not support transactions
Or
Error retrieving metadata: Query failed: Session properties cannot be overridden once a transaction is active

Issue/Introduction

This article provides resolution when transaction errors are seen connecting to Presto/Trino data source through Spotfire Analyst via Information Designer

Environment

All

Resolution

The value of autoCommit is false by default which doesn't support transactions.
To resolve this issue, please add the below line in the data source template and create a new data source and try it.