How To Recover Document CALs Assigned To A Deleted QVW

Chip_Matejowsky — Fri, 23 Oct 2020 09:46:29 GMT

Environments:

Qlikview Server, all versions

The number of Document CALs assigned does not match the number believed to be assigned.

Document CALs are lost. In other words, if the user looks at each document and counts the number of Document CALS assigned to each, this number does not match what QlikView is showing in the Management Console.

The user may also notice that under Documents > User Documents there may be a QVW listed all in caps (MYQVW.QVW) that does not appear in the folder indicated. This is a good indicator that this is the culprit.

When deleting a QVW it is best to remove the assigned Document CALs first, then delete the QVW. By doing this the Document CALs are released and put back into the pool.

Scenario:

You have a total of 30 Doc Cals available at the beginning.

You assign 3 Doc CALS to a file named film.qvw. This leaves 27 Doc CALS unassigned.

If you now rename the file name to film_1.qvw or remove to another folder, you will still see 27 Doc CALs available, not 30.

Restarting the services, deleting the .shared files does not resolve the issue.

Resolution

There are 4 ways to resolve this problem. Which solution you choose depends on how many CALs you have lost.

Resolution 1:

Stop the QlikView Server service.
Add PgoAsXmlAlso=1 under [Settings 7] in the Settings.ini file located in %ProgramData%\QlikTech\QlikViewServer (default location)
Restart the QlikView Server service
Navigate to Root Directory and Open the CalData.pgo.xml file to determine to which document the CALs were assigned
Create a new blank QVW file named the same as document listed in CalData.pgo.xml & save it in the related Mounted or Root folder reported in CalData.pgo.xml
In Management Console, navigate to Documents > User Documents and locate QWV created in the previous step .
Click Document CALs tab and set Number of CALs allocated to this Document to zero and click Apply

Note: This resolution can be applied where the assigned CALs are HIGH in number.

Resolution 2:

See Recreate PGO from XML; the solution involves taking a backup of the PGO files as XML and then recreating them manually in the QMC.

Note: This resolution can be applied where the assigned CALs are in HIGH in number if Resolution 1 is unsuccessful.

Resolution 3:

Stop QVS and QMS as when you remove files it might still remain in the memory,
And then delete both caldata.pgo file under the "user documents" and also "ProgramData\QlikTech\QlikViewServer"
Restart the services

Note: This resolution can be applied where the assigned CALs are in LOW in number.

Resolution 4:

Clear the license information and reapply again

Note: This resolution can be applied where the assigned CALs are in LOW in number.

article How To Recover Document CALs Assigned To A Deleted QVW in Official Support Articles