Power Tools - Shared File Viewer

[#1]

There are bookmarks in the file with $LASTKNOWNSTATE, can anyone enlighten me when these get created and how they are used?

[Bill_Britt]

These are used for session recovery.

[#3]

The issue seems to be they hang around indefinately, is there a setting that tells the server when to purge them?

[#4]

The issue is the .shared file keeps growing. The $LASTKNOWNSTATE records do not seem to be reset with a new session.

Please excuse the brevity of this email, it was sent from my telephone.

Rick Welch

Senior Consultant

rwelch@Analytics8.com<mailto:rwelch@Analytics8.com>

Cell: (910) 818-4559<tel:9108184559>

www.Analytics8.com<http://www.Analytics8.com>

[rwunderlich · Accepted solution]

There is an option available in QV11 and QV10 SR5 (not yet released) to expire temporary bookmarks. Haven't tested yet to see if it deletes the session recovery bookmarks.

There is an article in the Knowledge Base titled "Deleting Temp Bookmarks.pdf" that explains the option.

-Rob

[Bill_Britt]

To enable the deletion of temporary bookmarks, a setting needs to be activated in QlikView Server. Its value is a timeout value indicating how many days each temporary bookmark will be kept from its time of creation. This setting is available in the following versions: QlikView Server 10 SR5 and later QlikView Server 11 SR1 and later To enable this setting, do the following: In the Windows Services Management console, stop the QlikView Server service (QVS.exe) Locate the Settings.ini configuration file for QlikView Server. It is by default located in the application data folders for QlikView, which can be either of the following two locations:           Windows Server 2003: C:\Documents and Settings\All Users\Application Data\QlikTech\QlikViewServer Windows Server 2008: C:\ProgramData\QlikTech\QlikViewServer Open the Settings.ini file in a text editor Located the node [Settings 7] in the file. Directly under that, add the following row, where N is the timeout value (integer; days before bookmark is deleted): ServerTempBookmarkDayTimeout=N Save and close the Settings.ini file In the Windows Services Management console, start the QlikView Server service (QVS.exe) Note: Removing temporary bookmarks from the .shared file will not decrease the size of the .shared file. This is by design and a consequence of its binary format. To shrink/defrag .shared files, please visit QlikView QlikCommunity (http://www.qlik.com) and look into the Power Tools for QlikView suite and the tool Shared File Viewer.

[Brett_Bleess]

The Article number is 000002746.

[#8]

Hi Bill,

Thanks a lot for this info. I have a question - if the setting ServerTempBookmarkDayTimeout=N is enabled on server, will .shared file size get reduced by server after N days or will it remain same?

Thanks,

Anosh

[Bill_Britt]

HI,

No, according to the notes:

Note: Removing temporary bookmarks from the .shared file will not decrease the size of the .shared file. This is by design and a consequence of its binary format. 

Bill

[#10]

Thanks Bill.