quilliup 2.5.2 Release Notes

The following release notes include all significant changes released and solved in 2.5.2 and following versions till current version.

Release date: Feb 10, 2017

Big Query - new data source connector

quilliup now allow you to connect to google Big Query and define alert and data validation rules. The data source connector support free queries or query builder to help you define how to extract data

 

Impala - new data source

quilliup now you to define connection to Hadoop HDFS using the new and fast IMPALA jdbc connector.

Quality Gates

Bug Fixing

• [VAPP-3437] - Fix issue in data validation - when getting error message "Server Error. Undefined Error" in test execution
• [VVAPP-4065] - Fix issue in custom rule when changing the friendly name and changes are not saves
• [VAPP-4151] - Fix issue in test results grid when last run time stamp is different in all the system
• [VAPP-4144] - Fix issue in execution flow, test, script and command grids when last run column is not correct
• [VAPP-4206] - Fix issue in Hadoop data set when writing "select 1 from table name" query returns empty failed message
• [VAPP-4208] - Fix issue in test results when execution fails- isOldRun- true
• [VAPP-4212] - Fix issue in KPI test when output results in type date format present as number
• [VAPP-4215] - Fix issue In e-mail test results when diff is presented without %
• [VAPP-4007] - Fix issue in data set when query here clause doesn't work when "Custom Command Filter" used
• [VAPP-4217] - Fix issue in test results grid when Last Run Date color is orange when it shouldn't be
• [VAPP-4226] - Fix issue in test execution when tests are getting status "Cancelled by user" when they are not
• [VAPP-4236] - Fix issue in Execution flow get "cancelled by the user" status automatically
• [VAPP-4233] - Fix issue in Redshift dataset when sample data get stuck
• [VAPP-4257] - Fix issue in test when mail isn't sent to active directory user
• [VAPP-4269] - Fix issue in data set "Validate query" when query is not presented when it's wrong
• [VAPP-4292] - Fix issue in test execution when getting java.lang.OutOfMemoryError: PermGen space error
• [VVAPP-4221] - Fix scheduler issue when execution flow is not run after repository db downtime

New Features

• [VAPP-898] - Support google Big Query data source
• [VAPP-4028] - Support table name as variable in log tables
• [VAPP-4139] - Support variable in data set flow in Qlikview data set
• [VAPP-4213] - Add "Always" condition in execution flow
• [VAPP-4240] - Support Impala connector on Hadoop data source
• [VAPP-4247] - Change test execution failure from status (6) to status disabled (7)
• [VAPP-4173] - Present Data Validation rule name in test execution results excel
• [VAPP-4262] -Add the ability to choose chunks on the master dataset in the test toolbox
• [VAPP-4309] - Sort execution results by last run in execution flow, scripts, tests grids
• [VAPP-4314] - Add the ability to choose full Index option in compare test

RDA

Bug Fixing 

• [VAPP-4325] - RDA Editor - Fix issue when searching users in Active Directory by username instead of name
• [VAPP-4255] - RDA Designer - Fix deployment issue when get an error message when trying to change the project settings (Project Permissions)
• [VAPP-4284] - RDA Editor - Fix issue when query for date type in Netezza DB is wrong on Edit
• [VAPP-4270] - RDA Editor - Fix issue when search in Multyselect Dynamic DD doesn't work
• [VAPP-4109] - RDA Editor - Fix issue when get error message on copy row
• [VAPP-4250] - RDA Editor - Fix issue in roles deployment when project permissions are not correct
• [VAPP-4230] - RDA Designer - Fix issue when data source can be used even it is not related to the project
• [VAPP-4207] - RDA Designer - Fix issue in dynamic drop down when values of existing row is not presented
• [VAPP-3656] - RDA Editor - Fix issue when search on nothing, it became yellow

New Features

• [VAPP-4220] - RDA Editor - Add the ability to check columns constraints when import data from excel
• [VAPP-4219] - RDA Editor - Add the ability to check list constraints when import data from excel
• [VAPP-4218] - RDA Editor - Add the ability to check constraints between columns when import data from excel
• [VAPP-4200] - RDA Editor - Support export data structure in excel to be the same order as the table's columns order

Ticketing

Bug Fixing

• [VAPP-4299] - Fix issue when string automatically converts to varchar (255)
• [VAPP-4260] - Support The conversion from varchar to CLOB
• [VAPP-4234] - Fix issue in presentation when "open date" filter is presented as long

New Features

• [VAPP-4228] - Support bulk operation with changing filter
• [VAPP-4086] - Support Home page filters selection for user (default presentation favorite) to be saved

Administration

New Features

• [VAPP-4318] - Active Directory - support Jespa encrypt password
• [VAPP-4232] - Installation wizard - keep current configuration for mail picture in template

quilliup 2.4.7 Release Notes

The following release notes include all significant changes released and solved in 2.4.7 and following versions till current version.

Release date: Sep 11, 2016

API Data Source Connector

We introduced API as data source - powerful, simple and native way to connect API REST and SOAP requests. quilliup connect using the HTTPClient driver by sending request that access the API and returns response from a web applications

Administration

New Features and Bug Fix

• [VAPP-9999] - When searching for users, add the ability to choose "exact name" for better performance
• [VAPP-9999] - Fix bug in dataset when searching for entities, support list of 2000 tables

Quality Gates

New Features

• [VAPP-9999] - Support unique function on files in compare test
• [VAPP-3874] - API as Data source
• [VAPP-3905] - In execution flow, Add "execution failure" status
• [VAPP-3856] - In test settings allow users to define execution timeout period
• [VAPP-3846] - In execution flow, add more scheduling options such as "last day of month", "run with minutes" and the ability to write custom cron expression
• [VAPP-3700] - In the test pallet, control the column order in the data set
• [VAPP-3953] - Check if data source related to object before delete
• [VAPP-3976] - Data validation rule support date validation (ISDATE) function

Bug Fixing

• [VAPP-9999] - Fix bug in Set variables (test, execution flow)
• [VAPP-9999] - Fix bug in KPI snapshot when threshold in percentages present as numbers
• [VAPP-9999] - Fix bug when Execution flow scheduled with no components
• [VAPP-9999] - Fix bug when null value in log to tables
• [VAPP-4016] - Fix bug in Data Validation rule when Save/Validate the rule, the related calculated columns should be in same order as they where created
• [VAPP-4014] - Fix bug that wrong number of rows are returning from the test result when changing the test's Chunk size
• [VAPP-4005] - Fix bug in data validation rule that Date as String does not present correctly
• [VAPP-3984] - Active Directory - change SSO mechanize
• [VAPP-3974] - Fix bug when execution flow passes even some of the tests fails (only in parallel mode)
• [VAPP-3915] - Fix bug in SSO mode When using Active directory group's, users are unable to log in
• [VAPP-3862] - In execution flow fix bug when using mail recipient as variables, the initial value is not correct (Distribution issue)

RDA

New Features

• [VAPP-9999] - Support columns auditing in database
• [VAPP-3999] - In designer module, step 3, Add New feature to "Refresh all grid on inline edit" option
• [VAPP-3982] - In designer module Add the ability to audit the form's key values
• [VAPP-3972] - In designer module add the ability to pass directly from step 1 to any step
• [VAPP-3971] - In editor module when import from excel add the ability to define Header row number
• [VAPP-3969] - In designer module, step 2, add "arrows" to change the columns order
• [VAPP-3954] - In editor module support search timestamp values
• [VAPP-3952] - In designer module support date column as key
• [VAPP-3940] - In editor module, in dynamic list show the column value (not the caption)
• [VAPP-3682] - In designer module add the ability to change the form direction from right to left
• [VAPP-3962] - In designer module, step 1, add scrolling option for choosing the forms key

Bug Fixing

• [VAPP-4018] - In Drop Down list searchable - impossible to preview value
• [VAPP-4006] - In designer module, step 4, Fix bug when define date column as searchable the type is not present correctly
• [VAPP-3997] - Fix bug in designer module in Step 2 "Advanced Column Settings" sign ? shown twice
• [VAPP-3996] - Fix bug in designer module when changing a key in a form all column's tabs are deleted
• [VAPP-3990] - Fix bug in designer module - Right to left issues in Step 4
• [VAPP-3989] - Fix bug when changing date field it is defined as 'read only' column
• [VAPP-3987] - Fix bug in designer module on Step 3 Inline Edit switcher sometimes isn't shown
• [VAPP-3851] - Fix bug in editor module in dynamic dropdowns, when search values in all other values in other columns shows with "()"
• [VAPP-3813] - Fix bug in designer module when add new key to existing form getting error message "Failed key column(s) were not supplied"

quilliup 2.4.1 Release Notes

