topic Re: Document CAL discussion in QlikView

Document CAL discussion

shiveshsingh — Wed, 25 Nov 2020 16:16:04 GMT

During one discussion, one of the user put this question.

They faced one issue wherein they had 200 QV cals and 130 were assigned.

They checked it another day and found all the 200 CALs were unused.

So how to check what happened? what's the approach i should follow?

Re: Document CAL discussion

Peter_Cammaert — Tue, 13 Mar 2018 22:43:45 GMT

CAL assignments are stored in CalData.pgo, which is available in two copies in the ProgramData\QlikTech tree. If those files become corrupt, all asignments are lost and the pgo file is zeroed out.

Do you have backups of these important files? One copy usually resides in your document root and should be backup up together with your publised documents.

Re: Document CAL discussion

shiveshsingh — Wed, 14 Mar 2018 06:06:50 GMT

Hello Peter

Thanks for the comments, please let me know where can i find those two copies?

ProgramData\QlikTech tree. And where can i find the backups?

Re: Document CAL discussion

Peter_Cammaert — Wed, 14 Mar 2018 08:45:26 GMT

One copy can be found in C:\ProgramData\QlikTech\QlikViewServer.

The other copy can be found in the QlikView Server Document root. I have no idea how you configured your server so you should either check the QMC, or - even simpeler - open Windows Explorer on your server and enter CalData.pgo in the seach box in the top right corner. Then press Enter and let Explorer search for all copies of that file. Remember to unhide C:\ProgramData if you didn't already do so.

Backups can be found on the media on which you make backups. If you don't make backups of your important files, then you're out of luck. Better initiate a backup strategy and include your Document root (including QVW documents, data and shared files) and the ProgramData\QlikTech folder.

See here for more info on what to backup: Backup and upgrade preparation - QlikView

Re: Document CAL discussion

shiveshsingh — Wed, 14 Mar 2018 11:34:54 GMT

Thanks for info