topic lost document cals in QlikView

lost document cals

ali_hijazi — Mon, 26 Jan 2026 18:19:17 GMT

Hello

we recently renamed a document without removing the document cals assigned to it in the first place

Actually we forgot the old name

Now how can i retrieve document cals assigned to old document (old name)

Knowing that the qlikTech folder is backed up what is the file to restore? CalData.pgo found in Documents or in QlikView Server folders?

Please advise

Re: lost document cals

Bill_Britt — Tue, 20 Aug 2013 12:37:06 GMT

Hi,

You can try dropping another QVW into the folder with the old name. Then clear the CALs and once this is done delete the old QVW.

Bill

Re: lost document cals

Tue, 20 Aug 2013 12:54:44 GMT

Like Bill says - Try make a new document, but with same name. Then you should be able to remove the document calc. However its not always the case, i have the same problem where i have documents i cannot delete because an license is attached to them. But i cannot delete them.,

Re: lost document cals

sparur — Tue, 20 Aug 2013 12:59:31 GMT

As I understand the main issue is "Actually we forgot the old name"

So I think the PowerTools could help to review the CalData.pgo and clean it up.

Re: lost document cals

ali_hijazi — Tue, 20 Aug 2013 13:05:01 GMT

I have another case now

there is a cluster of 2 QlikView servers

The client restarted the main qlikveiw server and the document cals are lost (all documents had 0 assigned document CALs

I was told by QlikTech that there is an order to follow whenever a restart is needed

Anyway now the problem is on how can I rapidly reassign CALs rapidly?

Shall I restore the CalData.pgo file (knowing that the QlikTech folder is backedup on daily basis)

Please advise

Re: lost document cals

Tue, 20 Aug 2013 13:15:35 GMT

Hi,

If you don't remember the old document name, Please follow these steps.

1- Stop all Qlikview Servers.

2-Clear all .pgo files. Not only in Document folder. Search your Server disk by typing *.pgo and delete all. (Of course back up them first)

3- Start all Qlikview Servers.

4-Attach Document and Named CALS and try not to forget deleted document names or first detach Document CALS

Re: lost document cals

Thu, 05 Sep 2013 06:52:53 GMT

There is another good resolution, which will not require you to assign the CALs again.

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 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

This worked like a charm for me.

Re: lost document cals

Thu, 19 Sep 2013 09:18:03 GMT

Hi ,

I think, if you delete documents and cal was applied to them. After delete or un-apply

doc cals , doc cals may assigned to some other document .please check no of cals allocated to other document .

thanks,

D J

Re: lost document cals

beristardj — Tue, 25 Mar 2014 01:04:22 GMT

Hi.

In my case i try use SagarG method, but i dont find CalData.pgo.xml file only exist BorrowedCalData.pgo.xml , IniData.pgo.xml, ServerCounters.pgo.xls and TicketData.pgo.xml.

do you know anyone form of retrieve cals ?

regards...

Re: lost document cals

Bill_Britt — Tue, 25 Mar 2014 12:17:07 GMT

HI,

To get the PGO XLM file to show up you have to at PgoAsXmlAlso=1 under the [Setting 7] section in the server settings.ini file.

Bill