WhereScape is pleased to announce that WhereScape RED 10.4.0.3 is now available.
This release of RED is compatible with WhereScape 3D 9.0 versions and up.
| Before upgrading, review the Important Messages when Upgrading for more information. |
Go to https://www1.wherescape.com to see available product versions and release notes for older versions.
Log into the WhereScape Support Portal to access downloads.
Access the User Guide here.
WhereScape presents RED 10.4 a new version of RED. The features implemented in this version are mainly focused on enabling 3rd party integrations with external tools like GIT, but also enhances the UI and enables the ability to add scripted workflows based on the current context in the RED UI.
Workflow scripts, when defined, will appear in the context menu throughout the RED UI. When clicking on them in any context menu, the underlying script will be executed and provided with the complete object list contained by the context. This allows for integration scripts to be written that can perform actions on lists of objects, such as: creating deployment applications, checking items in and out of GIT, running external tests on the objects selected, exporting data to catalog tools, backing up scripts to disk and more!
The following changes have been made to support this new feature:
In the example results below the Export DDL script contained the example 'Print Context' script from the Workflow scripts section of the documentation.
When deploying Objects with multiple Source Mappings via 3D Export to RED you can now control the merge behavior when updating existing Objects Source Mapping Sets. There is now a new option with three settings when deploying from 3D to RED.
This feature will be particularly useful to organizations with multiple development teams or projects affecting the same objects in RED, allowing them to deploy only the new Source Mappings that they have added and avoid deploying out-of-date changes to existing Source Mappings.
In addition to the major improvements above please see the following Detailed Changes section for the full list of customer fixes and improvements in this release.
The following changes have been implemented since 10.3.0.1
| 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. |
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
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
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. |
The following changes have been implemented since 10.4.0.3
JIRA | Release Note |
| RED-12090 | Implemented connection resilience for Application Deployment, added two new RedCli deployment args to control this new feature. New deployment args: ‘connection-timeout’ (time is seconds to wait for a connection, default=60) and ‘max-retry-count’ (max times to attempt reconnection during the deployment before failing, default 10) |
| RED-12266 | Fixed an issue affecting target Procedure based routine generation when metadata is on PostgreSQL 17 during 3D deployment to RED. |
| RED-12069 | Fixed an issue with 3D deployments to RED where the deployment would fail if there were no Load objects included in the deployment XML. |
| RED-12269 | Fixed RedDeploy issue with target mapping page for 3D created SQL Server target locations. |
| RED-12191 | Improved template engine performance in the following areas: Code generation from the RED UI, Application Deployment, RedCli Export All DDL command. |
| RED-12184 | Azkaban now updates the job stats for error warning and info counts, which allows the RED Scheduler tab to correctly signal job warnings. |
| RED-11982 | Improved RedCli error reporting when there are compilation errors for Procedure objects, these will now show as Target errors in the RedDeploy UI |
| RED-11409 | RED's plugin for Azkaban now creates unique file names within tasks to support generic Action Processing Scripts being run in parallel. |