Forum Discussion

DMSJennifer's avatar
DMSJennifer
Icon for Helper I rankHelper I
4 years ago
Solved

Gateway Locks Acces-files

 

Hello everyone,

 

I hope someone can help us with the following problem:

We are getting the following error message when trying to synchronise Power BI Online:

 

Error: -2147467259
Errormessage: Could not use 'Minas.accdb'; file already in use.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Detail: Minas.accdb
Microsoft.Data.Mashup.ValueError.Reason: DataFormat.Error
URI cluster: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Time: 2021-12-15 09:55:07Z

 

We use the following:

- Windows server 2012 R2 Standard

- On-premises data gateway (3000.106.11 (November 2021))

- Microsoft Access database engine 2016 (English)

 

Our problem is that the on-premises data gateway locks the Acces-files. To unlock those files, the service needs to be stopped, then all the gateway processes need to be stopped on the server and then the service needs to start again. After the gateway unlocks the files, we can acces the files again. Unfortunately, if we synchronise again online, the gateway locks the files again and shows the errormessage given above.

 

Can anyone help us with this problem?

 

Kind regards,

Jennifer

2 Replies