topic Re: Restore for Nprinting database failed, please help in Qlik NPrinting

Restore for Nprinting database failed, please help

b_garside — Wed, 25 Sep 2019 18:40:54 GMT

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-NPrinting-from-a-backup.htm

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.‌

Re: Restore for Nprinting database failed, please help

JustinDallas — Wed, 28 Feb 2018 21:22:11 GMT

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%.

Re: Restore for Nprinting database failed, please help

Chanty4u — Thu, 01 Mar 2018 05:26:49 GMT

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

Re: Restore for Nprinting database failed, please help

mkelemen — Thu, 01 Mar 2018 11:36:32 GMT

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

Re: Restore for Nprinting database failed, please help

b_garside — Thu, 01 Mar 2018 17:07:36 GMT

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

Re: Restore for Nprinting database failed, please help

JustinDallas — Sat, 10 Mar 2018 04:57:26 GMT

Donezo.

Re: Restore for Nprinting database failed, please help

nargesbrz — Mon, 26 Nov 2018 15:05:24 GMT

Thanks, you saved me