Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
We have a problem where after a Restart of the Qlikview Services or a Server Reboot, all Named CALs and Document CALs are wiped out.
The Licenses tab in QMC shows:
- Named User CALs: '0' assigned ('X' in license)
- Document CALs: '0' assigned ('Y' in license)
This issue has started occurring since only 2 days, and we had to assign CALs all over again to the users of each document whenever we had to restart the services.
A few details of our system:
QMS@qlikviewserver | |||
Product Information | |||
Product name | QMS Backend Core x64 | ||
Client Build Number | 11.20.12664.0 | ||
Target Platform | x64 | ||
Publisher License Key | No License | ||
Service authentication | AD groups | ||
Machine Information | |||
Computer Name | QLIKVIEWSERVER | ||
Operating System Version | Win32_OperatingSystem=@ X64 (Microsoft Windows NT 6.1.7600.0) | ||
.NET Version | 4.0.30319.17929 | ||
Physical Memory | 196562Mb | ||
Available Memory | 111031Mb |
QVS@qlikviewserver at qvp://172.16.0.12/ | |||
Server System Info | |||
Operating System | Windows Server 2008 R2 Enterprise (64 bit edition) | ||
Operating System Version | 6.1.7600 | ||
Wow64 mode | Not using Wow64 | ||
QlikTech Product | QlikViewServer 64-bit Edition (x64) | ||
Product Version | 11.20.12664.0 | ||
Server License Key | XXXX XXXX XXXX XXXX | ||
CPU Target | x64 | ||
Country | 1 United States United States | ||
Language | 0409 English (United States) English | ||
Server Collaboration | Disabled | ||
Number of CPUs | 24 | ||
CPU 0 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 1 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 2 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 3 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 4 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 5 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 6 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 7 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 8 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 9 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 10 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 11 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 12 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 13 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 14 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 15 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 16 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 17 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 18 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 19 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 20 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 21 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 22 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
CPU 23 | Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz 2000MHz | ||
Physical RAM(MB) | 196562 | ||
VMCommitted(MB) | 80169 | ||
VMAllocated(MB) | 94108 | ||
VMFree(MB) | 111031 | ||
VMLargestFreeBlock(MB) | 111031 | ||
Local Time | 2016-06-30 20:37 | ||
GMT Time | 2016-06-30 15:07 |
Any help on this issue is appreciated or point us to a direction where we may get a solution to this problem.
Thanks in advance.
Regards,
Avishkar
A number of bug fixes applied to later SRs are related to disappearing CALs, even one that drops CALs after a server reboot by corrupting the .pgo file and was fixed in SR13. Time for an upgrade from SR9 to SR14?
Peter
Hi avishkarm,
We also got similar issue before. In our case the .pgo files (BorrowedCalData.pgo, CalData.pgo, etc.pgo) were out of sync. Check if these files have similar timestamp in you server. They are located at the root and qlikview server folder.
I did the followings steps.
1. Stop qlikview services.
2. Back up all pgo files from both locations (root and qlikview server)
3. Delete pgo files then restart services.
Once services are restarted new .pgo files were generated. You have to assigned doc cal and name cals to your users again.
A good discussion about this can be read here Assigned Cals are getting deleted on the qlikview server
Hope this help.
A number of bug fixes applied to later SRs are related to disappearing CALs, even one that drops CALs after a server reboot by corrupting the .pgo file and was fixed in SR13. Time for an upgrade from SR9 to SR14?
Peter
Hi avishkarm,
We also got similar issue before. In our case the .pgo files (BorrowedCalData.pgo, CalData.pgo, etc.pgo) were out of sync. Check if these files have similar timestamp in you server. They are located at the root and qlikview server folder.
I did the followings steps.
1. Stop qlikview services.
2. Back up all pgo files from both locations (root and qlikview server)
3. Delete pgo files then restart services.
Once services are restarted new .pgo files were generated. You have to assigned doc cal and name cals to your users again.
A good discussion about this can be read here Assigned Cals are getting deleted on the qlikview server
Hope this help.
Hi avishkam
Do you have an antivirus on the server? if you so exclude the antivirus scanning from ProgramData\Qlikview, because other than deleting them also it locks the file from writing and reading, specially the BorrowCalData.pgo gets out of sync from either root folder copy and Qlikview\QlikviewServer folder. So when one of the PGOs are out of sync, the assignment CALs that you see on the QMC reminds in memory; however, when you reboot the machine, that memory gets cleared and CALs assignments are gone, because the QMC cannot read those PGOs anymore.
The default folders to store the pgo files are the followings:
o C:\ProgramData\QlikTech\QlikViewServer (Backup files of pgo files. Is a copy of Documents)
o C:\ProgramData\QlikTech\Documents (Files that are using by the console in real time)
After exclude the antivirus scanning follow this steps:
1.- Stop QlikView Server Services.
2.- Delete pgo files from these folders.
3.- Start QlikView Server Services.
4.- Assign CALs all over again to the users
Regards
Joseph
I recommend that you upgrade. Do your PGO files have the same time stamp? Do you have any Chinese characters on the PGO files?
In addition to the above comments I'd recommend you don't use SR14 but go to SR15.
SR14 had a bug that can cause the server to restart, which was fixed in SR15 (QV 11.2).