Tracking lost licences

Keeping track of licences in a big environment can be a bit of a hassle.

In case you didn’t know, we can literally loose licences if we don’t make sure to follow all the necessary steps before deleting or updating a file name.

But, how do we know we are missing licences?

The answer to this question, it’s very simple and easy to spot.

If you delete or change a file name before removing any licences assigned to this file, then those licences will be lost and you won’t be able to use them in any other application.

For example, let’s suppose we have a file “Qlikview Document.qvw” with 1 document CAL assigned to it. If we now go ahead and delete this file (without removing the licence), the licence will be lost and the file will show up in QMC in capital letters.


Whenever we see a file like this, we should know we need to take action.

The first thing would be to restore the file we just deleted. If someone else deleted the file, it’s probably that we don’t know in what location the file was.

In order to find out the file path, we need to take a look at the CalData.pgo file which is is created by Qlikview Server in the root folder.
Unfortunately, we can’t access the pgo file. We first need to create a .xml copy of this file. Please refer to this post to read on how to create the .xml files.

Once we have our CalData.xml, we open it and search for the name of the deleted file.


Here, we’ll be able to find the path where the file was, who assigned the licence and when was this file last accessed. In my example, the file was located under my Test folder.
My next step is to go to that same path, and create a new blank QVW document with that exact name. Then open it, reload the blank document and save it.
After this, we’ll be able to delete the licence assigned to this file. Once this is done, you can go ahead and delete this file if you don’t need it.

I hope you find this useful.



Tags: , , , , , , , , , , , , , ,

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: