Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Join us for live office hours! Q&A with Qlik on Dec 14 at 10am EST: Refining Reports and Visualizations

Restoring NPrinting Repository Database is failed with Errors while PROCESSING TOC

Daniel_Seo
Support
Support

Restoring NPrinting Repository Database is failed with Errors while PROCESSING TOC

The Nprinting repository had been backed up using the Qlik.Nprinting.Manager.exe and the zip file can be used to restore in a different NP Server.

After the installation of NPrinting, a restore using the Qlik.Nprinting.Manager.exe restore command fails.

Restoring/migrating NP Repository database in a different NP installation server fails while PROCESSING TOC.

 

Errors in CMD
NPrinting restoration failed.png
 
Errors in NPrinting_Manager.log

ERROR Qlik.NPrinting.Manager.Commands.Restore.RestoreDbCommand - Qlik.NPrinting.Manager 19.19.4.0 Qlik.NPrinting.Manager.Commands.Restore.RestoreDbCommand 20210909T022346.137+02:00 ERROR QLIKSERVER6 0 0 0 0 0 0 0 0 Process C:\Program Files\NPrintingServer\pgsql\bin\pg_restore.exe: pg_restore: [archiver (db)] Error while PROCESSING TOC:

ERROR Qlik.NPrinting.Manager.Commands.Restore.RestoreDbCommand - Qlik.NPrinting.Manager 19.19.4.0 Qlik.NPrinting.Manager.Commands.Restore.RestoreDbCommand 20210909T232759.033+02:00 ERROR QLIKSERVER6 0 0 0 0 0 0 0 0 Error trying to restore database backup

ERROR Qlik.NPrinting.Manager.Strategy.RestoreStrategy - Qlik.NPrinting.Manager 19.19.4.0 Qlik.NPrinting.Manager.Strategy.RestoreStrategy 20210909T232759.174+02:00 ERROR QLIKSERVER6 0 0 0 0 0 0 0 0 Error processing command, trying to undo performed operations Qlik.NPrinting.Manager.Commands.InstallationException: Error trying to restore database backup?? at Qlik.NPrinting.Manager.Commands.Restore.RestoreDbCommand.Do(RestoreCommandContext context) in C:\Jws\release-19.19.x-NOvyT9XXE\server\NPrinting\src\Manager\Commands\Restore\RestoreDbCommand.cs:line 94?? at Qlik.NPrinting.Manager.Commands.CompositeCommand`1.Do(T context) in C:\Jws\release-19.19.x-NOvyT9XXE\server\NPrinting\src\Manager\Commands\CompositeCommand.cs:line 32?? at Qlik.NPrinting.Manager.Strategy.RestoreStrategy.Launch(RestoreCommandContext context) in C:\Jws\release-19.19.x-NOvyT9XXE\server\NPrinting\src\Manager\Strategy\RestoreStrategy.cs:line 40?? ??=============?? at Qlik.NPrinting.Common.Utils.NPLog.Error(String message, Exception ex, NPLoggingContext loggingContext)?? at Qlik.NPrinting.Manager.Strategy.RestoreStrategy.Launch(RestoreCommandContext context) in C:\Jws\release-19.19.x-NOvyT9XXE\server\NPrinting\src\Manager\Strategy\RestoreStrategy.cs:line 40?? at Qlik.NPrinting.Manager.Starter.Main(String[] args) in C:\Jws\release-19.19.x-NOvyT9XXE\server\NPrinting\src\Manager\Starter.cs:line 116??=============??

 

 

Environment

 

Resolution

DO NOT MANUALLY CHANGE THE REPOSITORY,
Please take NP backup without the additional user or roles in NP respository, If there is any modification in NP Respository database. Please drop the user or roles first manaully and take a backup then the backup file can be restored with a different server (a different installation of NP) successfully.

Please note that Qlik Support always state to avoid to manually modify NP Repository. In the new installation it must add those two roles and after the restore should work.

Cause 

Based on the investigation of NP backup, the original PostgreSQL database (the NP repository) was manually modified by adding the new roles user_nprinting and user_dba.

DO NOT MANUALLY CHANGE THE REPOSITORY, it can damages NPrinting installation.

 

Related Content 

How to migrate NPrinting to a new environmen
How to BackUp and Restore Qlik NPrinting Repository Database from End to End

Labels (1)
Version history
Last update:
‎2021-09-22 08:51 AM
Updated by: