KNOWLEDGE BASE

Error "PQresultStatus: 7 ERROR: Unable to resolve database file path" When Extract Refresh Fails


Published: 01 Aug 2019
Last Modified Date: 04 Mar 2020

Issue

After attempting to refresh extracts, the following error message occurs when the refresh fails:

"PQresultStatus: 7 ERROR:Unable to resolve database file path"


Additionally, the following path "_TDFSTRNSFR" can be found at the end of file path in the logs. For example, errors similar to the following sample can be found in the following logs: hyper_0_{DATETIME}.log nativeapi_backgrounder_#-#.txt and backgrounder_node#-#.log.

com.tableausoftware.nativeapi.exceptions.DataSourceException: [-38] PQresultStatus: 7 ERROR:  Unable to resolve database file path ("D:/Program Files/Tableau/Tableau Server/data/tabsvc/dataengine/extract/be/89/{29040E52-37DC-447F-A0C8-A16D73BA94A8}_TDFSTRNSFR"): Directory does not exist. 

 

Environment

Tableau Server 2018.3.3 , 2018.3.4 , 2019.2.0

Cause

This behavior was related to a known issue (ID: 928772 and 953432) and it has been fixed in Tableau Server 2019.3 and later versions.

Additional Information


 
Did this article resolve the issue?