How To Remove Orphaned QlikView Apps

What Causes Orphaned Records?

Applications that show in uppercase at the bottom of the list of apps on the Documents tab in QlikView Server are those that have been deleted, but still have hooks back into the QlikView Mananagement Console (QMC). Typically this is either a reload task or some Document CALs. If it’s the former then this task will run and fail on it’s old schedule – sending annoying failure mails. If it’s the latter then there are one or more CALs which can not be used on this app, or be re-assigned to others, wasting "money".
 

 

How Do I Remove Them?

Please create a dummy/blank QVW with the same name of a QVW which is displayed in the QMC (with all uppercase characters). The QVW name is indicative that Document CALs are still allocated to a QVW which was deleted from the User Documents. If a blank/dummy QVW is created and has the same name with the QVW that appears in the QMC (with uppercase characters), you should be able to de-allocate the Document CALs from that QVW and thereby regain the “lost” Doc CALs.

 

How Do I Create A File If I Don’t Know Where It Used To Be?

If the prior location of the file has been lost then you will need to find out where it used to be on the server.

If you have log files from when the file was previously reloaded or accessed through Access Point then these should point you to the location you need to recreate the file. Things get a bit trickier if the Mounted Folder has been removed.

Qlikview Server files .pgo can give us valuable information. PGO (Persistent Group Object) files are created by Qlikview Server and stored or placed in our root folder. The files are locked while the Qlikivew Server is running. The different pgo files contain information about borrowed CALs, CALs in use, Server settings and ticket data.
These files can’t be accessed without first converting them to .xml files.

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 - if you have changed the default location, then go to the location you changed to)
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 Root directory
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