Vizlib Server - Changelog

• [CLB-4453]: Vizlib Writeback - Unable to change created at audit column format when using BigQuery destination

• [CLB-4413]: Vizlib Server Cloud - Using space access to build security rules

• [CLB-4439]: Vizlib Server - Unable to login into VMC using Virtual Proxy

• [CLB-4406]: Possibility to disable VMC admin login option from not whitelisted IP addresses
• [CLB-4427]: [Vizlib Server for Qlik Cloud] Performance improvements when executing application reloads

• [CLB-4415]: Error "Socket has been disconnected" when writeback large data sets

• [CLB-2787]: Vizlib Management Console - Logs Browser - Audit Logs
• [CLB-4316]: Vizlib Server - Logs Browser Improvements 
• [CLB-3894]: Vizlib Server for Qlik SaaS on Windows
  Until this point, in order to run Vizlib Server with Qlik SaaS, the tenant had to be configured with a docker container. Starting from this version we also provide a Windows installer, which might be more convenient for customers who are more accustomed to Windows environments. The new option to download is available from our User Portal.
  
  
  
  
• [CLB-4284]: Vizlib Management Console - Shared access to security rules with VMC Admin level

• [CLB-4228]: Vizlib Management Console - Timeout error toast when signing in
• [CLB-4377]: Vizlib Server - issues with generating Finance Report Scheduler

• [CLB-4387]: Vizlib Server for Qlik Cloud - Writeback Table gets stuck after app reload since version 4.12.1

• [CLB-4256]: Postgres upgrade to version 14.8
• [CLB-4264]: Improved license management for collaboration / finance in Vizlib Management Console
• [CLB-4223]: New Vizlib Management Console Dashboard

• [CLB-4350]: Vizlib Server for Qlik Cloud - Error when executing writeback

• [CLB-4184]: Performance improvements for Writeback on Qlik's multi node environments 
• [CLB-4327]: Add option to deactivate vmc_admin account

•  [CLB-3963]: Writeback Destinations - Limiting apps and sheets   
•  [CLB-3801]: Improved Permission checks in Vizlib Management Console  
•  [CLB-3853]: Improved Vizlib Management Console Dashboard  
•  [CLB-4251]: Vizlib Server - Custom TLS Ciphers   
•  [CLB-3914]: Finance Comments on Qlik Cloud with Vizlib Server  
•  [CLB-4115]: Writeback - Rest destination - support for untrusted certificates  
•  [CLB-4138]: Vizlib Server for Qlik Cloud - User Roles search  
•  [CLB-4262]: Node upgrade to version 16.16.0  

•  [CLB-3854]: Finance Report Scheduler - report in constant 'executing schedule' phase with errors in logs  
•  [CLB-4224]: Vizlib Server - Issues with time-zone info when using Ms Sql database  
•  [CLB-4293]: Vizlib Server for Qlik Cloud- transferring ownership for VMC writeback destination timeout  

•  [CLB-4238]: Vizlib Server - Not possible to put a reverse proxy URL in Extension server URL field  

•  [CLB-4214]: Vizlib Server for Qlik Cloud - Failed to get the API key error message (403) when logging in to Vizlib Management Console  

•  [CLB-3998]: Snowflake integration form invalidation bug  
•  [CLB-4084]: Validation fixes for creating SQL Integrations when using connection string option  
•  [CLB-4022]: Teamwork: Changes made to workflows are not persisted  

•  [CLB-4207]: Snowflake - Timeout setting
  We added new setting for Snowflake Integrations to adjust the timeout value when connecting to Snowflake API. This will help some users to establish connection when using slower networks.
  
  - [CLB-4208]: Postgres SSL certs paths are not exported in config  

•  [CLB-4139]: Vizlib Server: Issues with Writeback destinations screen after upgrade from 4.8.x  

•  [CLB-4121]: Vizlib Management Console - Destinations are not loading after upgrading to v4.9.0  

•  [CLB-3831]: Scheduled Task Destination Locking
  This feature is useful in Writeback scenarios where an application used is being reloaded frequently by a Qlik Task on a scheduled basis - e.g. because data is fed from an external datastore every hour or even more often. The feature will automatically lock the Writeback Destination from being used by end users for the defined amount of time before the scheduled task starts. This prevents unexpected errors from being thrown when both the Writeback user and a QMC Task make an attempt to reload the same application.
  
  
   
•  [CLB-3979]: Enable SSL for postgres databases
  We added new option to authenticate to Postgres database, either one used by Vizlib Server to store its configuration or another instance used to store your Teamwork comments or Writeback data.
  
   

•  [CLB-4041]: Vizlib Server - Extension server URL changed automatically after server restart
  The extension server URL would change automatically after restart of Vizlib Server. That is fixed and we also improved the logging to be able to better track similar issues.
  
   
