Can't load data from open file on Direct Access Gateway

[Landstede_Groep]

I work in Qlik Cloud, but need to access local Excel-files. First I had an app on our local Data Transfer Server. This app can load from Excel files, even when they're opened by a user.

Since the new feature in Data Access Gateway, where you can load files in the Cloud app, using the local Data Access Gateway, I can load data from my local network-Excel files in the Cloud. That's great! But... not when the Excel files are open. This will return a 'cannot open file' error when reloading.

Is this something that will be fixed in the near-future? Or do I have to keep using the local Qlik-app on the local Data Transfer? Or is there some fix I can implement?

[mpc]

Hi, 

I think it's a technical limitation, the file must be locked for reading, and it cannot be done since it's open. 
With Data Transfer, the behavior is maybe different because the file is simply pushed. 

Data Transfer will be deprecated soon, so I don't think it's ideal. You can contact Qlik Support team to confirm the behavior. 

Best 

[Landstede_Groep]

Hi,

DataTransfer is not simply pushing files to the cloud. On the DataTransfer server is a Qlik Sense app running and the server has a Qlik Sense engine who does this. So I run a script on the Data Transfer server to reload the app on that server. The result (all tables) are then stored as a qvd-file in Qlik Cloud.

This reload on the Data Transfer server can read from open Excel-files. This is what we have been doing for the past year, without any problems. Now we are using the Direct Acces Gateway on that same server to reload directly from the cloud, reading files on our local network share. Works like a charm! But not when the Excel-file(s) are open/in use. So that is really different behavior. It seams to me Qlik has the technoligy to load from open files, but not in this new situation (file access through Data Acces Gateway).

[mpc]

It's quite more complex, the created QVD is stored in a temp folder of the QDT server (C:\ProgramData\Qlik\DataTransfer\DataUpload\qixdata), and then pushed in Qlik Cloud. So maybe no lock is needed. 

For Qlik Data Gateway, I think the data is pulled from the Excel file directly by the Qlik Cloud app. Maybe this feature then need a lock ? 

Best way to know is to contact the support team I think !

[sika00011]

Hi,

have you found out more?

We have the same problem transitioning to QlikCloud. We have quite a lot of excel files we have to read and those files will be edited by users. So we always have the risk of an reload failure because the file might be locked...

Thanks.

[jgtaekema · Accepted solution]

Yes, Qlik answered my question. They said this issue wil be solved in version 1.7.6 of Data Access Gateway. 

[korsikov]

I'm currenly use 1.7.7 and can't load XLS files open in Excel with error 
(Connector error: A precondition failed. The process cannot access the file '\\host.com\rrr\SomeUsers.xls' because it is being used by another process. (DirectAccess-5016))

and in logs 
2025-10-10 16:57:12,086 [ 68] [INFO ] DAG - RequestId=104fff4e-463a-4086-9057-4ed29134de29 ClientSessionId= ReloadId=55877e38-acbc-4dd5-a0c7-3189ed6c9f92 AppId=dummyDocId Message=FILE connector process (2864) with worker process (5400) started successfully after 1.325 seconds and 1 attempt(s).

Data Port: 49152, Management Port: 491532025-10-10 16:57:12,198 [ 66] [INFO ] DAG - RequestId=104fff4e-463a-4086-9057-4ed29134de29 ClientSessionId= ReloadId=55877e38-acbc-4dd5-a0c7-3189ed6c9f92 AppId=dummy

DocId Message=Sending ping to server for request 104fff4e-463a-4086-9057-4ed29134de292025-10-10 16:57:12,401 [134]

[ERROR] DAG - RequestId=104fff4e-463a-4086-9057-4ed29134de29 ClientSessionId= ReloadId=55877e38-acbc-4dd5-a0c7-3189ed6c9f92 AppId=dummyDocId Message=Error for RequestDownload: Status(StatusCode="FailedPrecondition", Detail="The process cannot access the file '\\host\rr\SomeUsers.xls' because it is being used by another process."

)Grpc.Core.RpcException: Status(StatusCode="FailedPrecondition", Detail="The process cannot access the file '\\host .com\rr\SomeUsers.xls' because it is being used by another process.") at Grpc.Net.Client.Internal.HttpContentClientStreamReader`2.MoveNextCore(CancellationToken cancellationToken) at Qlik.ConnectorAgent.FileHostingConnectorGrpcClient.RequestDownload(String reloadId, String fileName, Guid jobId, IChunkWriterDownload writer, String serializedSpaceValidationInfo) at Qlik.ConnectorAgent.FileJob.<>c__DisplayClass14_0.<<RequestDownload>b__0>d.MoveNext()--- End of stack trace from previous location --- at Qlik.ConnectorAgent.FileJob.Run[T](Func`1 func, EngineCallContext engineCallContext) at Qlik.ConnectorAgent.FileJob.RequestDownload(String requestId, EngineCallContext engineCallContext) at Qlik.ConnectorAgent.Controllers.FileController.<>c.<<PostRequestDownloadAsync>b__26_1>d.MoveNext()--- End of stack trace from previous location --- at Qlik.ConnectorAgent.Controllers.JobAction.RunAsync(String requestId, EngineCallContext engineCallContext) at Qlik.ConnectorAgent.Controllers.FileController.PostRequestAsync(JobAction jobAction)