Universal Controller 7.0.1.0 Release Notes

Release Notes

Universal Controller release 7.0.1.0 contains the following high-level features. For a complete list of all the included features and fixes please refer to the Universal Controller 7.0.x Maintenance list.

Architecture

Backlog

Title

Description

B-13855

Upgrade to Microsoft JDBC Driver 9.2 for SQL Server

The supplied JDBC driver for Microsoft Sequel Server is now at version 9.2.

B-13920

Upgrade MySQL JDBC Driver to MySQL Connector/J 8.0.24

The supplied JDBC driver for MySQL is now at 8.0.25. (2021-05-11, General Availability)

MySQL Connector/J 8.0 Release Notes

B-12807

Enhance handling of database connection recovery

When performing an internal restart of the Controller, the database connection pools that are currently in use will now be closed and removed to avoid the possibility of re-using any connection from those pools.

After the current connection pools have been removed, new connection pools will be created on the restart of the Controller.

Connection pools now incorporate the restart count as part of the pool name to guarantee new unique connection pools.

The restart count is added as a suffix to the connection pool names:

2021-05-19-09:47:50:903 -0400   INFO [http-nio-7080-exec-7] Running Server Operation: Database Information
2021-05-19-09:47:50:911 -0400   INFO [http-nio-7080-exec-7] Database Information: [Type: SQLSERVER] ... [Connection Pools: Server-0 (0/3) Reserved-0 (0/1) Client-0 (0/5) ]

After one restart:

2021-05-19-09:50:00:349 -0400   INFO [http-nio-7080-exec-10] Running Server Operation: Database Information
2021-05-19-09:50:00:355 -0400   INFO [http-nio-7080-exec-10] Database Information: [Type: SQLSERVER] ... [Connection Pools: Server-1 (0/3) Client-1 (0/1) Reserved-1 (0/1) ]

This only applies to when the Controller is performing a restart.

B-13805

Upgrade Apache Commons dependency DBCP (2.8.0) & Apache Commons Pool (2.9.0)

This upgrades the third party libraries for database connection pooling.

Universal Extensions

Backlog

Title

Description

B-13812

Changes to extension archive validation

Updates to the validation of the contents of the Universal Extension zip archive to provide additional packaging flexibility.

User Experience

Backlog

Title

Description

B-12927

Add Option to Make User Defined Fields Required


Administrators can now enforce that the available User Defined fields are marked as input required. This option is available from the Administration System Properties menu.

Important Note

Use caution when setting User Defined fields to Required:

  1. Any Task/Task Instance record without a value specified for a newly required User Defined field cannot be updated until a value is provided. This includes saving changes to a workflow graph from the Workflow Editor. Users will need to update the Workflow Task definition first.

  2. Any existing Task definitions that do not contain data in the newly required user defined fields will not be able to be manually Launched, the user will be prompted to update the definition with the required data.

  3. Tasks or Workflow definitions that are Triggered will not be impacted regardless of whether or not these fields contain the required data.

Various

Various Definition Form Cleanup and Consistency items to ensure that the Name, Description, and Member of Business Services (where applicable) are consistently labeled and ordered as the first 3 fields.

  • B-13307: User Experience: Scripts Form Move "Member of Business Services" to 3rd field

  • B-13308: User Experience: Variables Form - Description and Business Service fields should be moved as 2nd and 3rd field

  • B-13309: User Experience: Virtual Resources Form - Description and Business Service fields should be moved as 2nd and 3rd field

  • B-13310: User Experience: Credentials Form - Description and Business Service fields should be moved as 2nd and 3rd field

  • B-13311: User Experience: Agent Cluster Definition - Add Description

  • B-13312: User Experience: OMS Server Definition - Add Description

  • B-13313: User Experience: Data Backup / Purge Definition

B-13837

User Experience: Remove redundant buttons from bottom of forms.

The relevant navigation buttons for each form are now only available at the top of the form.

Old view with buttons at bottom of form.

New view without buttons at bottom of form.

Workload Analytics

Backlog

Title

Description

B-13378

Add Definition Version info to Task Instance Detail


When a Task Definition is launched it’s Version Information is now stored in a new Source Version field in the Task Instance.