WhereScape is pleased to announce that WhereScape RED 10.1.x is now available. Before upgrading, review the Important Messages when Upgrading from Earlier Versions for more information.

To review the Release Notes for older versions visit WhereScape Documentation.

New Features and Improvements 

Customizable Object Subtypes

Configure your Object Subtypes based on the existing object types in RED with the following configurable settings:

• Name
• Icon to appear in object trees and documentation
• Default Routine Templates for automated code generation
• Appearance in object trees

This feature is beneficial to customers wanting to differentiate between more object types and control the automation aspects based on those types. It's particularly useful in the case of Data Vaults where there are many object subtypes that can be configured in 3D but don't currently have a dedicated object type mapping in RED such as PIT and Bridge tables. This feature also allows setting specific icons for each object subtype which improves both productivity and look and feel.

Scheduler Improvements

Azkaban core and the RED plugin for Azkaban have been improved in this release to enhance the workflows when dealing with abnormal job runs.

Improved Azkaban/RED synchronization

Azkaban to RED metadata synchronization on aborted jobs has been improved, now when canceling jobs directly from Azkaban the RED job metadata is updated to match the external job state. This removes the need to run additional tasks via Azkaban to have the job removed from the 'Running' state in RED and allows further remedial tasks to be performed on the job run, as required, immediately following an abort.

Added support for cleaning up child processes on job cancellations

When a job is canceled directly from Azkaban an optional cleanup script is now triggered automatically by the presence of a host script object in RED matching a specific naming convention. This is beneficial to users who need to kill long running or abnormal jobs in the scheduler but ensure that the underlying child processes for the job are also killed to prevent further unwanted transactions on the source and targets involved in the task.
Job cancellations will now execute the RED metadata host scripts, if present, named:

• wsl_scheduler_job_kill_linux on Linux
• wsl_scheduler_job_kill_win on Windows

Improved job restart workflow

When manually marking a failed task as 'completed' in the RED Scheduler tab for an aborted job, then a restart on this job will now set the job run to 'Succeeded', provided there were no other failures in the remaining tasks to execute. This is useful when resolving a failed task externally and then later continuing the remaining tasks in the job, so that the job then appears as a successful completion in the metadata.

Migrating from Earlier Versions of RED

Note that due to both the new PostgreSQL metadata and the external Azkaban-based Scheduler, there is no upgrade path from earlier versions of RED directly to RED 10. If you are an existing customer of WhereScape RED on another metadata platform, then migration tooling will become available soon after this release along with the rollout of procedure-compatible Enablement Packs for selected Target platforms.

WhereScape 3D Compatibility

This release of RED is compatible with WhereScape 3D 8.6.9.1 versions and up for 3D exports to RED but it is recommended to use the latest version 9.0.2.1 of 3D to provide all feature capabilities.

Customer Improvements

This release also includes the customer enhancements and support fixes listed in the following section .

Detailed Changes in RED 10.1.0.0

The following changes have been implemented since 10.0.1.0.

 Improvements

• RED-11635 Added support for case-sensitive filters in the scheduler job name filter
  

• RED-11634 Enhancements to the project object maintenance dialog when accessed via the ribbon
  

• RED-11636 Updated reports menu on the builder screen

• RED-11633 Upgrades to this version will use the first target connection found to transfer Routine Default Templates settings to the new Object-Subtypes feature
  

• RED-11626 New Object-Subtypes feature added which enables the addition of customizable object sub-types with their own default routine templates
  

• RED-11639 Improved the killing of a job via Azkaban such that the RED metadata for the job is notified of the run state
  

• RED-11638 Killing a job via Azkaban now allows the optional execution of a cleanup script which enables the opportunity to kill any child processes; if required
  

• RED-11772 Token replacement for [TABLEOWNER].[table_name] and $OBJECT$ now allow 2-part-naming expansion when only the database name is used in the target platform (such as Teradata), this means if the schema field is left blank then the above tokens no longer expand to include an additional period for the schema in the fully qualified object name
  

Issues

• RED-11775 Fixed an issue when generating documentation for specific projects
  

• RED-11708 Enhancements to the project object maintenance dialog when accessed via the ribbon
  

• RED-10313 Resolved an issue where 3D deployment to RED was doubling single quotes in extended property values
  

• RED-11757 Restarting a job after manually marking a failed task as complete in RED now sets the correct final job completion status
  

• RED-11681 Resolved a deployment issue for source mapping objects with where clauses exceeding 4000 chars
  

• RED-11701 Fixed an issue in drag'n'drop from data warehouse tables when source column datatypes contain quotes

• RED-11555 When exporting to RED from 3D all generated routines are now correctly associated with the groups of the parent object
  

• RED-11647 The Maintain Hash Keys wizard now preserves the column position order of existing Hash Key columns
  

• RED-11743 Upgrade 3rd-party components in Pebble project
  

• RED-11742 Upgrade 3rd-party components in Azkaban project (including log4j)
  

• RED-11741 Upgrade 3rd-party components in Template Engine project
  

Detailed Changes in RED 10.1.0.1

The following changes have been implemented since 10.1.0.0.

Improvements and Issues

• RED-11851 Resolved issue with log4j upgrade where logging level was not being honored.
• RED-11849 Upgrades to reported vulnerabilities in 3rd party libraries.
• RED-11859 Fixed issue with the deployment of Data Vault Stage tables from 3D to RED where Hash Key Sources metadata wasn't deployed.
• RED-11857 Resolved Revert to Version functionality showing the wrong dialog.
• RED-11866 Fixed issue in applications deployment for object deletions.
• RED-11848 Resolved 3D to RED deployment issue in the new Object Subtypes feature.

Detailed Changes in RED 10.1.0.2

The following changes have been implemented since 10.1.0.1.

Improvements and Issues

• RED-11907 Resolved a digital signing issue that affected the RED 10.1.0.1 installer.
• RED-11896 Resolved issue with generating routines via templates where the default template could not be determined in some cases affecting RedCli.exe and RedDeploy.exe
• RED-11886 Fixed issue with object subtypes import process where default routine templates would not be applied in some scenarios affecting RedClie.exe and RED UI
• RED-11786 Resolved "Cannot retrieve default template" error occurring after upgrading to 10.1.0.0 release in some situations affecting RED UI