The following release notes include all significant changes released and solved in 2.4.1 and following versions till current version.

Release date: Jul 18, 2016

Qlikview Connectivity

We introduced the QLIKVIEW NATIVE API - powerful, simple and unique way to connect QlikView objects. this includes new flow which let the user to perform QlikView operations such as:

• Custom expression perform custom calculations and conditions between chart's attributes such as sum, divide, plus, minus and more

• Set Variables initial variables values in the dashboard as part of the flow to get hidden objects

• Set Filters perform conditions in the sheet's filters as part of the flow to get the exact values in charts

• TextBox custom transformation in the dataset, ability to remove text from columns in Text Objects

Quality Gates

New Features

• [VAPP-3887] - Qlikview data source - Add timeout when reloading metadata
• [VAPP-3885] - Qlikview dataset - support List Box object in qvw
• [VAPP-3882] - Quality Gates engine - add option to choose Sequence number for deploy (support unique testid)
• [VAPP-3881] - Data validation formula - add function DATEFORMAT() for date validation
• [VAPP-3877] - Qlikview dataset - add option to remove Chars from values in qvw
• [VAPP-3873] - Qlikview dataset - add option to write advance expression on object in qvwset
• [VAPP-3864] - Data sources - sort the drivers in Alphabetise order credential
• [VAPP-3863] - Execution flow test results - Add last timestamp column
• [VAPP-3861] - Execution flow test results - add the ability to Resize the test name column
• [VAPP-3859] - QlikView data source - support filters in qvw
• [VAPP-3858] - QlikView data source - support Variables in qvw
• [VAPP-3848] - Migration Wizard - support QVD as Data Source
• [VAPP-3839] - Qlikview data set - support text object
• [VAPP-3303] - Datasource - support NoSQL-Mongo
• [VAPP-3758] - UI - present the tenant name on screen
• [VAPP-3752] - Data validation test - add hint for the User ([, @, #)
• [VAPP-3552] - System configuration - support select column as index in the test settings

Bug Fixing

• [VAPP-3900] - Handle big decimal numbers
• [VAPP-3899] - QVW Data Set - format isn't saved after "Refresh Columns"
• [VAPP-3866] - Execution flow scheduler - fix issue when tying to save the scheduler

RDA

New Features

• [VAPP-3894] - Search - Fix issue when press enter in search refresh all the page
• [VAPP-3890] - Dynamic Modal - Now the RDA form wont close when click outside the edit/add modal
• [VAPP-3864] - Data sources - sort the drivers in Alphabetise order
• [VAPP-3853] - Designer - Add validation based dependencies between fields values
• [VAPP-3852] - Designer - support variables in drop down list
• [VAPP-3770] - Editor - improve performance on search for values in dynamic list
• [VAPP-3752] - UI - present the tenant name on screen
• [VAPP-3720] - Designer - present the "add" button on top of the screen
• [VAPP-3702] - Editor - support "ENTER" key on search
• [VAPP-3852] - Designer - supoort Cascade fields (display fields depending on other field values)
• [VAPP-3924] - Editor - support bulk operations: update and delete multi rows in form
• [VAPP-3925] - Designer - ability to releate column/s to a group
• [VAPP-3946] - Designer - support new dropdown type: dynamic multiselect
• [VAPP-3889] - Editor - support null values in lists (add x button)

Bug Fixing

• [VAPP-3893] - Designer - Fix issue in column that hide fromgrid but "searchable"
• [VAPP-3868] - Drop down Lists - fix issue when data do not exists in searchable list after upgrading to 2.4.0
• [VAPP-3854] - Editor - search in dynamic drop down is not case sensitive
• [VAPP-3847] - Editor - fix issue when search for list or switcher not work
• [VAPP-3865] - Designer - fix issue when Dynamic list loading with the current value and after clear will load the list again
• [VAPP-3932] - Designer - #today# in "max date" doesn't work
• [VAPP-3854] - Designer - search in dynamic drop down shouldn't be key-sensative

quilliup 2.4.0 Release Notes

Quality Gates

New Features

• [VAPP-3772] - Data validation - filter result by rule
• [VAPP-3726] - Data validation - Select columns in test results
• [VAPP-3721] - Data validation - Function "IsNumber()" available in rule
• [VAPP-3788] - Data source - NT user log in available
• [VAPP-3829] - Data source - Add filed "Port" to "New Data Source" form
• [VAPP-3700] - Data set - RDBMS - control the column order in the data set
• [VAPP-3807] - Data set - Qlikview - show error message in case of bad credential
• [VAPP-3768] - Data set - Custom empty dataset available in log table
• [VAPP-3753] - Test grid - give option to change default view to test grid and not tile view
• [VAPP-3790] - Installation wizard - NT authentication available in installation wizard
• [VAPP-3761] - Deploy - Check import role-project relation
• [VAPP-3756] - Variables - Add "influential" option to be part of the execution key
• [VAPP-3808] - Compare test - add COUNT() aggregation function to compare

Bug Fixing

• [VAPP-3824] - Data validation- Rule not saved when using mouse only
• [VAPP-3823] - Data validation- all unique keys are chosen by default
• [VAPP-3769] - Data validation - "Stop" button not exist when execute test
• [VAPP-3694] - Data validation - all fields selected by default for unique in data validation test
• [VAPP-3730] - Data validation - Only one failed row presented in Excel file instead of all failed rows
• [VAPP-3767] - Data source - DB2 - connector not retrieving all entities
• [VAPP-3832] - Data set - fix the ability to build Data Set for the table with name "Group"
• [VAPP-3831] - Data set - qlikview - impossible to see object after "reload meta data"
• [VAPP-3640] - Data set - query not valid when using query builder with filter condition
• [VAPP-3727] - Data Set - 404 Error when entering the test with empty Data Set
• [VAPP-3701] - Data set - when import data set that already exist (with different DB Connection) it has no owner
• [VAPP-3794] - Test grid - "Test Connection" font is disproportionate
• [VAPP-3789] - installation wizard - fix bug in server.xml file
• [VAPP-3664] - Installation wizard - on upgrade, no overwrite the Active Directory configurations
• [VAPP-3658] - Installation wizard - support for import/export location on upgrade wizard
• [VAPP-3655] - Installation wizard - fix issue when installation is done the process is still alive
• [VAPP-3630] - Installation wizard - on upgrade, Fix bug in oracle database
• [VAPP-3618] - Installation wizard - Add .net to quilliup installation.exe file
• [VAPP-3617] - Installation wizard - upgrading to 2.3 failed in Oracle repository (UPPERCASE)
• [VAPP-3364] - Installation wizard - In 64bit installation, change default folder to C:\\Program Files
• [VAPP-3815] - Custom rule - a warning sign (yellow triangle) on the rule
• [VAPP-3719] - Test results - fix issue when exporting a date-format in excel from number to date format
• [VAPP-3731] - Navigation menu - On Laptop menu vertical scrolling doesn't work

RDA

New Features

• [VAPP-3710] - RDA Editor - Number range update
• [VAPP-3673] - RDA Designer - Group by categories in the form and in the list
• [VAPP-3672] - RDA Designer - Add dependencies between columns on Edit & on Create
• [VAPP-3671] - RDA Designer - The filter is not connected to a SQL list of value
• [VAPP-3669] - RDA Designer - Vertical scroll should be at the table level (as the horizontal scroll)
• [VAPP-3634] - RDA Designer - sign undeline on "Role Permissions" to know its a link
• [VAPP-3557] - RDA Designer - Add support in query based default values
• [VAPP-3684] - RDA ICON

Bug Fixing

• [VAPP-3826] - RDA Designer - no "Clear" link in Advanced search
• [VAPP-3822] - RDA Designer - default value for Boolean check box doesn't work
• [VAPP-3819] - RDA Designer - "check box 0 1" works wrong for MSSQL
• [VAPP-3814] - RDA Default function - "Failed Invalid column name 'undefined'." for existing column with correct name
• [VAPP-3812] - RDA Designer - Tabs RDA - Add / Edit form isn't saved
• [VAPP-3811]- RDA Designer - Tabs in RDA - message that a filed is required isn't shown
• [VAPP-3810] - RDA Designer - "Tabs Position" by default shouldn't be empty
• [VAPP-3809] - RDA Designer - if more than 1 tab => no columns on Add / Edit are shown
• [VAPP-3806] - RDA Designer - on Step 2 columns go out of the borders
• [VAPP-3717] - RDA Designer – “Read only” and “Required” can’t be marked together for same column
• [VAPP-3714] - RDA Designer - in "Edit form" existing value for a column isn't presented
• [VAPP-3713] - RDA Designer - add a number from drop down failed
• [VAPP-3654] - RDA Editor- possible to choose one value only from drop own of type Multiselect
• [VAPP-3641] - RDA-Designer -search in dropdowns
• [VAPP-3480] - RDA-Designer -Cannot present list in read only in edit form
• [VAPP-3478] - RDA-Designer -width for date column doesn't work also from custom html
• [VAPP-3282] - RDA-Editor - Advanced search results
• [VAPP-3278] - RDA-Designer - Drop down list - values for the field "Label here" are invisible
• [VAPP-3221] - RDA-Editor -Adding a date field in rda form

 

Known Issues Fixed in 2.3

Quality Gates

New Features

• [VAPP-3696] - support variables in mail- no override from UI
• [VAPP-3694] - CRC32 for files
• [VAPP-3692] - migration wizard-compare test
• [VAPP-3683] - config.properties into form
• [VAPP-3659] - File folder without choose filter
• [VAPP-3648] - Create file's data source with no prefix
• [VAPP-3509] - Add full statistics and stop functionality in DV statistics

Bug Fixing

• [VAPP-3642] - Invalid query when creating a data set
• [VAPP-3640] - query not valid when using query builder with filter condition
• [VAPP-3639] - Execution Flow - when "Stop" clicked not all the tests are stop in UI
• [VAPP-3614] - Data Validation - possible to filter on rule when all rows Passed
• [VAPP-3593] - Data Source - without \ at the end of path test fails
• [VAPP-3565] - Full Monitor Variable columns - column name and value should be aligned equally
• [VAPP-3563] - Data Validation - log tables - delete "summary and" from Tables per rule
• [VAPP-3493] - data validation rule threshold text fix
• [VAPP-3334] - Button "{:}" in Set variables shouldn't become white on hover

RDA

New Features

• [VAPP-3668] - Refresh grid on inline edit - By configuration
• [VAPP-3667] - Support "lock" state for records
• [VAPP-3663] - Default function as default value
• [VAPP-3662] - add to Boolean type - check box option inside the grid
• [VAPP-3217] - Configure numbers of rows in form

Bug Fixing

• [VAPP-458] - Open the side bar menu of the designer when entering the module
• [VAPP-3221] - Adding a date field in RDA form
• [VAPP-3467] - RDA Designer - check box "Required" isn't saved
• [VAPP-3502] - RDA Designer - Failed message without test
• [VAPP-3561] - RDA - Drag and drop of fields doesn't always work
• [VAPP-3559] - Refresh columns at step 2 doesn't work, user needs to refresh the table/update columns at step 1
• [VAPP-3636] - Problem in RDA form when delete drop downs
• [VAPP-3633] - Search chars in Number type field
• [VAPP-3646] - disorder in columns- csv file
• [VAPP-3693] - Dynamic Drop down - no values are shown
• [VAPP-3691] - RDA Designer - null object for valid form (valid query)
• [VAPP-3690] - RDA Designer - impossible to search in Dynamic drop down & in form
• [VAPP-3687] - RDA - values in table but does not exists in the drop down list
• [VAPP-3670] - RDA Editor - values of type offsetting (MSSQL) are bad presented
• [VAPP-3649] - Delete all rows that are not in Drop-down list
• [VAPP-3647] - RDA-Designer - bad time stamp presentation

Known Issues Fixed in 2.3

• [VAPP-3482],[VAPP-3395] - License embedded limitation of 10,000 rows in QVD files was removed.
• [VAPP-2562] - Oracle 12 repository issues related to the quartz scheduling tables were solved.
• [VAPP-2852] - Execution is now enforced and not only alerted when connecting more the one data set to other rules but the Compare.
• [VAPP-3220],[VAPP-3457],[VAPP-3458] - Deployment issues were fixed. Issues were related mainly to the deployment operation is applied with an empty project id. Additional issues were fixed on customer sites where more than one system admin default user applied (happened where first beta versions were installed and later upgraded).
• [VAPP-3288] - Performance parameters at the test settings are now blocked for KPI test as it is not supported (KPI test does not contain the distribution mechanism and is limited for up to 150,000 rows after grouping the data).
• [VAPP-3335] - Variables list in threshold value now contains only numeric variables.

Known Issues Released in 2.2

• Postgres database will not be supported as an optional repository for quilliup platform.

RDA

Bug Fixing

• [VAPP-3415] - When using a key column which contains NULL values, which are not supported as part of the key, there is no relevant error message.
• [VAPP-3479] - Search is case sensitive when data source is Oracle.