Bugfixes

• Fixed an issue with handling circular dependencies which resulted in an infinity loop while importing or deleting. In the previous version the CDM (falsely) assumed that within a circular dependency chain there is always one dependency that is optional. However, there is also another possibility. Namely that all dependencies within the chain are mandatory and that the delete rule for at least one the of dependencies is set to ‘Ignore’.
• Fixed an issue with deletion of files and (binary) directories on storage locations when re-exporting. During export the files and directories of previous export are deleted. For large exports this sometimes resulted in a timeout.

New features

• Added a CDM_Viewer role which allows read only access to package definitions, monitoring and run logs. To allows users to only have read only access to those screens grant the CDM_User (=base role) and CDM_Viewer role.
• Added the CDM_RunLogs.CleanupRunLogs timer to cleanup old run logs. This timer uses the site property CDM_Runlogs.NrDaysToKeepRunLogs (default value 14). When run, the timer will delete all run logs ‘older’ than indicated by the site property. The timer has no default schedule
• Added the option to delete monitoring data for all runs.
• Added the site property DeletesPerQueryForCleanup in the CDM_Dispatch_BL module to control the number of records deleted in a single query during internal cleanup. 
• Added retry functionality to overcome temporary network errors for SMB-storage locations. To fine tune the retry mechanism the following site properties are introduced in the CDM_FileSystemServices module. 
  • SMB_MaxNrOfAttempts The maximum number of attempts the CDM will perform for SMB operations that resulted in a 'Thread was being aborted'. Default 3. 
  • SMB_NrMilliSecWaitBetweenAttempts The average number of milliseconds to wait between SMB retry attempts. Default 3000.

Fixes

• Fixed an issue with removing a module or entity from a package and subsequently readding the same module or entity to the package when entity tracking is set.
• Fixed an issue with the cleanup (deletion) of records from the internal CDM run tables. 
• Fixed an issue with an CoolDataMover rest API in the CDM_API module which was not set to ‘Internal Network Only’
• Fixed an issue with deleting monitoring data for an individual run 
• Fixed an issue in which filenames and file sizes where not displayed in the FileExplorer when using an SMB storage location 
• Fixed an issue in which performing an import using matching on autonumber id’s resulted in an error.
• Fixed an issue with displaying progress information in the run logs when package runs are ‘flagged for cleanup’
• Renamed the CDM_RunTablesViewer module to CDM_RunLogs  

See the Cool Data Mover Release notes on coolprofs.com for a detailed overview of all changes.

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.