New Features and Improvements

Upgrade Process

A new scheduler upgrade wizard has been developed which streamlines the upgrade process and reduces the number of manual steps required during scheduler upgrades.
Authentication profiles are now created automatically when upgrading from a version of RED which does not include the advanced connect feature.

Installation

Metadata databases and DSN's for RED and the Azkaban Scheduler can now be created using the installation wizards, reducing the number of manual steps required during new installs.

Profile Maintenance

A new scheduler profile maintenance wizard has been developed with an enhanced UI.

Increased limits

The maximum number of projects and groups can now be configured, allowing for over 1000 projects and groups in a single repository.
Increased the character limit on FROM/WHERE clause for views to 65344 characters.

RED med.exe (RED UI)

When starting med.exe (RED UI) from a command line with all the required metadata connection elements provided, you can now provide and additional switch '--auto-connect' which will skip the interactive login screen to RED.

Added RED UI ODBC connection resilience, idle connections are tested before use and recovered if broken. Idle time before testing and test response time can be fine-tuned via user preferences.

Scheduler

RED's job plugin for Azkaban now accepts the legacy RED 9 script output protocol when executing stand-alone scripts via a scheduler job, this feature eases migrations to RED 10 by reducing script refactoring and testing.

Detailed Changes in RED 10.5.0.0

The following changes have been implemented since 10.4.0.2

Improvements

JIRA	Release Note
RED-12100	Authentication profiles are created automatically when upgrading from a version of RED without the Advanced Connect feature.
RED-11462	Jobs stuck in the running state can now be aborted in the RED UI.
RED-12256	On hold jobs are no longer retained when processing objects via the scheduler interactively.
RED-4786	The maximum number of projects and groups can now be configured, allowing for over 1000 projects and groups in a single repository.
RED-5905	Increased the character limit on FROM/WHERE clause for views to 65344 characters.
RED-12278	Added RED UI ODBC connection resilience, idle connections are tested before use and recovered if broken. Idle time before testing and test response time can be fine-tuned via user preferences.
RED-12130	Improved performance of object properties storage tab initialization when using a Teradata target.
RED-12285	The Connection field 'Database Link Name' is now available to scripts as an environment variable 'WSL_LOAD_DBLINK' so that scripts can build the appropriate source SQL statements at run-time.

New Features

JIRA	Release Note
RED-10686	New Scheduler upgrade workflow automating many of the manual steps that were required.
RED-12257	The WhereScape RED metadata database and DSN can be automatically created using the RED Setup Wizard.
RED-12102	The Scheduler metadata database can be automatically created during the Scheduler installation process.
RED-12103	New RedSchedulerProfileMaintenance.exe for maintaining the Schedulers authentication profiles.

Fixes

JIRA	Release Note
RED-12293	Fixed a metadata insert failure when defining Reusable Transformations in RED 10.
RED-12274	Fixed an issue deploying the default 3D entity types Dim View and Retro to RED, now these entity types are correctly mapped during deployment.

The following changes have been implemented since 10.3.0.1

Improvements

JIRA	Release Note
RED-11947	A new script category 'Workflow' has been introduced, these script types will show up in context menus and when executed provide the containing context to the script in a JSON format.
RED-11951	Host Script Object names can now contain spaces and hyphens, this supports human readable display of Workflow scripts in context menus.
RED-11950	Host scripts can now have individual icons set per host script type, particularly useful for Workflow scripts. New icons have been added to the installer for working with this feature.
RED-11957	CheckIn/CheckOut feature will now trigger execution of a script, if present, to support GIT integrations. Add script names of wsl_workflow_checkin and wsl_workflow_checkout to enable this feature.
RED-11953	Added new endpoints to the RED metadata service, objectsExportByName and jobsExportByName, that export metadata in a GIT friendly format.
RED-11959	Deployment Application Creation via command line now accepts a specific set of objects to deploy based on a JSON structure that RED Workflow scripts produce.
RED-11955	RedCli commands on script, procedure and templates now support an 'export-all' option, useful for GIT integrations. Additionally single export allows specifying a directory for auto creation of the filename and extension for the object.
RED-11759	Updated the built in Java JRE version to openjdk 11.0.25
RED-11556	Added merge mode to application deployment for Source Mappings when deploying from WhereScape 3D
RED-11942	Add Scheduler API environment variables to all script executions to support actions like releasing another job via scripts.
RED-12036	Azkaban to RED metadata resilience feature now logs the failure reason during reconnection scenarios.
RED-11958	RED UI now accepts the Scheduler Script Output Protocol as well as the traditional script output protocol.
RED-12063	Updated wsl_scheduler_profile_maintenance to include the special row for the Scheduler API profile record.
RED-12050	Improved wsl_scheduler_publish to work with runtime connections that do not specify a work directory.

Fixes

JIRA	Release Note
RED-11641	Fixed Azkaban Unsupported Object Type error when scripts have [TABLEOWNER].TABLE_NAME references to Retro Objects.
RED-12029	Fixed issue where Windows and Linux loads were going through legacy load methods through the UI.
RED-12028	Prevent legacy GetKey function popups for dimensional models.
RED-12054	Teradata TPT Routine Load Table setting now exposed via templates.
RED-12043	Fixed issue where bulk regenerate load scripts fails for Named Targets when load type is not Script Based Load.
RED-11932	Fixed Azkaban NullPointerException when running loads from Windows or Linux source connections.
RED-11974	Fixed issue where interactive processing via scripts could fail with "<work_dir> contains an incorrect path" in some repositories.
RED-11887	Fixed issue with remapping Filegroups during application deployment with RedCli
RED-11994	RedDeploy and RedCli now transfer relationships metadata to to RED from 3D exports.
RED-12004	Table properties Update/Custom Type drop-downs now default to the correct type, script or procedure, based on the assigned default template type.
RED-11935	Fixed RedSetupWizard Target Connection page auto-scrolling issues.
RED-12015	Fixed UI issues when converting existing Facts to Partitioned Facts in RED 10.3
RED-12016	Fixed issue where Optional Create Clause was not persisted for Load table objects.
RED-12047	Vulnerability fix in Azkaban for CVE-2024-53677
RED-11928	Improved Scheduler Publish and Lookup Scripts to remove trailing slashes in the configured Azkaban REST API URL which could cause job publishing failures.
RED-12057	Application Create via context menus and Batch Application Creation now includes the Associated Action Scripts of each object in the application. This avoids accidental decoupling of scripts and objects in the target.
RED-12070	Fixed a performance issue when running scripts from the RED UI in large repositories.

The following changes have been implemented since 10.4.0.0

Fixes

JIRA	Release Note
RED-12061	Fixed Azkaban error 'java.lang.Exception: Unsupported Object Type: 12' when processing scripts with references to Dim View objects.
RED-12088	Fixed performance issue on startup and display of object trees in RED introduced by RED 10.4.0.0 Host Script Icons feature.
RED-11917	Fixed an issue when deploying User Defined Views from 3D to RED.
RED-12098	Fixed error when updating object subtypes via the Maintain Object Types screens which could occur for upgraded repositories.
RED-12056	Fixed issue with Revert to Version functionality of Load table objects.
RED-11542	Improved RedCli Connection List-All command to include Database Type
RED-12082	RedCli object export-ddl and export-all-ddl now honor the --force arg to allow overwriting existing files.
RED-12084	Teradata TPT Routine Load Table setting now exposed via templates for all load types that use it.
RED-12081	RedCli script\|procedure\|template export - no longer requires the output file name when the new 'directory' arg is present as the output file names are auto-generated in this case.
RED-12077	Target settings 'Procedure Drop SQL' now works in Named Targets SQL, Teradata and Oracle
RED-12087	For Teradata Targets - TPT Load has been merged to the TPT Script Load type as in RED 10 every load is script based.
RED-11931	Fixed an issue preventing the running of standalone Batch and Unix scripts via the Azkaban Scheduler. Note: PowerShell and Python scripts were not affected.
RED-11846	When dropping entities the Nested Object Tree View in RED now correctly removes the object from the tree.

The following changes have been implemented since 10.4.0.1

Fixes and Improvements

JIRA	Release Note
RED-12099	Improved the performance of RedCli operations that use the template engine in Batch mode such as generate-routine and export-ddl. Improved the performance of regenerating Action Scripts in bulk via the RED UI.
RED-12091	RED SchedulerUtils.jar has a new method that allows running RED script objects standalone, for example: running a RED script for success and failure actions in jobs.
RED-11765	Improved the target mapping page in RedDeploy.exe so that matching targets are auto-mapped.
RED-11683	RED now allows nesting jobs as tasks of other jobs.
RED-12093	Improved performance of Linux script execution from the RED UI for large repositories.
RED-12268	Fixed an issue when generating Action Scripts of objects which had multibyte characters in the description.
RED-12275	Fixed an issue with 3D Deployment to RED where procedures on Oracle and Teradata were not assigned the target storage of their associated table object.
RED-12265	Resolved an issue with adding previously deprecated object types via the Object Maintenance wizard.
RED-12119	RedSetupWizard.exe now allows creating targets with '#' character for Oracle and Custom targets.
RED-12094	Improved the performance of displaying object tree views in RED on large repositories with many Groups and Projects.
RED-12076	Existing objects Table Properties Update/Custom Type drop-downs now default to the correct type, script or procedure, based on the assigned default template type.
RED-12072	Fixed display issues with the nested object tree when renaming, duplicating, or deleting objects.

Important Messages When Upgrading