Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

b_garside
Valued Contributor

Restore for Nprinting database failed, please help

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.

1 Solution

Accepted Solutions
mkelemen
Contributor III

Re: Restore for Nprinting database failed, please help

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

6 Replies
JustinDallas
Valued Contributor

Re: Restore for Nprinting database failed, please help

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

sureshqv
Esteemed Contributor III

Re: Restore for Nprinting database failed, please help

  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
Contributor III

Re: Restore for Nprinting database failed, please help

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
Valued Contributor

Re: Restore for Nprinting database failed, please help

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

JustinDallas
Valued Contributor

Re: Restore for Nprinting database failed, please help

Donezo.

nargesbrz
New Contributor

Re: Restore for Nprinting database failed, please help

Thanks, you saved me

Community Browser