14 Replies Latest reply: Apr 10, 2017 11:01 AM by Miguel Angel Baeyens de Arce RSS

    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.

        • Re: Very huge ".shared" file
          Gysbert Wassenaar

          The PowerTools 1.1 for QlikView contains a shared file viewer you can use to see what's stored in it.

            • Re: Very huge ".shared" file
              Nicolas MARTIN

              I can't open the file with the shared file viewer

               

              I reduced it with the QVS.EXE command line --> now it's "only" 850 MB.

               

              I still can't open the file in the shared file viewer.

              After 1 hour, the shared file viewer showed me: 12 bookmarks. That's all!

              2014-11-28_175506.png

               

               

              I tried to log in the app, make few selections, change 1 "input field", close --> 1 GB.

              The simple fact to change the input field cost me 150 MB in the ".shared" file!

               

              Is there a way to say "don't save the values associated with the input fields"?

            • Re: Very huge ".shared" file
              Nicolas MARTIN

              When I look at my bookmarks in the "Shared File Viewer", I see that each bookmarks takes about 80'000'000 B (80 MB).

               

              But when I export the bookmark (xml), the file is only few KB.

               

              I don't understand what and where are the 80 MB of data...

                • Re: Very huge ".shared" file
                  Vlad Gutkovsky

                  Under the Tools menu in your screenshot above, select Defrag. The QlikView server does a very poor job of recovering unused bytes from shared files so a defrag becomes necessary from time to time.

                   

                  Cheers,

                  Vlad

                    • Re: Very huge ".shared" file
                      Scott Parry

                      Hi,

                       

                      I've opened several QLIK tickets with no route cause as to why the .Shared file is growing so large in several of our applications.  Unfortunately, the powertools cannot read the .shared file and for the most part we are deleting .shared files daily now as size is increasing.

                      there is 1 input field, but we already tested that theory months ago, we changed it to a list box and the Shared file size was still growing after that implementation
                      I has become more unncessary maintenance to delete .shared files when you can't file the route cause.
                        • Re: Very huge ".shared" file
                          Lucian Cotea

                          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

                            • Re: Very huge ".shared" file
                              Scott Parry

                              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

                                • Re: Very huge ".shared" file
                                  Miguel Angel Baeyens de Arce

                                  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

                                    • Re: Very huge ".shared" file
                                      Scott Parry

                                      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

                                        • Re: Very huge ".shared" file
                                          Miguel Angel Baeyens de Arce

                                          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