9 Replies Latest reply: Mar 25, 2014 8:17 AM by Bill Britt RSS

    lost document cals

    Ali Hijazi

      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

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

              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

              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
                kerem pek├žabuk

                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

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

                    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
                      Cesar Augusto Beristain Lopez

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