Vizlib Home Try Vizlib
Welcome
Login

Vizlib Server Troubleshooting - Known Issues / FAQ

When you're working with Vizlib Server it's important to be clear about what you can and can't do.


We've collected any known issues and limitations and listed them in this article for you, along with any answers to any other questions you might need.




TABLE OF CONTENTS




Frequently asked questions (FAQ)


Which Qlik Sense Licenses work with Vizlib Server?


Vizlib Server supports Qlik Sense Professional, Analyzer, and Analyzer Capacity Licenses.


Serverless access (e.g. using Vizlib Writeback Table without Vizlib Server) is limited to Qlik Sense Professional licenses only.

The articles on VMC User Roles and Security Rules; contain instructions designed to work with all supported license types. 


Enabling remote access to the PostgresSQL database


By default, PostgreSQL allows listening for the localhost connection only. It does not allow a remote TCP/IP connection from remote hosts. 


If Vizlib Server is installed on the Central Node of Qlik Sense, it's possible to create a data connection from Qlik Sense and load the data stored in the database that is installed with Vizlib Server. If Vizlib Server is installed on another node or a dedicated server it is not possible unless the Postgres config files are updated to allow remote access.


1. Change the listening address in the postgresql.conf file.


By default, PostgreSQL allows listening for the localhost connection. It does not allow a remote TCP/IP connection. To allow a remote TCP/IP connection, add the following entry to the C:\ProgramData\Vizlib\BackendServices\db\postgres14\postgresql.conf file:

listen_addresses = '*'


postgresql.conf with listen_addresses='*'

Figure 1: postgresql.conf with listen_addresses='*'


If you do not want to allow to listen to all addresses, a comma-separated list of addresses is also possible.


2. Add a client authentication entry to the pg_hba.conf file.


By default, PostgreSQL accepts connections only from the local host. It refuses remote connections. This is controlled by applying an access control rule that allows a user to log in from an IP address after providing a valid password (the md5 keyword). 

To accept a remote connection, add the following entries to the C:\ProgramData\Vizlib\BackendServices\db\postgres14\ pg_hba.conf file.


host all all 0.0.0.0/0 md5

host all all ::0/0 md5


pg_hba.conf modified to allow remote access

Figure 2: pg_hba.conf modified to allow remote access


Find out more on how to allow only certain IP ranges in the office Postgres documentation here.


3. Test the remote connection.


Stop the VizlibServer service, once it stopped, restart the VizlibServerDatabaseService. When it's running start the VizlibServer service again.


List of Vizlib Server ServicesFigure 3: List of Vizlib Server Services


Make sure it's possible to sign in to the VMC. Test the connection to the database from a remote host.


When storing production data in the PostgresSQL that is installed with Vizlib Server, make sure it's being backup on a regular schedule and the server is maintained. Find out more in this article.


Back to Contents



Troubleshooting


Vizlib Logs - and where to find them

When you're actively troubleshooting and need to view the logs as part of the investigation, the logs are viewed in the Vizlib Management Console (VMC).  


To view the logs: 

  1. Log in to the VMC as an Administrator
  2. Click Logs Browser, the current day's logs display by default.


The 'Filter logs' - button is only needed when you're actively troubleshooting, as the logs are refreshed when you click to view the Logs Browser, and when you Filter the logs.


The logs displayed are only for the date selected. 


Use the 'Select Log' field to choose logs from a specific date, or use the navigation at the bottom right to set how many logs display, and navigate to previous dates. 


Logs Browser in the VMC

Figure 4: Logs Browser in the VMC


Log level types

