Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

How To Recover Document CALs Assigned To A Deleted QVW

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Chip_Matejowsky
Support
Support

How To Recover Document CALs Assigned To A Deleted QVW

Last Update:

Oct 23, 2020 5:46:29 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jan 31, 2013 12:32:13 PM

 

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:

  1. Stop the QlikView Server service.
  2. Add PgoAsXmlAlso=1 under [Settings 7]  in the Settings.ini file located in %ProgramData%\QlikTech\QlikViewServer (default location)
  3. Restart the QlikView Server service
  4. Navigate to Root Directory and Open the CalData.pgo.xml file to determine to which document the CALs were assigned
  5. 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
  6. In Management Console, navigate to Documents > User Documents and locate QWV created in the previous step .
  7. 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: 

  1. 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:

  1. Stop QVS and QMS as when you remove files it might still remain in the memory,
  2. And then delete both caldata.pgo file under the "user documents" and also "ProgramData\QlikTech\QlikViewServer"
  3. 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.

Labels (1)
Contributors
Version history
Last update:
‎2020-10-23 05:46 AM
Updated by: