Very huge ".shared" file

[nicolas_martin]

Hello,

I have a QV application of 1 GB on my server.

When I look at the ".shared" file, the file is about 4 GB!

Unfortunatly, this prevents me to access the properties of this application in the management console.

I don't understand why the ".shared" file is so big, whereas it should only contain bookmarks.

Can you tell me:

- what other data is stored in this file?

- how to prevend this?

- how to reduce the size of this ".shared file" without loosing all bookmarks?

Thank you.

[luciancotea]

Hi Scott,

Shared files grows and QlikView (especially older versions) does a poor job in cleaning them. But bookmarks are the reason for huge increases, they don't just store the current selections definition, they store also values from the tables.

If you really need the .shared files, you have to manually delete the user bookmarks from time to time and ask them to refrain from using them in excess.

Regards,

Lucian

[scottparry]

Hi,

Thank you for the reply.  My biggest concern is that the server performance is terrible when the .shared files grow over 300,000KB and staff cannot even open the qvw application.  We've started deleting the .shared files daily, which really voids any need to even offer bookmarks as a feature/function to the user, as they are being wiped out every day. Qlik has come back to us saying it's working as it's designed, but do not recommend using bookmarks.

Unfortunately, we've offered this feature since release on all apps to 30k users, so it's diffcult to now take it away on 25 applications, but that seems to be the only option.  It's unfortunate that Qlik has offered a feature, but it has such poor performance on the system and users.  We are planning to upgrade to QlikView 12.1R3 in the next month or so and Qlik did say there is better optimization for .shared files, so it's a wait and see now, as we do not have a permanent technical solution to offer users for bookmarks.

Regards

Scott

[Miguel_Angel_Baeyens]

Plus, use the built in tool to purge and cleanup the shared files as explained in the release notes, section 12, but basically running

qvs.exe -x file.shared -v shared.verify.log

[scottparry]

Hi,

My admin attempted running the internal program on our DEV server with the problem QVW, but did not see any change in size of the .shared file.  Again, the file grows over 1 gig a day and performance continues to impact users, so I believe deleting the .shared file offers the resolution, but we are still trying to address the root cause of the size growth.  If it's truely bookmark size that's increasing, then it appears the only option we have is to remove the ability to set bookmarks to minimize extra processes on the server to delete or clean up the .shared file. Thoughts?

Regards,
Scott

[Miguel_Angel_Baeyens]

1GB per day of shared file means thousands of objects being created, or a bug causing a corruption in the server objects which could be causing that. Of course performance is impacted since shared files are run through (almost) every time you open the application.

And yes, deleting the shared file will fix the issue but if people are using shared objects they will be losing them as well. I would try reducing the writing on shared files by disabling session recovery, for example, and see whether that makes any difference, then disabling the objects in the QMC > User Documents > click on the document > Server Objects > Allow Creation of Server objects

[korsikov · Accepted solution]

Also Using Inputfields will often lead to .shared files increasing in size

https://support.qlik.com/articles/000002629