QuerySurge 2022 - Version 10.0 Release Notes

Versions: 8.0+

QuerySurge 2022
Version 10.0 Release Notes
Release: 04-01-2022

What’s New

1. 1. Webhook Support
      • Microsoft Teams Webhook Support - QuerySurge can notify your team in Teams
      • Slack Webhook Support - QuerySurge can notify your team via Slack
      • Jira Bug Creation by QuerySurge via Webhook
      • Generic - create custom Webhook notifications in QuerySurge
   2. Ignorable Columns in Analysis
      • Specify QueryPair columns to be excluded from the comparison during analysis
      • Useful when you want synthetic keys in your QueryPair but have nothing to compare them to
   3. Email Notification Enhancements
      • Added Email CC field - allows for emails to be sent to non-QuerySurge users
      • Updated Email Edit/Creation Modal
   4. BI Tester - Updated Power BI Support
      • Added Service Principal Impersonation - allows for testing of reports with Row Level Security (RLS)
      • Error message improvements for missing visualizations and pages.
      • Expanded Metadata output
      • Allow visualization extraction by Name or Title - Allows for testing of visualizations with dynamic titles
   5. BI Tester - Tableau
      • Tableau 2021.4 is now supported
   6. Data Type: TIMESTAMP WITH TIMEZONE
      
      • QuerySurge now supports the TIMESTAMP WITH TIMEZONE data type
   7. Support for Trino
      • In addition to support for the Presto JDBC driver, QuerySurge now supports the Trino JDBC driver.

Version 10.0 Bug Fixes

What’s Fixed 

Build	ID	Description
10.0.0	QS-6460	QueryPair Import/Export works with incorrectly formatted paths
10.0.0	QS-7927	Excel JDBC Driver Handles Date Times Incorrectly
10.0.0	QS-7846	Server Shutdown hangs runs
10.0.0	QS-7442	Global Performance Report does not Show Data for Agents
10.0.0	QS-7959	Power BI Connections are not working in Linux installations due to incorrect configuration
10.0.0	QS-7965	Deleting the Default QuerySurge Project and restarting Tomcat creates two Default QuerySurge Projects
10.0.0	QS-7961	User status still shows online after being logged out from another user logging in using the same browser
10.0.0	QS-7970	Update msal4j to resolve CVE-2021-27568
10.0.0	QS-7993	Default Project Not Resetting On Project Deletion
10.0.0	QS-8001	Error on project login after running a global admin report
10.0.0	QS-8003	Some email addresses with more than 7 trailing characters at the top level domain get validated incorrectly
10.0.0	QS-7997	Shared Key Error Does Not Trigger If No Keys Found
10.0.0	QS-8011	Update Log4j 2.17.0 to 2.17.1 due to CVE-2021-44832
10.0.0	QS-7262	Invalid XML characters in Connections or in QueryPairs causes the test to spin and Agent to be stuck idle
10.0.0	QS-2573	DTR - View Query Results - Failures - Export to XML show incorrect results
10.0.0	QS-7995	Incorrect flat file setting causes spinning DTR/execution
10.0.0	QS-8007	User gets a Connection Timeout error instead of BI Tool is not licensed! error
10.0.0	QS-7940	Licensed Global Admins can't Access Global Admin when Global Admin-only is Logged In
10.0.0	QS-8046	Scenario Detail Report - Test Suite name link defective
10.0.0	QS-8056	Excel JDBC Driver does not handle Sheet with one Cell and No Headers
10.0.0	QS-5770	Full Staging Schema name shows in exception message
10.0.0	QS-8078	Update H2 1.4.196 to 2.1.210 due to CVE-2021-42392
10.0.0	QS-8084	Dremio causes a delay when executing certain data sets with mixed data types
10.0.0	QS-8095	Email address fields are inconsistent on allowed value lengths
10.0.0	QS-8075	Column Thresholds do not work when other columns in the same row fail
10.0.0	QS-8085	The Snowflake connection wizard adds domain to URL
10.0.0	QS-8136	Deleting a project that a deleted user was assigned to presents the user with an error indicating the request has failed
10.0.0	QS-8155	Attempting to import a project with the same name as another project causes the import to start and never end
10.0.0	QS-8192	Unable to Utilize Excel-based Connection when Processing Excel Data In Memory
10.0.0	QS-7776	Revision History Diff Mode Does Not Work If Order Changed
10.0.0	QS-6846	User email addresses do not accept symbols
10.0.0	QS-6248	QueryPair Last Run Report is missing the Time Frame section on the Firefox web browser
10.0.0	QS-8274	Disk space notification continual popup
10.0.1	QS-8312	Email CC can prevent emails from triggering
10.0.1	QS-8315	Email Notifications Fail on resolving Project Name
10.0.1	QS-8316	JSON Parsing Error Causes Disk Space Notification Emails to Fail
10.0.2	QS-8354	Scenario Detail/Summary/Failure Reports Can Fail When Validation
10.0.2	QS-8391	JavaScript Exception in System Configuration Report
10.0.3	QS-8393	Excel Files with Empty Cols Error Out
10.0.4	QS-8412	Server Props grid has 'MySQL' version, etc, not 'Database' version
10.0.5	QS-8420	BI Driver is case-sensitive
10.0.6	QS-8424	QueryPairs with many thresholds can cause resulting data to be incorrectly detected as failures
10.0.7	QS-8421	Single machine installs for MariaDB sometimes result in two agents
10.0.8	QS-8425	Data too long for column 'colName' at row 1" error