12 Replies Latest reply: Jun 20, 2014 8:14 AM by Torsten Rehder RSS

    Lost Named User CALS

    Brian Helms

      I am currently having an issue on our production server/publisher. So far three times today we have lost all of our User CAL information. The server says

      Named User CALs: 0 assigned (xxx in license). We then have to go in and manually update our user lists which takes a long time and our users cannot access QlikView when this happens. We also have seen this issue in the past few days but not as often as it happened today. We tried deleting the PGO files and starting new, but it still continues to happen. Has anyone seen this before or have any suggestions?

        • Re: Lost Named User CALS
          Rob Wunderlich

          You may want to contact Support as it sounds like your PGO files are getting corrupted. Is the server root folder on a NAS by any chance?



          • Re: Lost Named User CALS
            Deepak Kurup

            Hi ,


            Do you have any antivirus running on the server? I had experience similar situation, In my case the .pgo files where detected as virus and the software used to delete the files.




            • Re: Lost Named User CALS
              Miguel Angel Baeyens de Arce



              In addition to the ideas suggested above, how big are your .SHARED files? Are you using DMS? There is a chance that the SHARED files are storing the license information and they might be corrupted. Anyway, adding all QlikView folders as exceptions to the antivirus as suggested by Deepak is always a good idea.


              Hope that helps.



              • Re: Lost Named User CALS
                Chris Smith

                I seem to be having this problem as well though my files seem to get wiped out intermittently.    We'll go a week or two with no problems, but then suddenly they all get wiped out.


                I'd think if the antivirus was deleting them it would happen everyday when the scan occurs.

                  • Re: Lost Named User CALS
                    Ronnie Taborn

                    In general, the actual shared file (either it is .shared or .pgo or any shared files) structure does not get corrupted. Actual file corruption is generally caused by hardware issues or malicious code. What it was noticed is that shared objects stored in the file are sometimes not complete, or containing garbage characters. The most likely causes of this is that the shared file handling was lacking when it comes to high amounts of concurrent reading /writing and unexpected events like server restarts/crashes.

                    Most other common reasons for file corruption are:

                    1. Improper shutdowns, such as caused by power outages or performing a hard restart: pressing and holding the power button.
                    2. Hardware problems or failures, including hard drive failures, bad sectors, bad RAM. 
                    3. Failure to eject external hard drives and related storage devices before disconnecting them or powering them off.
                    4. Bad programming, particularly if it results in either hard restarts or data that is saved incorrectly.
                    5. When Antivirus trying to access same file when the file is in use.(From Server Reference Manual, Section 4..3 Note! Running real-time anti-virus protection on the server degrades the performance of QlikView Server. It is recommended that the user documents, source documents, log directories, and .pgo files are excluded from the anti-virus scanning.)

                    For further more details, please read below, copied from the following link http://www.ehow.com/info_8042977_causes-corrupt-file.html
                    Bad Sectors

                    Sectors are divisions of a hard disk. When a user tries to save a file, the computer searches for a sector on the hard disk to save the data. If the computer saves a file to a "bad sector," the file is likely to become corrupt or inaccessible. Bad sectors can be caused by physical damage (i.e., the hard disk losing magnetism and hence its ability to store data) or bad parity checks on the disk. A computer does not know which sectors are bad or unstable, so the user must scan hard disks (such as the C Drive) to check for bad sectors. This can be done by right-clicking on the drive from "My Computer," selecting "Properties," "Tools" and selecting "Check Now" under the heading "Error-checking."


                    Cross-Linked Files or Lost Clusters

                    In computer systems, a "cluster" is the smallest amount of disk space needed to store a file. Files are allocated individual clusters, which can range from one sector (512 bytes) to 128 sectors (64 kilobytes). A cross-linked file occurs when two or more files have been allocated the same cluster, which will corrupt all files saved to the same cluster. Lost clusters may also cause corrupt files; when a file is deleted from the computer's directory listing, but the File Allocation Table (FAT) still shows clusters allocated to that file, the clusters become "lost" and data which is saved to this cluster will show as "cross-linked," even if the directory listing has already been deleted.



                    Infected Files and Viruses

                    Viruses can delete files, infect the computer registry, change volume labels, mark sectors as bad on the drive, mark clusters as bad in the FAT, create cross-linked files or create new partitions on the disk drive. A virus can easily change how files are saved and read on a computer, causing corrupt files to occur even if no problem exists with a hard drive. Viruses can, for example, mark sectors as bad when they are functioning normally, and cause all files to become corrupt or inaccessible for the user in that sector.


                    System Crashes

                    System crashes can be caused by various factors on a computer system. Logical crashes (i.e., complete shut down, or the "Blue Screen of Death" for Windows users) occur when programs use conflicting memory, or when new hardware is corrupt. Programs are normally allocated memory from the system and cannot share a portion of memory; if one program accesses another program's allocated memory, a crash may occur. If programs using kernel memory (trusted programs, such as the operating aystem or hardware drivers) access another kernel program's memory, a system crash/shutdown will occur. In both cases, if a file is being saved, accessed or sometimes open, the file may become corrupt from a sudden shutdown.

                  • Re: Lost Named User CALS

                    We got the same problem. From one Day to another all assigned USER CALs are unassigned. We are able to see in the backups that the CalData.pgo was around 8 KB at 4 pm and around 4KB at 8 pm.


                    After we reassigned the USER CALs the CalData.pgo was around 8KB. The File was not deleted because the File has the original creation date.


                    We recovered the files vom 4 pm and 8 pm and send them to the Qlik Support.

                    • Re: Lost Named User CALS
                      Giuseppe Novello

                      Check if the PGO from C:\ProgramData\QlikTech\QlikViewServer and the one from the root folder are in sync, meaning check if their time stamp are the exactly the same ( 1 - 2 difference should be fine), if one has a big timestamp gap that means something got it hold of it and I agree what Ronnie describe above.

                      • Re: Lost Named User CALS

                        I got the Information from Qlik-Support, that named user cals could be lost if the QlikView-Server got out of Memory. In this case the QlikView-Server-process restarts and it occurs that the pgo-File won't be closed correct. In some cases the pgo-File get corrupted.