Restore for Nprinting database failed, please help

[b_garside]

We recently upgraded to 18.03 from 17.6 and lost our database. We need to restore it.

We shut down all the NPrinting services.  We are desperate if anyone knows how to do a restore or know what is causing the error please let us know.

https://help.qlik.com/en-US/nprinting/February2018/Content/DeployingQVNprinting/Restoring-Qlik-NPrin...

Qlik.Nprinting.Manager.exe restore -f D:\NprintingBackup\NP_Backup_20180228_ -p "C:\Program Files\NPrintingServer\pgsql\bin" --pg-password ##########

We get the following Error:

Failed to establish a connection to 'localhost'. ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:4992

Once I started the Repo Service it tried to restore but it would not finish do to an error in log.

Attached is the log it produced from Qlik.Nprinting.Manager.exe.

See attachments

The specified user was not found.‌

[JustinDallas]

Its complaining about not being able to find a file, but I'm not sure if this is supposed to be a Fatal error or not.

ERROR   FMCHQQV02P
0 0 0 0 0 0 0 0 Error processing command, trying to undo performed operations.?Error: Could not find f
ile 'D:\NprintingBackup\NP_Backup_20180228_'.

I'm not sure if that's important or not.  Have you tried restarting the system?  I know that's a hail mary, but even hail mary passes have a success rate greater than 0%.

[Chanty4u]

1. Qlik.Nprinting.Manager.exe backup -f C:\NPrintingBackups\NP_Backup.zip -p "C:\Program Files\NPrintingServer\pgsql\bin" --pg-password secret Password   [Repository password]

[mkelemen · Accepted solution]

Hi,

the connection error is indeed because of the repo service (pgsql) not running. You fixed that by starting the service.

The real error is most likely caused by .zip missing from the filename.

BR,

  Matus

[b_garside]

Yep that fixed that. Now we have to revert back to our older build 17.6 to restore our DB

[JustinDallas]

Donezo.

[nargesbrz]

Thanks, you saved me