Skip to content

Azure Synapse Serverless: Cannot export data #18820

@dr-1

Description

@dr-1

Description

Data exports from queries on a Azure Synapse "serverless" database fail with this error, although query results are shown.

SQL Error [15871] [S0006]: '@@TRANCOUNT' is not supported.

DBeaver Version

22.3.1

Operating System

Windows 10

Database and driver

Database: Azure Synapse "serverless"
Server: Microsoft SQL Server 12.00.2531, Microsoft Azure SQL Data Warehouse - 10.0.15318.0
Driver: Microsoft JDBC Driver 9.2 for SQL Server 9.2.0.0

Steps to reproduce

  1. Run a SELECT query on a table or view
  2. Click "Export data" in the results pane
  3. Leaving the default export settings, click "Proceed"
  4. Observe error message

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions