NPrinting Web Console - Error trying to open the page

[_jespers_]

I have an issue when I try to access Admin > Settings > Authentication.

I get an error message saying "Error trying to open the page". There are no issues trying to open all the other tabs, it is just the Authentication tab that get this error message.

Any idea what can cause this issue?

[Ruggero_Piccoli]

Hi,

Are you logged in with a user with Administrator role?

Did you checked the webengine.log file?

Best Regards,

Ruggero

[_jespers_]

Hi, 

Yes, I am logged in with a user that has the Administrator role.

I checked the logfile and it throws an exception when I try to reach the page:

Exception serving the request http://nameofserver:4996/npe/settings/authentication/?count=-1&orderBy=name&page=1	
NHibernate.Exceptions.GenericADOException: could not execute query↵↓[ select jwtconfigu0_.Id as id1_36_, jwtconfigu0_.certificate as certificate2_36_, jwtconfigu0_.strategy as strategy3_36_, jwtconfigu0_.user_id_attribute as user4_36_, jwtconfigu0_.user_directory_attribute as user5_36_, jwtconfigu0_.email_attribute as email6_36_, jwtconfigu0_.audience as audience7_36_ from jwt_configuration jwtconfigu0_ limit 1 ]↵↓[SQL: select jwtconfigu0_.Id as id1_36_, jwtconfigu0_.certificate as certificate2_36_, jwtconfigu0_.strategy as strategy3_36_, jwtconfigu0_.user_id_attribute as user4_36_, jwtconfigu0_.user_directory_attribute as user5_36_, jwtconfigu0_.email_attribute as email6_36_, jwtconfigu0_.audience as audience7_36_ from jwt_configuration jwtconfigu0_ limit 1]

Any idea what this means?

Regards

Jesper

[Frank_S · Accepted solution]

@_jespers_

Have you secured your NPrinting server with 3rd party certificates?
If so it is possible that you have expired certificates and those (if that is the case) will need to be updated.

• https://community.qlik.com/t5/Knowledge/NPrinting-Error-Trying-to-Open-Page-Certificate-Expired/ta-p...

or

If an incorrect older NP database has been restored over top a newer version of NPrinting this same error may appear.

• https://community.qlik.com/t5/Knowledge/Identify-wrong-NPrinting-database-version-restored-to-NPrint...

Please check both of the above.

Kind regards...

[Ruggero_Piccoli]

Hi,

Did you restored a backup of an older version than the one installed?

If not please open a support ticket, include the link to this conversation and the complete log files. We have to check the Repository.

Best Regards,

Ruggero

[_jespers_]

Hi,

It turned out that we got the issue with the wrong database version. Solved it by upgrading to the latest version.

Thank you!

[Ruggero_Piccoli]

Thanks for sharing the solution