•  [CLB-4043]: Qlik Cloud - Oauth window issue
  The Oauth window will now appear only once during user session lifetime. (Previously it could pop up multiple times.)
  
   
•  [CLB-4089]: Cloud - Destinations are not shown
  In some cases destinations were not loaded and shown in the extension.
  
   
•  [CLB-4098]: Qlik Cloud - wrong API key used when Qlik user has a root admin role.
  There was an issue that users with root admin role wasn't able to connect to Writeback Destinations created by them. They had to either have content admin permission, or the destination had to be created as a server root user.   

•  [CLB-4054]: Logs Browser Improvements [Breaking Changes]  

•  [CLB-4064]: Issues when using Safe Mode without activated license  

•  [CLB-4049]: Vizlib Server: Issues with changing certificate in VMC
  Some customers might have issues while changing their certificates, issue is resolved now.  

•  [CLB-4046]: Vizlib Server - health check module - extensions not able to connect to Vizlib Server
   After upgrade to v4.8.0 for some customers Collaboration extensions reported an issue related with certificate, which was a false positive. We fixed this case.   

•  [CLB-3074]: [Qlik Cloud] Finance Report Scheduler
  We integrated the Finance Report Scheduler feature for our customers who are using Qlik Cloud.  
•  [CLB-3511]: [Qlik Cloud] Writeback - Cloud content admins personal API keys  
•  [CLB-3860]: Writeback - Snowflake keypairs  
•  [CLB-3874]: [Qlik Cloud] Writeback - Cloud automations improvements for Input Form [BREAKING CHANGE]
  We modified how writeback data is being sent to Qlik's automation API, to include custom payload schemas. Automations created with prior versions of Vizlib Server might have to be altered to work with the new payload structure. Easily integrate with various APIs and build sophisticated conditions based on the payload structure.  
•  [CLB-3701]: Improved connection error messages  

•  [CLB-3961]: Cloud: Error in adding Oracle Integration  
•  [CLB-3813]: SQL Writeback: When Columns are Empty, you get an Error during SQL writeback  
•  [CLB-4034]: Cloud: Error 400 while setting up Qlik Cloud in Vizlib Server Cloud VMC  

•  [CLB-4017]: Qlik Cloud - Writeback app reload does not work
  Fix for a bug, that was introduced in version 4.7.0, which was preventing to trigger app reloads appropriately in Qlik Cloud.  

•  [CLB-3988]: Docker compose setup script changes - Qlik Cloud sign-in [BREAKING CHANGE]  
•  [CLB-3916]: Writeback - Improvements to queue handling when multiple users write to the destination at the same time  

•  [CLB-3891]: New option for dynamic tags - Sheet ID  
•  [CLB-3890]: Simplified access to VMC when using only one virtual proxy  
•  [CLB-3877]: Vizlib Server - Users section improvements  

•  [CLB-3855]: Finance Report Scheduler gives error "Cannot read property 'qText' of undefined"   
•  [CLB-3913]: Issues with writeback when using Timestamp column.  

•  [CLB-3869]: Improvements to REST Payload Schema Editor  

•  [CLB-3627]: [Enterprise & Cloud] Silent installation improvements  
•  [CLB-3575]: Logs Browser access for Content Admins  

•  [CLB-3350]: Server restart improvement  
•  [CLB-3778]: Error: Http auth controller refreshToken failed with error: Unauthorized inside Logs Browser  
•  [CLB-3808] & [CLB-3772] : Vizlib Silent installation  
•  [CLB-3779]: Snowflake Integration with proxy issues  
•  [CLB-3822]: Config import doesn't work  
•  [CLB-3849]: Teams Integration not working while using proxy  
•  [CLB-3745]: Writeback Destinations - Integration Error Although Destination set to Public  
•  [CLB-3646]: BigQuery connector error (lost file bigQuery-1.json) after upgrade VL Server to 4.2.0  

•  [CLB-3810]: Vizlib Server: Websocket error when connecting from Writeback extension.  

•  [CLB-3816]:  Upgrade from versions < 4.0.0 issues  

• [CLB-3192]: [Writeback] Search in Writeback Audit is case sensitive
• [CLB-3347]: [Writeback] Dynamic tags - Year tag is broken
• [CLB-3509]: [Writeback] Some QVD data sources were not filtered out when creating destinations

Bug Fixes (Enterprise Version Only):

• [CLB-3721]: [VMC] - Finance Report Schedules - unable to create new reports or edit existing ones 

  Version 4.3.0 had a defect that prevented new finance report schedules from being created. It was also not possible to edit existing ones.

New Features (Collaboration Enterprise Customers Only): 

• [CLB-3292]: [Writeback] Loop and Reduce - with loop values from source app dimension  
  In the initial version, when defining the Loop and Reduce tasks, users had to enter (or paste) loop values manually. It is now possible to select a dimension from which those values will be automatically fetched. This will be particularly useful when needing to loop through many values. 
• [CLB-3716]: [Server for SaaS] Cloud automations - API update after Qlik release 
  Recently Qlik has officially released the official version of the automations API, and some changes were required on our side. 
• [CLB-3348]: [Writeback] Destination time zone
  This feature allows you to specify the time zone in which dates are going to be saved. The current implementation was assuming that all dates with time were written in GMT+0, which could cause issues for some users. A new setting allows you to specify that saved dates are saved according to the destination (e.g. Postgres database) time settings. The setting is available under Default Settings inside Vizlib Management Console and applies to all Destinations configured.
• [CLB-3455]: Installer improvements
  We added several smaller improvements to the installer, including better port number validation, check for provided password strength, and link updates.  

Bug Fixes (Qlik Cloud Version Only):

• [CLB-3601]: Issues while logging in to the VMC by using OAuth

  When the token expired, it was no longer possible to log in. The issue was visible when signing in with Qlik Cloud and when trying to reaccess it after the session had ended.
  

• [CLB-3601]: Config import is not working

  Due to issues with the validation of the API key, imports of configurations did not work.

New Features (Collaboration Enterprise Customers Only): 

• [CLB-2884]: MSSQL Integration - Windows Authentication support.
  Allows to connect to MSSQL databases with Windows Accounts.
• [CLB-3238]: Finance Report Scheduler.
  Schedule delivery of Finance Report to the right audience with an automatic task.

Bug Fixes (Collaboration Enterprise Customers Only):

• [CLB-2468]: Teamwork Mentions - Very slow to find a match when typing username.
  In setups which large users volume, mentions were working slowly. That has been optimized now.
• [CLB-3387]: Writeback Audit export - Loading indicator is still visible after exporting to CSV.
• [CLB-3477]: Vizlib Log File consuming lots of space on disk.
  In some scenarios, log files generated by Vizlib Server were consuming a lot of space on a disk. We introduced a rotation mechanism that prevents this from happening.

Bug Fixes (Collaboration Enterprise Customers Only):

• [CLB-3532]: Snowflake Integration - Proxy support fix
  Fix delivered  the port parameter was not accepted properly by snowflake-sdk.

Bug Fixes (Collaboration Enterprise Customers Only):

• [CLB-3532]: MS Teams Integration - Proxy support 
  It is now possible to configure MS Teams Integration in the Vizlib Management Console while using http(s) proxy. 
• [CLB-3532]: Snowflake Integration - Proxy support  
  
  

New Features (Collaboration Enterprise Customers Only): 

• [CLB-2992]: Upgrade Postgres SQL to version 14.1.1
  The default database installed with Vizlib Server will be automatically upgraded to a newer Postgres SQL version during this update.
  Note: this will not affect external databases connected to the Vizlib Server nor external DB chosen during the installation.

Bug Fixes (Collaboration Enterprise Customers Only):

• [CLB-2907]: [VMC] Security Rules search engine does not work for some resource types.
  Searching for Resource ID sometimes did not return any results. (Only related to some resource types)
• [CLB-3031]: [VMC] Security Rules, creating new security rule can fail when there is a child group.
  When a child group was created, sometimes an error message with "validation error..." would show up. The validation message is now more user-friendly.
• [CLB-3037]: [VMC] MS SQL Integration - instance name fix.
  Use of an instance name would break the connection to MS SQL Server.
• [CLB-3057]: [Vizlib Server] Extension Server URL custom property in QMC is getting changed without any actions.
  There was an issue with using HTTP that could get changed to HTTPS.
• [CLB-3066]: [Vizlib Server] Writeback - cannot create a table without at least one column connected to the data model.
  The issue was reported for Snowflake but could happen with other integrations too.
• [CLB-3340]: [VMC] Random errors displayed after performing a server restart.
  Related to the user login, more specifically, it was an issue for non-admin users.
• [CLB-3381]: [Vizlib Server] Silent installation fixes.
  Postgres connections would sometimes get set up incorrectly.
• [CLB-3409]: [Vizlib Server] Writeback - Validate Fields does not work properly with QVD destinations.
  Validation of fields did not work properly for QVDs and would throw an "Export failed" message.
• [CLB-3336]: [Vizlib Server] Security Rules - Entered values are not trimmed.
  That could cause unexpected behaviors when copying and pasting values with additional whitespace characters.

New Features (Collaboration Enterprise Customers Only): 

• [CLB-2992]: Export Writeback Audit log.

Bug Fixes (Collaboration Enterprise Customers Only):

