File is locked

[pakosel]

Hi,
Thanks for sharing these examples, they are great. Most of the time all works perfectly but from time to time I'm getting the following error when trying to open the connection to .hyper file:
Tableau.HyperAPI.HyperException: error opening database 'xxxxx': There was an error during loading database: The database file is locked by another process: DatabaseId: 'xxxxxx'

This concerns the situation when a user browses Tableau Server workbook that refers to the same Data Source as I'm trying to access via a code - but even if the user closes a browser, the lock on the .hyper file remains for about 30 more minutes.
Does anyone know how to overcome the locking issues? Thanks,

[jkammerer]

Hello,
are you opening the .hyper files on the same machine on which Tableau Server is running?

[pakosel]

Hi,
Yes, that's exactly my use case - is it supported scenario?

[jkammerer]

I think that it will be hard to get this to work reliably since the files could always be opened by some user. The supported way to access the hyper files would be to use the Tableau Server REST API to download the datasource, edit this downloaded copy and then publish it again via the REST API.
That way you also don't have to do it on the same machine.

[pakosel]

Thanks for the hint but this might be also a problem since the hyper file is several GB of size.... Not even sure if REST API from Tableau could handle downloading such a massive files

[vogelsgesang]

There is also the "Hyper Update Rest API" through which you can modify parts of a Hyper file through the REST API.

You can find an example in https://github.com/tableau/hyper-api-samples/blob/main/Community-Supported/flights-data-incremental-refresh/flights-data-incremental-refresh.py