Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
bhelms
Contributor

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?

12 Replies

Re: Lost Named User CALS

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
Valued Contributor III

Re: Lost Named User CALS

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

Re: Lost Named User CALS

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

erich_shiino
Honored Contributor

Re: Lost Named User CALS

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

Re: Lost Named User CALS

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
New Contributor III

Re: Lost Named User CALS

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

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.

Not applicable

Re: Lost Named User CALS

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

Employee
Employee

Re: Lost Named User CALS

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.

Community Browser