Description of the Problem:
- NPrinting is down and cannot normally start the NPrinting Messaging service and
- Subsequently the NP Scheduler service fails to start as well.
- This results in most NPrinting systems from operating as expected including report distribution and previewing.
Applicable Environments:
- September 2018 SR 2 and older versions only.
- Do not use this with newer versions of NPrinting. For newer versions, refer to https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Troubleshooting/Qlik-NPrinting-Messa...
! This solution is only applicable to September 2018 SR 2 and older versions only. Do NOT use this solution with November 2018 and later/newer versions of NPrinting as this will break NPrinting entirely.
What has caused this problem?
- Corruption has occurred in NPrinting related database files, perhaps as a result of an overly aggressive antivirus software. See Qlik NPrinting Server and Designer Anti Virus Folder Exclusions
Result: The folder corrupted is in the following location:
- C:\ProgramData\NPrinting\RabbitMQ\db\rabbit@&computername%-mnesia
Resolution:
- Upgrading to a supported version of NPrinting should resolve the issue
- https://community.qlik.com/t5/Knowledge-Base/Qlik-NPrinting-Upgrade-Install-from-NPrinting-17-3-x-or...
Diagnose
- Using an Administrator Command Prompt, navigate to C:\Program Files\NPrintingServer\rabbitmq_server-3.x.x\sbin
Note: The path will vary depending on which version of NPrinting/Rabbitserver is installed. To be sure, simply navigate to "C:\Program Files\NPrintingServer" and check the folder name for the Rabbit server in order to know the correct full path to use.
- Type rabbitmq-server.bat start
- This may prompt the server startup and exit with a failure with messages such as “not_a_dets_file” or “not a dets file” referring to files in C:\ProgramData\NPrinting\RabbitMQ\db\
(Note: Before proceeding, make a backup copy of the NPrinting database)
To resolve the issue:
- 1. Stop all NPrinting services then navigate to C:\ProgramData\NPrinting\RabbitMQ\db\
- 2. Rename the folder: rabbit@&computername% to rabbit@&computername%.old
for example: rename the "rabbit@QlikServer3-mnesia" folder (This will enable the recreation of this folder on the NP server in turn repairing the rabbit database)
- 3. Go to the Windows 'Services' panel and start all NPrinting services. Notice that a new db subfolder is generated
- 4. Open a command prompt and navigate to C:\Program Files\NPrintingServer\rabbitmq_server-3.5.7\sbin (determine the exact path as per the 'Diagnosis' section of this article)
- 5. Then type into this command prompt: rabbitmqctl.bat list_permissions
- 6. If it is working normally, you will see:
Note: if your NPrinting installation began as NP 17.3 or lower, you may also need to repair the rabbit "remote user" account associated with the rabbit messaging service
