Error "[SQLSTATE:58P01] Cannot Create Temp Database: The Transient Database Could Not Be Created" When Refreshing Extract Via Tableau Bridge Using Legacy Schedule

KNOWLEDGE BASE

Error "[SQLSTATE:58P01] Cannot Create Temp Database: The Transient Database Could Not Be Created" When Refreshing Extract Via Tableau Bridge Using Legacy Schedule

Published: 29 Dec 2022
Last Modified Date: 29 Dec 2022

Issue

The following error occurs intermittently when refreshing an extract via Bridge using legacy schedules

Unable to refresh the data source because of a query compilation.
status code = 5029, Failed to refresh data source: xxxxxx due to the following error: [SQLSTATE:58P01] Cannot create temp database: The transient database could not be created

Environment

Tableau Bridge
Tableau Cloud

Resolution

Use the Online Schedule as a workaround.

Note: Support for Bridge (legacy) schedules will be removed in a future release. To ensure a smooth transition, we recommend you use Online refresh schedules.