Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

NPrinting duplicate roles cause severely diminished NPrinting performance

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Frank_S
Support
Support

NPrinting duplicate roles cause severely diminished NPrinting performance

Last Update:

Jun 21, 2021 5:31:03 PM

Updated By:

Frank_S

Created date:

Sep 5, 2019 3:24:26 PM

Description

  • Recently, performance when accessing NPrinting has been severely diminished
  • Also may experience the error message when accessing the NP web console "Error when trying to open page" message
  • No changes to the environment have taken place.

Environment: 

  • Qlik NPrinting June 2019

 

Cause:

  • The problem is the excessively high numbers of rows into the NPrinting postgres role_recipient table

 

Resolution

(Note: Before proceeding below, we recommend performing this steps in the presence of a Qlik Support representative)

Diagnosis:

  • Stop all NPrinting Engine, Scheduler, and Web Engine services. (only these three services)
  • Connect to the NPrinting Database via PGAdmin. If PGdmin4, go to
"C:\Program Files\NPrintingServer\pgsql\pgAdmin 4\bin" 
  • run pgamdin4.exe found in the 'bin' folder
  • Connect to the 'NPrinting' database using the postgres superuser password used when first installing NPrinting and port 4992
  • Open a Query Window in Postrgre
  • To detect the current numbers of rows (including duplicates) of the role_recipient table, insert:
SELECT COUNT(*) FROM role_recipient;
  • If you find millions of records, this is in most cases the cause of the issue where NPrinting performance is severely degraded.
  • Use the following to check the number of actual rows that should appear (non duplicates)
SELECT COUNT(*) FROM (SELECT DISTINCT * FROM role_recipient) t;

 

How to remove duplicate roles:

CREATE TABLE role_recipient_tmp (recipient_id uuid, role_id uuid);
INSERT INTO role_recipient_tmp (recipient_id, role_id) SELECT DISTINCT recipient_id, role_id FROM role_recipient;
TRUNCATE TABLE role_recipient;
INSERT INTO role_recipient (recipient_id, role_id) SELECT recipient_id, role_id FROM role_recipient_tmp;
DROP TABLE role_recipient_tmp;
  • Allow query above to complete processing
  • Start the NPrinting Web Engine and Scheduler services

 

Solution:

  • Upgrade to the November 2019 Release of NPrinting

  • If Upgrading from versions of NPrinting Prior to Nov. 2019, it may be necessary to run the above script to remove duplicates. Duplicates already present are NOT removed simply by upgrading and therefore would need to be removed manually. See How to remove duplicate roles section above.

 

Internal ID:

  • OP-8861
Contributors
Version history
Last update:
‎2021-06-21 05:31 PM
Updated by: