Loading
システム管理者に対するフィッシング耐性MFA・全従業員ユーザーMFAの適用のお知らせ 続きを読む

Error "[Microsoft][ODBC Driver 17 for SQL Server]Restricted data type attribute violation" connecting to SQL Server Stored Procedures after Upgrade

公開日: Jul 13, 2026
説明

Issue

After upgrading Tableau Server or Tableau Desktop to version 2023.2.9, 2023.3.6, 2024.2, 2025.1, or 2025.3 and later, workbooks that connect to Microsoft SQL Server (or Azure SQL Database) via Stored Procedures may fail to load.

The following error message is displayed:

[Microsoft][ODBC Driver 17 for SQL Server]Restricted data type attribute violation

[Microsoft][ODBC Driver 18 for SQL Server]Restricted data type attribute violation

You may also see additional details such as:

Field '[FieldName]' domain cannot be calculated correctly.

Environment

  • Tableau Desktop 2023.2.9, 2023.3.6, 2024.2, 2025.1, 2025.3 and later
  • Tableau Server (corresponding versions)
  • Microsoft SQL Server or Azure SQL Database
  • Connection type: Stored Procedures

Cause:

This issue is caused by a change in the Query Pipeline (QP) component introduced in past maintenance releases.

When processing results from a Stored Procedure, Tableau incorrectly attempts to bind certain data types (such as DATE or String types) as Integers (BigInt). The SQL Server ODBC Driver rejects this implicit conversion request (e.g., DATE to Integer) with a "Restricted data type attribute violation" error.

解決策

To resolve this issue, disable the QueryPipeline_UseStoredProcRelationOp feature flag.

Option 1: For Tableau Server

  1. Open a command prompt (Windows) or a terminal (Linux) on the Tableau Server node (initial node).
  2. Run the following TSM command to disable the feature flag: 
    tsm configuration set -k features.QueryPipeline_UseStoredProcRelationOp -v false
  3. Apply the changes (This will restart Tableau Server): 
    tsm pending-changes apply

Option 2: For Tableau Desktop

Close Tableau Desktop and launch it from the command line with the override flag.

Windows:

  1. Open Command Prompt (cmd.exe) or PowerShell.
  2. Run the executable with the flag (adjust the path based on your installed version): 
    "C:\Program Files\Tableau\Tableau 20xx.x\bin\tableau.exe" -DOverride=QueryPipeline_UseStoredProcRelationOp:off

Mac:

  1. Open Terminal.
  2. Run the application binary with the flag (adjust the version in the path): 
    /Applications/Tableau\ Desktop\ 20xx.x.app/Contents/MacOS/Tableau -DOverride=QueryPipeline_UseStoredProcRelationOp:off
その他のリソース

This behavior is currently under investigation by Salesforce Engineering for a permanent fix in a future release.

ナレッジ記事番号

005232928

 
読み込み中
Salesforce Help | Article