Qlik Community

Ask a Question

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Talk to Experts Tuesday: Live chat Aug. 24th 10 AM ET: Bring your Qlik Gold Client questions REGISTER TODAY

How To Recover Document CALs Assigned To A Deleted QVW

Chip_Matejowsky
Support
Support

How To Recover Document CALs Assigned To A Deleted QVW

 

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)
Version history
Revision #:
2 of 2
Last update:
‎2020-10-23 05:46 AM
Updated by:
 
Contributors