New features

• Added additional logging for failing connections to AWS S3 buckets
• Added tooltips to the Storage Location list screen which indicates in which packages a storage location is used
• Added automatic restart logic for Oracle.
• Added the elapsed time in the Workers tab in the download of a run.

Bug fixes

• Fixed an issue in which the retrieval (during import) of data records from a previously exported file resulted in a ‘http 403 Forbidden’
• Fixed an issue in the FileExplorer in which the ‘Upload file’-popup and the ‘View file data’-popup showed a ‘403 Forbidden’ message.
• Fixed an issue in the FileExplorer in which the standard popup X (close) button was not visible
• Fixed an issue whereby an import run did not complete successfully and kept looping. This happened only when the entities in the package contained a cyclic dependency.
• Fixed an issue in which the import of binaries seemed to continue while the run itself was already done.
• Fixed an issue with a non-performant query related to checking the existence of record in the internal export key table.
• Fixed an Oracle concurrency issue when creating large amounts of users and/or tenants resulting in duplicates.
• Fixed an issue with exporting entities without a primary key that have large text fields (>=2000 characters) in an Oracle environment.
• Fixed an issue with the handling of entities with text-identifiers of length > 50. 
• Fixed an issue on the export overview screen. The overview initially showed an incorrect number of 'records to export' when tenant filtering was selected.
• Fixed an issue with registering the correct starttime of Workers in the download of a run.
• Added missing indexes to internal CDM tables

New features

• Added a new formatted text anonymization option specifying a list of options.
  Example: {Options:Male|Female|Unknown}
• Added a new numeric anonymization option specifying a list of options.
  Example: {Options:1|2|3|10}
• Upgraded the .NET Framework to version 4.8 for CDM Extensions
• Removed references to (old version of) System.Text.Json.dll which was no longer used in CDM Extensions.
• Import keys (see run logs) are now always added for Users and Tenants
• Skipping a mandatory foreign key is now possible if the delete rule of the relation is set to Ignorable.
• Added a warning to the export screen when attributes within the package are set to anonymize but the export setting prevents anonymization.
• Added encrypted user information to the user export files.
• Made the site property CDM_Base.WebServiceKey a secret
  As a result the site properties value will be reset by Outsystems (once). 
  Therefore, before upgrading, please save the value of the WebServiceKey and after upgrading, enter the saved value again 
• Added the webservice key to the environment screen (which requires Admin privileges)
• Added the new ‘Sequence’ anonymization option for integer-based attributes. The sequence generates a new unique integer for every row exported (for the specified attribute). Starting at the given starting point (Start from) and incrementing each row with the given Interval. So, starting from 10 with an interval of 2 would generate a sequence of 10, 12, 14 etc…. 
• Updated the installation documentation (only needed for first time install)
• Changed the CDM_LifeTimeWS webservice to ‘Internal Network Only’

Bug fixes

• Fixed a bug in which exported BPT processes were written to the Import storage location instead of the export storage location.
• Fixed an issue in which the User, Tenant and Espace modules were not added to the package during the upload of a new definition if the ‘Move Referenced Users’ was set.
• Fixed an issue with randomization, making it ‘more’ random.
• Fixed the colors of the environment sticker.
• Fixed an issue with the anonymization dropdown which sometimes contained duplicate options
• Fixed an issue which caused in an error during export in the following situation. When the datatype of the primary key of entity P (Parent) is Text, and the datatype of the identifier of entity E (Extension) was of type ‘P Identifier’.
• Change some styling features like the logo and the CoolProfs tag in the footer.
• Minor performance updates

This version includes lots of new cool features such as 

- Data model comparison
- Performance enhancements
- Reporting of data inconsistencies
- Improved validations
- Soft key support
- Support for foreign keys to external tables
- Timezone conversion support

See the complete Release Notes at https://www.coolprofs.com/cdm-downloads-en/ 

New Features
·         Rewrotethe Delete functionality using (Light)BPT instead of timers. 

·         Removed the unused option ExcludeBinaries 

·         Added a package option to prevent the launch of new BPT processes during an import. Also removed the new events generated by OutSystems from the event queue. 

·         ‘Duplicateinsert’  errors are ignored when retrying an ImportFilePart worker. This accommodation the possibility to retry the inserts when during previous executions inserts were already committed. 

·         Added the generation of correct IBANs for the Netherlands, Belgium, France, Luxembourg, Denmark, and Germany.  When another country code is supplied, by default a dutch IBANis returned. 

·         Added a new delete validation warning for the situation that an entity A refers to an entity B in another catalog. In that case, the referential integrity is not guaranteed by the database and the data of entity B can be deleted.  

·         Added the option to Move the ServiceCenter tenant entity

·         Improved the performance of the screens on which the list of modules and the list of entities are shown.

 Fixes

·         Fixed an issue whereby the export of binaries failed when no binaries were found with a length under the max binary size limit. 

·         Fixed a performance issue with retrieving the entities from a module that contains a large number of entities. 

·         Fixed an issue with an incorrect catalog name for the internal CDM tables when the CDM is installed in a separate catalog. 

·         Fixed an issue with replacing an attribute value during export 

·         Implemented a workaround to deal with a bug in some OutSystems platforms on MSSQL whereby the tables are not represented in the SYS.ALL_OBJECTS table. 

·       Fixed an issue with retrieving the entity definition information when that entity resided in a different catalog than the CDM itself. 

·       Fixed an issue whereby data that referred to a removed record of a static entity with a non-auto number identifier resulted in an error. 

·       Fixed an issue by preventing the deletion of the initial records in the event tables (osevt*). 

·       Fixed an issue with getting entities from the database based on System tables type = ‘U’. In some situations, user_tables have a NULL value. This prevented from opening the modules inside the packages 

·       Fixed an issue whereby inserts in the export key table resulted in an error regarding data conversions from int32 to String.