New features

• Added a new entity option ‘Skip duplicates’ to the package definition. Checking this option will catch database errors for duplicate inserts and will skip the record that it is trying to insert, thereby effectively skipping duplicate inserts. This is useful in a non-matching scenario when, as a result of non unique lookups, duplicate entries would be inserted into extension tables.

Bug fixes

• Fixed an issue in which the retrieval (during import) of data records from a previously exported file still resulted in a ‘http 403 Forbidden’
• Fixed an issue in the FileExplorer in which the ‘View file data’-popup still showed a ‘403 Forbidden’ message.
• Fixed an issue in which a predefined match attribute could be unselected, but after unselecting could not be selected again

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

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.