How To: Restore the QVPR From Backup or Recreate the QVPR

[Andre_Sostizzo]

The QVPR may need to be restored from backup or re-initialized and recreated. 

The QlikView Publisher Repository (QVPR) stores tasks and triggers, as well as system-wide configuration. It should never be deleted on an active system. Backups are taken automatically and daily at 00:00.

By default, it is a set of XML files. These files are backed up as .zip files in %ProgramData%\QlikTech\ManagementService\QVPR\Backups.
 

Restoring when using the default .xml QVPR database:

1. Navigate to C:\ProgramData\QlikTech\ManagementService\QVPR\Backups and select the .zip file that is the most recent properly working QVPR
2. Copy and paste the zip file to C:\ProgramData\QlikTech\ManagementService 
3. Stop all QlikView services. (The minimum shutdown includes the QlikView Management Console and the QlikView Distribution Service). 
4. Rename the C:\ProgramData\QlikTech\ManagementService\QVPR folder to C:\ProgramData\QlikTech\ManagementService\QVPR_OLD 
5. Create a new QVPR folder in C:\ProgramData\QlikTech\ManagementService\
6. Unzip and extract the backup QVPR to the C:\ProgramData\QlikTech\ManagementService\QVPR directory, replacing the one you just renamed.
7. Restart the services and verify all functionality. 

Restoring when the QVPR has been moved to a SQL database:

1. No automatic backup will be done by QlikView when using an SQL database. The backup must be made available by the SQL server itself.
2. Stop all QlikView services. (The minimum shutdown includes the QlikView Management Console and the QlikView Distribution Service). 
3. Restore your SQL database backup.
4. Restart the services and verify all functionality. 

Resetting the QVPR

1. Stop all QlikView services. (The minimum shutdown includes the QlikView Management Console and the QlikView Distribution Service). 
2. Rename the C:\ProgramData\QlikTech\ManagementService\QVPR folder to C:\ProgramData\QlikTech\ManagementService\QVPR_OLD 
3. Create a new QVPR folder in C:\ProgramData\QlikTech\ManagementService\
4. Unzip and extract the backup QVPR to the C:\ProgramData\QlikTech\ManagementService\QVPR directory, replacing the one you just renamed.
5. Restart the services
6. This will automatically create a new QVPR folder in C:\ProgramData\QlikTech\ManagementService\
7. Verify all functionality
8. Manually repopulate all settings that were lost during the reset