QVW distribution getting failed and file getting locked out on server(access point) in QMC

[CVR]

Hello Qlik Geeks,

Our company is having a strange issue with QMC. We have 4 QVWs in QMC and among them two works fine with no issues but the other two are getting failed while distributing to the server and even after distribution files are getting locked out and unable to open,delete or replace on the access point. We have to restart the server every time to delete those files. We are following 3-tier architecture and have 4 tasks in QMC for each file. The two files which are getting failed  are of size 1 GB each and have section access, document triggers.

Can anyone help us to resolve this issue?

Thanks in Advance,

CHVR

[marcus_sommer]

Maybe the used section access failed. For testing it I would just disable the section access.

- Marcus

[Sonja_Bauernfeind]

@marcus_sommer  is spot on there. With the .qvw not being accessible on the AccessPoint afterwards, Section Access would be my first suspect as well. 

Taking a quick look at the Tasklog for the two affected documents might help you figure out what's causing you grief as well. This article (kb 000003712)as a bunch of information on where to find them, in case you're not familiar with the log structure yet.

[CVR]

It is working fine when I disable section access but I am getting "connection lost to server" error message when i try to navigate to one sheet to another on access point. I used section access because of the same error earlier as i thought it would be because of huge data.  So, Should I change my section access script to work on the server if so , May I know what is the best practice to use section access for a QVW on the server?

[marcus_sommer]

It's just a side-effect that the data-reduction from a section access could lead to a better performance for certain users. But it's a security measure and shouldn't be alienated to cure any weaknesses within the datamodel and/or the UI expressions.

Your error-message of "connection lost" indicates that there is something not suitable respectively wrong with the application and/or the set settings (various timeouts) - whereby before playing with the settings which defaults are usually a good compromise for the most applications you should ensure that the application itself is build properly.

- Marcus

[Josh_Berg_Support]

If your QVWs are 1GB in size, they probably have very large datasets within them, the timeout values may need to be adjusted in order to handle these QVWs.  Do you see the "connection lost" error with other large QVWs as well?  Can you elaborate on what you mean by a file lock on the distribution files after a reload?  Does the distribution complete successfully?  What files are you seeing locked?

Thanks,
Josh

Qlik Support

[CVR]

Do you see the "connection lost" error with other large QVWs as well?

Ans: We have two large QVW's getting connection for those two.

Can you elaborate on what you mean by a file lock on the distribution files after a reload?

Ans: When I talk to my admin person he says files got locked on the access point and unable to open,edit or delete.

Does the distribution complete successfully?

Ans: Yes, Most of the times but not every time

What files are you seeing locked?

Ans: Large QVW's 

[marcus_sommer · Accepted solution]

I would create a new folder parallel to your root-folder and mount this folder within the qmc. Then I would there create new applications and copy & paste the script and a few essential objects and load the application manually with the desktop client (no qmc tasks at this time) without any section access. After it no failed access should happens.

Should there further connection lost errors you should really check the datamodel (no synthetic tables, no circular references and no calculations over island tables + removing/reducing of nested if-loops and aggr-functions) - for it it might be useful to reduce the number of records within the debugger, maybe to 100 k.

- Marcus