• [CLB-2414]: Vizlib Server - General improvements to error handling
• [CLB-2984]: Server-side Writeback - "Table already exists" error thrown when writing to snowflake destination
• [CLB-3168]: VMC Dashboard - Cannot connect to QES for rim nodes

Bug Fixes (Collaboration Enterprise Customers Only):

• [CLB-3170]: Email Integration - Connection to local SMTP server fails.

• [CLB-2880]: Additional Security settings including TLS version, HSTS, XSS, and CRSF tokens.

  [CLB-2877]: Node.js version upgrade to 12.22.3.

  [CLB-2893]: Improvements to the Writeback Destinations page.

  [CLB-3046]: Oracle Writeback Destinations - support for schema names. 

  [CLB-2878]: Installation - support for using an existing database. 

Bug Fixes (Collaboration Enterprise Customers Only):

• [CLB-3067]: [Writeback] - Decimal numbers are written to QVD as text while using commas as decimal separators.

• [CLB-1926]: Vizlib Management Console - Improvements to Qlik Sense section (engine port).
• [CLB-2933]: Silent Installation - Support for adding certificates (pfx, pem format) as parameters.  

Bug Fixes (Collaboration Enterprise Customers Only):

• [CLB-2998]: Bug in Lock Groups after config import

• [CLB-2922] Fix for Writeback Delete operation not working for server-side destinations

• [CLB-1321]: Vizlib Management Console (VMC) - Visual Improvements
• [CLB-2212]: VMC - Teamwork Workflows Screen Redesign
• [CLB-2783]: VMC - Logs Browser Style Changes  

• [CLB-2855]: Socket disconnected error pops out during bulk edit on larger data sets

• [CLB-1824]: Writeback - improvements for SQL autogenerated columns.  

• [CLB-2694]: Special characters in stream/integration ID break possibility to edit them

• [CLB-2457]: Support for silent installation.  
• [CLB-2648]: Vizlib Management Console v1.4.0, including new options for resource management. 

• [CLB-2642]: Adding faulty slack integration can corrupt VMC.

• [CLB-2753]: Slack Integration - Proxy Support.

• [CLB-1008]: Vizlib Management Console - Comments browser, column picker, and additional columns for app name and sheet name. 
• [CLB-2478]:  Vizlib Management Console - New look and feel for the Integrations page.

• [CLB-2711]: Issues after editing main db integration.
• [CLB-2621]: Vizlib Management Console - Empty destination list for content admin users.

New Features (Collaboration Enterprise Customers Only):

• [CLB-741]: Change VMC admin credentials in VMC

Bug Fixes (Collaboration Enterprise Customers Only):

• [CLB-2594]: VMC -  Modal not closing when navigating from Teamwork streams to the Users page

New Features (Collaboration Enterprise Customers Only): 

• [CLB-2225]: New Server Version Notifications

Bug Fixes (Collaboration Enterprise Customers Only): 

• [CLB-2420]: VMC -  No horizontal scroll for writeback audit trails with lots of columns
• [CLB-2496]:  Creating an integration from a writeback destination view is not working

• [CLB-2437]: Newly created finance and teamwork workspaces cannot be picked while editing streams

• [CLB-1871]: Vizlib Management Console - Multi-user access with roles and security levels

• [CLB-1896]: Unable to find data source when using QVD destination type through Vizlib Server
• [CLB-2235]: Setting an invalid certificate breaks the possibility of login to VMC (using HTTPS or HTTP)
• [CLB-2366]: Creating or updating streams/destinations improvements
• [CLB-2404]: Importing config with advanced security rules clears conditions
• [CLB-2406]: No toast on delete stream error

• [CLB-1889]: [Enterprise only] VMC integrations and destinations management improvements
   A massive improvement has been introduced to the VMC. You can now manage integrations and writeback destinations without having to restart the server. Changes are applied instantly and take effect without having to reload the Qlik Sense dashboard.

• [CLB-2229]: [Writeback Table] Setup issues when configuring REST destination.

• [CLB-2139]: [Input Form & Writeback Table] Fix when using server-side destinations with reload tasks.

• [CLB-1799]: [Form & Table] New Writeback Destination - Oracle.  
• [CLB-1965]: [Table & Form] Audit columns for server-side destinations.  
• [CLB-2096]: [Table & Form] Automatically lock server-side destinations when writeback is performed.

• [CLB-2044]: [Table & Form] When writing back to the SQL destination Timestamp column is empty.  
• [CLB-2110]: [Table & Form] REST destination issue with a basic authorization token. 

• Support for Vizlib Input Form and Vizlib Writeback Table.
• New sections in VMC for configuring Writeback destinations.

• [CLB-1896]: Unable to find data source when using QVD destination type through Vizlib Server

First Release.