Filter the logs by log 'levels' - types - Error, Warning, Info, Debug, Silly (If you have an error,  but it's not displayed in your logs, you could temporarily amend the default log level to display more logs.


Vizlib Server log level types

Figure 5: Vizlib Server log level types


Setting your log level to Debug


Setting your log level to 'Debug' provides you with more detailed logs - but also fills up the assigned disk space. Amend the default log level by:

  1. Log in to the VMC as an Administrator
  2. Click System Settings
  3. Click Logs and set to 'Debug' > 
  4. Click Save Changes. 


Please note: We do not recommend that you leave log capture at the Debug level. We suggest that 'Info' level type is kept as your default.


If you need to use less space on the server for logs, use the 'Warning' log level.


Vizlib server saves logs on the C: drive, so you can search for the .PM2 folder to view the logs, using the Windows File Explorer as well. 


Amending the logging level

Figure 6: Amending the logging level


Logs error example

Figure 7: Logs error example


Can't connect to the VMC - viewing logs on the drive


If you can't connect to the VMS, you can view the Vizlib server logs here: C:\ProgramData\Vizlib\BackendServices\log 


Viewing logs on the server

Figure 8: Viewing logs on the server


Check the .PM2 folder (C:\Program Files\VizlibServer.pm2\logs )  when Vizlib Server VMC is not responding because the server is not starting or is constantly restarting.


Viewing logs when the VMC is not available

Figure 9: Viewing logs when the VMC is not available


Setting VZB_Server_Url after updating any Collaboration extension files


This issue relates to users updating their extension files for Vizlib Teamwork,  Finance, and Writeback products.


If you're updating any of these extensions in the Qlik Management Console (QMC), the Extension Server URL custom property VZB_Server_Url (Figure 4) needs to be set after the update completes. 


VZB_Server_Url QMC EmptyFigure 10: VZB_Server_Url QMC Empty


If you restart Vizlib Server after the update in the Vizlib Management Console (VMC), the Extension Server Url custom property will be set automatically (Figure 10). 


Extension Server URL in VMCFigure 11: Extension Server Url VMC


You can also enter the property manually on each extension in the QMC (Figure 11). 


Vizlib Server URL added in QMC Figure 12: VZB_Server_Url QMC Added


Back to Contents


Installation error - Windows Service doesn't automatically start


Very rarely, the Vizlib Server Windows Service gets created during the installation but is not automatically started. 

If you encounter issues opening the VMC, double-check if Vizlib Server is running using Task Manager. If not, start the service manually.


Back to Contents


Upgrade error - When updating Vizlib Server installer does not fully stop Vizlib services


During the Vizlib Server upgrade process, normally the Vizlib services stop automatically. A warning appears that Vizlib services have not stopped. Please follow the steps below to stop the Vizlib Services. 

(error message image?)

  1. Cancel the update
  2. Go to Services and verify that both Vizlib services are stopped
  3. Open Task Manager and go to the Details tab
  4. Try to end task vizlib-server.exe and see if it automatically starts again.
    If it starts again, continue to the next step
  5. Look for node.exe processes which are running as user SYSTEM.
    Typically you will have two processes like that created by the Vizlib-Server. 
  6. Right-click, select Properties, and inside Location verify that they relate to VizlibServer. 
  7. End all of them and repeat step 4 if vizlib-server is still running.
  8. At this point, you should be able to reattempt the update.


Back to Contents


Page loading error - Browser doesn't display page


Occasionally, for slower servers, the browser opens before Vizlib Server is fully initialized and the page is not loaded properly. 


Page_load_error_Vizlib_Server

Figure 13: Browser error 


Please wait another minute, and refresh the page in your browser. If it's correct the VMC login displays.


VMC_login_page_Vizlib_Management_Console

Figure 14: VMC login page


Back to Contents


Password entry error - PFX Certificate 


If during your installation of Vizlib Server, you specified the wrong password for the PFX certificate the page does not load properly over HTTPS and Vizlib Server falls back to the HTTP protocol. 


To confirm the error: 

  1. Open the VMC at http://localhost:1980/vmc
  2.  the Logs Browser tab and 
  3. Filter the error logs to check for any possible causes.


To correct this error: 

  1. Open the VMC at http://localhost:1980/vmc
  2. From the System settings drop-down, select Server 
  3. In the field 'specify PFX file path > passphrase field, enter the required password
  4. Click Save. 
  5. Try to log in again. 


Back to Contents


Configuration error - Vizlib Server started in Safe Mode


If you return an error stating Vizlib Server has been started in Safe Mode (Figure 15) it means it is not connected to the database holding the configuration details. 


Figure 15: Safe Mode


Potential causes are the database:

  • Needs to be restarted, which should start the Vizlib Server database service.
  • User credentials have been changed and need to be checked.
  • Port is blocked, or not running on the port used in the configuration. 


Back to Contents


Unable to connect to Qlik Sense Services


If the connection drops between Vizlib Server and any of the ports hosting Qlik Sense services (4747, 4243, 4242 and 443) an error is displayed in the VMC Dashboard (Figure 16).


Figure 16: QRS connection error example


The connection can be lost after a change to network communication (e.g. modification of a firewall rule) or if the Qlik Sense services are stopped or become unresponsive. 


To resolve the error, check which ports are affected and re-start the Qlik Sense service if it has stopped, then re-start Vizlib Server services. The connection should be restored. 


Back to Contents



Configuration error - Could not load Qlik Sense Certificate, error details: Error: Error: Invalid IV length


Customers may see the error: "[enigmaService][checkQesConnection] failwith error: Could not load Qlik Sense Certificate, error details: Error: Error: Invalid IV length."


Could not load Qlik Sense Certificate, error details: Error: Error: Invalid IV length

Figure 17: VMC Dashboard showing the error



Vizlib Server Check Browser Logs.

Figure 18: Logs Browser shows the full error message


The root cause of the error is the wrong type of Qlik Sense node certificate. Please use PEM type in this case including a private key. For more information please see Vizlib Server Guides - Multi-node Configuration


use PEM type certificate

Figure 19: VMC System settings > Qlik Sense




Back to Contents

V
Vizlib is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.