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:
! 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?
Result: The folder corrupted is in the following location:
- C:\ProgramData\NPrinting\RabbitMQ\db\rabbit@&computername%-mnesia
Resolution:
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