Page History
WhereScape is pleased to announce that WhereScape RED 10.4.0.0 4 is now available.
This release of RED is compatible with WhereScape 3D 9.0 versions and up.
...
- Host Script Objects assigned to a Workflow script type will appear in most context menus in RED and when selected will execute the script and provide a file containing the objects contained by the context:
In the example results below the Export DDL script contained the example 'Print Context' script from the Workflow scripts section of the documentation.
- Host Script Languages can now have specific icons assigned (via Host Script Language maintenance):
...
- 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.
- Added new commands to RedCli, 'object export-ddl' and 'object export-all-ddl' which generate and export create ddl from an object's associated templates.
- Added new endpoints to the RED metadata service, objectsExportByName and jobsExportByName, that export metadata in a GIT friendly format.
- Deployment Application Creation via command line now accepts a specific set of objects to deploy based on the JSON structure that RED Workflow scripts produce.
- 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.
- Added Scheduler API environment variables to all script executions to support actions like releasing another job via scripts.
...
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.
- Option: ‘Existing Source Mapping Sets will be’
- Replaced: [Default] Replaces the entire Source Mapping Set (Source Mappings can be removed in this mode)
- Merged using Application: Merges the Sets, resolving conflicts by deploying Source Mappings from this Application - Add and Update.
- Merged using Repository: Merges the Sets, resolving conflicts by retaining Source Mappings in the Repository - Add only.
...
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. |
Detailed Changes in RED 10.4.0.1
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. |
Detailed Changes in RED 10.4.0.2
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. |
Detailed Changes in RED 10.4.0.3
The following changes have been implemented since 10.4.0.2
Fixes and Improvements
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. |
Detailed Changes in RED 10.4.0.4
The following changes have been implemented since 10.4.0.3
Fixes
JIRA | Release Note |
| RED-12347 | Fixed a 3D export to RED issue where Named Targets; SQL Server, Oracle and Teradata were unable to be resolved during deployment. |
| Anchor | ||||
|---|---|---|---|---|
|
...