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)
- Troubleshooting
- Vizlib Logs - and where to find them
- Setting VZB_Server_Url after updating any Collaboration extension files
- Installation error - Windows Service doesn't automatically start
- Upgrade error - When updating Vizlib Server installer does not fully stop Vizlib services
- Page loading error - Browser doesn't display page
- Password entry error - PFX Certificate
- Configuration error - Vizlib Server started in Safe Mode
- Unable to connect to Qlik Sense Services
- Configuration error - Could not load Qlik Sense Certificate, error details: Error: Error: Invalid IV length
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 = '*'
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
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.
Figure 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.
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:
- Log in to the VMC as an Administrator
- 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.
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.
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:
- Log in to the VMC as an Administrator
- Click System Settings
- Click Logs and set to 'Debug' >
- 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.
Figure 6: Amending the logging level
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
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.
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.
Figure 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).
Figure 11: Extension Server Url VMC
You can also enter the property manually on each extension in the QMC (Figure 11).
Figure 12: VZB_Server_Url QMC Added
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.
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?)
- Cancel the update
- Go to Services and verify that both Vizlib services are stopped
- Open Task Manager and go to the Details tab
- Try to end task vizlib-server.exe and see if it automatically starts again.
If it starts again, continue to the next step - Look for node.exe processes which are running as user SYSTEM.
Typically you will have two processes like that created by the Vizlib-Server. - Right-click, select Properties, and inside Location verify that they relate to VizlibServer.
- End all of them and repeat step 4 if vizlib-server is still running.
- At this point, you should be able to reattempt the update.
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.
Figure 13: Browser error
Please wait another minute, and refresh the page in your browser. If it's correct the VMC login displays.
Figure 14: VMC login page
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:
- Open the VMC at http://localhost:1980/vmc
- the Logs Browser tab and
- Filter the error logs to check for any possible causes.
To correct this error:
- Open the VMC at http://localhost:1980/vmc
- From the System settings drop-down, select Server
- In the field 'specify PFX file path > passphrase field, enter the required password
- Click Save.
- Try to log in again.
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.
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.
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."
Figure 17: VMC Dashboard showing the error
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.
Figure 19: VMC System settings > Qlik Sense