KNOWLEDGE BASE

Connections to Stored Procedures on Azure Synapse Analytics Fail after Microsoft Update


Published: 20 Jul 2020
Last Modified Date: 16 Sep 2020

Issue

After a Microsoft update, Tableau connections to stored procedures on Azure SQL Data Warehouse fail.

The following error can be found in tabprotosrv.txt : Invalid object name '#Tableau_X_Y_sp_temp'. SQLSTATE_DDL_BASE_TABLE_NOT_FOUND

Environment

 
  • Tableau Desktop
  • Microsoft Azure SQL Data Warehouse (Azure Synapse Analytics)
  • Stored procedures
Did this article resolve the issue?