ConnectALL 2.3 release notes

New Adapters

HPE Service Manager

GIT

Silent Installation

Non-interactive installation option is introduced which eliminates user intervention during installation. This would facilitate auto deployment options.

<INATALLER_NAME>.exe -q -console -Dinstall4j.keepLog=true -Dinstall4j.logToStderr=true

Filter active/in-active connections

A new option to filter in-active or active connections from the home page.

Salesforce dot notation

Salesforce connector now support field mapping for relationships using "." Notation

Purge error records

We can remove unwanted failed / error records from Dashboard.

More features ...

  • Sync RTC reference fields without value mapping
  • Enhanced connectivity validation error messages in GUI
  • Comment Sync: Adding author information into comment body when syncing to destination
  • Perform a full synchronization regardless of when last synchronized.

Database Schema Changes

 

MySQL
ALTER TABLE `fav_connections` ADD COLUMN `created_datetime` DATETIME NULL COMMENT '' AFTER `id`, ADD COLUMN `updated_datetime` DATETIME NULL COMMENT '' AFTER `created_datetime`;

alter table record_map add is_delete varchar(1) default 'A';

CREATE TABLE  IF NOT EXISTS `fav_connection_login_options` (`fav_con_id` decimal(20,0) NOT NULL, `con_key` varchar(200) NOT NULL, `val` varchar(250) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

SQL Server
ALTER TABLE fav_connections ADD created_datetime DATETIME NULL;
ALTER TABLE fav_connections ADD updated_datetime DATETIME NULL ;

alter table record_map add is_delete varchar(1) default 'A';

if not exists (select * from sysobjects where name='fav_connection_login_options' and xtype='U')  CREATE TABLE fav_connection_login_options (  [fav_con_id] decimal(20,0) NOT NULL,  [con_key] varchar(200) NOT NULL,  [val] varchar(250) DEFAULT NULL) ;
Oracle
ALTER TABLE fav_connections ADD created_datetime TIMESTAMP  NULL;
ALTER TABLE fav_connections ADD updated_datetime TIMESTAMP  NULL;

alter table record_map add is_delete varchar(1) default 'A';

CREATE TABLE fav_connection_login_options (  fav_con_id number(20,0) NOT NULL,  con_key varchar2(200) NOT NULL,  val varchar2(250) DEFAULT NULL);

 

PostgreSQL
ALTER TABLE fav_connections ADD COLUMN created_datetime TIMESTAMP NULL;
ALTER TABLE fav_connections ADD COLUMN updated_datetime TIMESTAMP NULL;

alter table record_map add is_delete varchar(1) default 'A';

CREATE TABLE IF NOT EXISTS fav_connection_login_options (  fav_con_id decimal(20,0) NOT NULL,  con_key varchar(200) NOT NULL,  val varchar(250) DEFAULT NULL) ;

Release Notes

Story

  • CA-901 - Silent installation option - with preloaded configuration values
  • CA-2308 - Sync RTC reference fields without value mapping
  • CA-1441 - Should add a link to navigate to CA help page from CA products.
  • CA-2321 - Rally Feature 2 Story linking issue fixed
  • CA-1312 - The warning message for duplicate name should be more friendly.
  • CA-2317: Comment Sync: Adding author information into comment body when syncing to destination
  • CA-2216 - Enhance Connectivity validation - GUI
  • CA-965 - LDAP Configuration Screen on GUI
  • CA-2101 - Separate inactive connectors from active connectors
  • CA-2214 - Perform a full synchronization regardless of when last synchronized.
  • CA-352 - Sort project and issue types lists
  • CA-2171 - Remove restriction on Jira sync user timezone restriction and Jira Default timezone

 Bug

  • CA-2391 - Duplicate attachments getting created from QC <-> JIRA when attachment file name has & character
  • CA-2390 - Dashboard delete record not working with Oracle database
  • CA-2359 - The “Application Type” drop-down on the Configuration > Connections page does not display the 2 new connectors “Remedy” and “HP Service Manager”.
  • CA-2386 - Seapine - CA throws an unexpected error when trying to change the field datatype to "Select".
  • CA-2389 - Seapine - Failed to sync records between JIRA and Seapine.
  • CA-2388 - Dashboard - Search Results panel - The "Delete" and "Status" columns should NOT be sortable.
  • CA-2387 - Wrong DateTime is converted from ServiceNow to JIRA
  • CA-2379 - Salesforce - Datetime is not converted from Salesforce to JIRA
  • CA-2397 - DoorsNG - Issue linking cannot be synced from DoorsNG to JIRA
  • CA-2404 - Installer - Error pops up during installing with bundled tomcat, mule, mysql.
  • CA-2399 - Release2.3: Failed to sync JIRA defect to TFS
  • CA-2362 - User is able to navigate to Mapping page even with invalid credentials
  • CA-2400 - Table 'fav_connections' cannot be created on Oracle, MSSQL and PostgreSQL
  • CA-1164 - CA SPrint 15 - Extra space in the link throws an Invalid Error message
  • CA-2336 - Salesforce - Datetime always is synced wrong between JIRA and Salesforce 
  • CA-2276 - Perforce - The Datetime is not adjusted by time difference from Perforce to JIRA.
  • CA-442 - Cannot delete an existing lircense
  • CA-2287 - Alignment issue in listing the applications in Home screen
  • CA-1249 - Cannot send email after configuring smtp.
  • CA-442 - Cannot delete an existing lircense
  • CA-2335 - Dashboard - Typo "Deleteing" appears on the confirmation box when trying to delete a record.
  • CA-2330 - Refreshing of the records is not happening after deleting the records from dashboard
  • CA-2295 - Poll query from Remedy to Jira is not working as expected
  • CA-2307 - License Configuration - count of total number of servers configured is not correct
  • CA-1490 - After deleting the user from LDAP server, the synced ldap user still displays on CA, but cannot login.
  • CA-1177 - HPQC connector acquires new connection for each rest api call
  • CA-1497 - Multi-select field is not correctly synced from Jira to ClearQuest.
  • CA-1325 - Sync of QC Id field to TFS is prevented
  • CA-1917 - Validation missing for DoorsNG module field
  • CA-553 - Exception suppressed in Qc11CommentManager - Can't be retried on failure
  • CA-1353 - Scheduler Configuration - Every 1 Hour Scheduler shows at 1:00AM in the ConnectAll dashboard
  • CA-1354 - Scheduler - The schedule for the application link is set to blank if the frequency of minutes is set to a value out of the range 1~59.
  • CA-2306 - Footer alignmet is not proper