Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Mar 30, 2021 5:36:20 AM
Mar 6, 2018 12:01:05 PM
When trying to open a dashboard in the desktop client user is receiving the following error message: The personal edition key file is missing or corrupt.
The document had been created in QlikView 11.20 and not saved in a 12.xx version of the client.
The desktop client is licensed, and not an actual personal edition.
Environment:
Format change for qvw files
Workaround is to check 'Yes, I want to continue', click 'Continue' and then save the file, Close the QV desktop and then re-open the QVW.
Since the desktop client is licensed, the warning about the 3 remaining attempts can be ignored.
If a large number of documents need to be resaved, the following Powershell script can be used. It will reloads all the files stored in a chosen folder.
Notes:
If the source files / data is not available then the reload will fail.
If the data source is not working / login is wrong it will fail.
The script is provided AS IT IS, with no warranty. Make sure to have a backup of the files in the chosen folder.
$logPath = ""
$failCount = 0
echo "Please select path to your QlikView binary."
echo "Example: C:\Program Files\QlikView"
echo "Press any key to continue..."
$x = $host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")
Add-Type -AssemblyName System.Windows.Forms
$FileBrowser = New-Object System.Windows.Forms.OpenFileDialog
$filebrowser.Filter = "qv.exe| qv.exe"
$FileBrowser.Title = "Please select QV.exe location:"
[void]$FileBrowser.ShowDialog()
$qvPath = $FileBrowser.FileName
clear
echo "Please select your QVW document path."
echo "Press any key to continue..."
$x = $host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")
Add-Type -AssemblyName System.Windows.Forms
$FolderBrowser = New-Object System.Windows.Forms.FolderBrowserDialog
$FolderBrowser.Description = "Please select your QVW document path..."
[void]$FolderBrowser.ShowDialog()
$docPath = $FolderBrowser.SelectedPath
$docList = Get-ChildItem -Path $docPath -Filter *qvw -Recurse | Select-Object -ExpandProperty FullName
clear
ForEach ($doc in $docList) {
Write-Host "Reloading $doc : " -ForegroundColor White -NoNewline
$reload = Start-Process $qvPath -ArgumentList "/R $doc" -Wait -PassThru
if($reload.ExitCode -gt 0){
$failCount = $failCount + 1
Write-Host "FAILED" -ForegroundColor Red
} else {
Write-Host "SUCCEEDED" -ForegroundColor Green
}
}
if($failCount -gt 0){
Write-Host "Reload batch complete. $failCount document(s) failed to reload." -ForegroundColor Red
} else {
Write-Host "Reload batch complete. No reload failures detected!" -ForegroundColor Green
}
echo "Press any key to close this window."
$x = $host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")
I have the same problem but have the QV personal edition i.e. the desktop client is not licensed. Will that create problems is i have more that 3 files to reopen?
Hello @danieldewet
QlikView Personal Edition can only open documents created by the same install. It is restricted to four recoveries (meaning, four documents which were not created by this specific install).
Once you have exhausted your recovery attempts, you will no longer be able to access documents that you have created and, from that point on, you will only be able to create new documents using your current QlikView installation.
All the best,
Sonja