Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sep 22, 2021 8:51:24 AM
Sep 21, 2021 2:41:28 AM
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.
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??=============??
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.
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.
How to migrate NPrinting to a new environmen
How to BackUp and Restore Qlik NPrinting Repository Database from End to End