Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
bhelms
Creator
Creator

Lost Named User CALS

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?

2 Solutions

Accepted Solutions
Ronnie_Taborn
Support
Support

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.

View solution in original post

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.

Giuseppe Novello
Principal Technical Support Engineer @ Qlik

View solution in original post

12 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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?

-Rob

deepakk
Partner - Specialist III
Partner - Specialist III

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.

Deepak

Miguel_Angel_Baeyens

Hi,

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.

Miguel

erichshiino
Partner - Master
Partner - Master

Hi,

This is an old thread but I experienced a similar situation.

Is is possible to restore the .pgo from a backup?

They are located in two different folders. Should they be copies? Should I restore the backup from both folders?

Best Regards,

Erich

Not applicable

I will be Taking a couple of personal days Oct 31 & Nov 01. Will be returning to my clients site on Nov 04.

I will have limited access to emails during this time. I will contact you when I return if not an emergency.

Mark E. Mizner

John Daniel Associates

gardan
Contributor III
Contributor III

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.

Not applicable

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.

Not applicable

This can be due to anti-virus putting the PGO files in quarentine, it is worth checking virus definitions.

Ronnie_Taborn
Support
Support

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.