Services Framework version 2021-05-20 Resolved Issues

ImportSortTemplate.jsp: Changed file creation timestamp format to use the Enterworks.properties "epim.fileTimestampFormat" property.

AutomatedSortSpecification: Replaced hard-coded timestamp formats with epim.timestampFormat, epim.timestamp2Format, and epim.compactTimestampMsFormat properties.

ProcessAutomatedSort: Replaced hard-coded timestamp formats with epim.timestampFormat, epim.timestamp2Format, and epim.compactTimestampMsFormat properties.

ChangeNotificationQueue: Added index on ChangeNotificationQueue table to improve performance.

ChangeNotificationTranslationQueue: Added index on ChangeNotificationTranslationQueue table to improve performance.

ChangeNotificationWorkItemQueue: Added index on ChangeNotificationWorkItemQueue table to improve performance.

Change Notification Transformation Trigger: Replaced hard-coded date format with epim.dateFormat property.

Change Notification Translation Trigger: Replaced hard-coded timestamp format with epim.timestampFormat property.

Change Notification Trigger: Replaced hard-coded timestamp and 1970 date formats with epim.timestampFormat, and epim.timestamp1970 properties; changed hardcoded timestamp format for ||CURRENT_DATETIME|| reference to epim.compactTimestampMsFormat property.

BackupForDeployment.bat: Added support to backup both jbossMaster/jbossSlaveX as well as jbossController/jbossWorkerX to support old and new configurations.

ExtractHibernateProperties.bat: Created to extract the Hibernate.properties file from the epimServer.ear file.

RestoreHibernateProperties.bat: Created to restore the modified Hibernate.properties file in the epimServer.ear file.

CompareEnableServerExtract_Core.sql: Removed Export Now, Last Scheduled Export Datetime, Next Export Datetime attributes from the Scheduled Exports report. Removed Import Now attribute from the Scheduled Imports report. Removed Promote Now attribute from Scheduled Promotions report.

CompareEnableServerExtract_SQL.sql: Added section listing database table triggers.

ServicesEmail: Added index on the ServicesEmail table to improve performance.

epim.compactTimestampFormat: Replaces hard-coded values for the value set by this property. Default is yyyyMMddHHmmss.

epim.compactTimestampMsFormat: Replaces hard-coded values for the value set by this property. Default is yyyyMMddHHmmssSS.

epim.date2Format: Replaces hard-coded values for the value set by this property. Default is MM-dd-yyyy.

epim.excelDateFormat: Replaces hard-coded values for the value set by this property. Default is dd/MM/yyyy.

epim.fileTimestampFormat: Replaces hard-coded values for the value set by this property, intended to be used when needing the date and time embedded in a file name. Default is: yyyy-MM-dd_HH-mm-ss.

epim.locale: Identifies the locale for messages to appear in the appropriate language. NOTE: this is a placeholder for producing messages in different languages. Currently only English (en) is supported.

epim.sqlDateFormat: Specifies the SQL Server CONVERT() style to use for formatting the date. Default is 101.

epim.sqlTimeFormat: Specifies the SQL Server CONVERT() style to use for formatting the time. Default is 108.

epim.timeFormat: Replaces hard-coded values for time with the value set by this property, used for the Active Times Schedule settings for Scheduled Exports, Imports, and Promotions. Default is "HH:mm:ss".

epim.timestamp1970: Replaces hard-coded 1970 timestamp used to find all records when comparing dates. Default is 01/01/1970 00:00:00.

epim.timestamp2Format: Replaces hard-coded values for the value set by this property. Default is MM-dd-yyyy HH:mm:ss.

epim.timestamp3Format: Replaces hard-coded values for the value set by this property. Default is yyyy/MM/dd HH:mm:ss.

Callout BIC Template: Refined source template files. Added UI properties files for en and enUS languages.

Advance Work Item BIC: Corrected setting of work item properties in the work item being advanced.

BaseCalloutBic: Removed unused fileTimestampFormat attribute. If this is used in any custom Callout BIC implementations, it will need to be defined locally.

Delete Saved Set BIC: Deletes the designated saved set.

Flow Monitor BIC: Replaced hard-coded timestamp format with epim.timestampFormat property.

Lock Workflow BIC: Set %sys.workitem.uid% as default for workItemId input parameter.

Safe Purge Completed Work Items BIC: Replacement for the Purge Completed Work Items activity to safely purge completed work items without severing active work items at manual activities. All interactive workflows should be updated to use this BIC instead of the old one.

SQL Workflow Notification: Replaced hard-coded date format with epim.timestampFormat property.

SyncEPXUsersWithEnable BIC: Replaced hard-coded date and time formats with epim.sqlDateFormat and epim.sqlTimeFormat properties.

Unlock Workflow BIC: Set %sys.workitem.uid% as default for workItemId input parameter. Locking: disabled unlock/detach verification processing since the lock may have been affected by other operations between the unlock/detach and the verification and only treat failure to run SQL as a fatal error.

Validate Submission Form BIC: Validates the required parameters in the submission form assigned to the designated manual activity. This makes it easier to incorporate user submission validation into each workflow.

Workflow Notification BIC: Replaced hard-coded timestamp format with epm.timestampFormat property

CreateUpdateFile: Replaced hard-coded timestamp with epim.fileTimestampFormat property.

ProcessTaxonomyTemplateNodeList: Replaced hard-coded timestamp with epim.compactTimestampFormat property.

BaseCustomProcessFile: Replaced hard-coded timestamp formats with epim.fileTimestampFormat and epim.timestamp3Format properties.

PreProcessXLSXAddFields: Replaced hard-coded date format with epim.dateFormat.

ProcessPortalChanges: Replaced hard-coded timestamp formats with epim.fileTimestampFormat, and epim.compactTimestampFormat properties.

ProcessPortalReviewFeedback: Replaced hard-coded timestamp formats with epim.fileTimestampFormat, and epim.compactTimestampFormat properties.

ProcessLanguageTranslationRequest post-processor: Replaced hard-coded date format with epim.dateFormat property.

ProcessLanguageTranslationResponse pre-processor: Replaced hard-coded date format with epim.dateFormat property.

BaseCustomInboundMQMsgProc: Replaced hard-coded timestamp format with epim.timestampFormat property.

BaseCustomMQ: Replaced hard-coded date and timestamp formats with epim.dateFormat and epim.fileTimestampFormat properties.

BaseMQ: Replaced hard-coded timestamp with epim.timestamp3Format property.

MessageQueueEPXHelper: Replaced hard-coded timestamp with epim.timestampFormat property.

MQMessage: Replaced hard-coded timestamp format with epim.timestamp3Format property.

PortalCalloutTrigger: Replaced hard-coded timestamp format with epim.timestampFormat property.

PortalDamCalloutTrigger: Replaced hard-coded timestamp format with epim.timestampFormat property.

PortalHelperBic: Replaced hard-coded date and timestamp formats with epim.timestampFormat, epim.timestamp2Format, epim.timestamp3Format, epim.dateFormat, epim.date2Format properties.

ImportMergeTemplate.jsp: Changed file creation timestamp format to use the Enterworks.properties "epim.fileTimestampFormat" property.

SubmitPublicationMergeForm.jsp: Changed file creation timestamp format to use the Enterworks.properties "epim.fileTimestampFormat" property.

ProcessPublicationMerge: Replaced hard-coded timestamp formats with epim.timestampFormat, epim.timestamp2Format, and epim.compactTimestampMsFormat properties.

PublicationMergeSpecification: Replaced hard-coded timestamp formats with epim.timestampFormat, epim.timestamp2Format, and epim.compactTimestampMsFormat properties.

Added setting of Print Hierarchy for Publication Export Templates, which ensures the Hierarchy-related columns are included in the publication export.

Cleanup of expired Export, Import, and Promotion jobs have been consolidated to a single process within the Scheduled Export Process workflow to avoid potential deadlocks in high-volume job environments.

Reinstated the attributes Export Include Images, Image Context, and ImageType, which were previously deprecated. These attributes are still used with Export Templates.

Created Attribute Name: Attribute was not being used so it has been moved to the DEPRECATED tab.

Replaced hard-coded date and timestamp formats to epim.dateFormat, epim.fileDateFormat, epim.timeFormat, epim.timestampFormat, epim.timestamp2Format, epim.timestamp3Format, epim.fileTimestampFormat, and epim.compactTimestampMsFormat properties.

Localization: Changed "Export Job", "Last Export", "This Export" messages in the Export_<job>.log file to use localized messages. Requires sfwMessages_<local>.properties files to be copied to the <drive>:\Enterworks\EPX\bin\conf folder.

Locking: Disabled unlock/detach verification processing since the lock may have been affected by other operations between the unlock/detach and the verification and only treat failure to run SQL as a fatal error.

Corrected setting of Print Hierarchy if Publication Template is selected for the Export Template.

Cleanup of expired Export, Import, and Promotion jobs have been consolidated to a single process within the Scheduled Export Process workflow to avoid potential deadlocks in high-volume job environments.

Replaced hard-coded date and timestamp formats to epim.dateFormat, epim.fileDateFormat, epim.timeFormat, epim.timestampFormat, epim.timestamp2Format, epim.timestamp3Format, epim.fileTimestampFormat, and epim.compactTimestampMsFormat properties.

Locking: disabled unlock/detach verification processing since the lock may have been affected by other operations between the unlock/detach and the verification and only treat failure to run SQL as a fatal error.

Cleanup of expired Export, Import, and Promotion jobs have been consolidated to a single process within the Scheduled Export Process workflow to avoid potential deadlocks in high-volume job environments.

Replaced hard-coded date and timestamp formats to epim.dateFormat, epim.fileDateFormat, epim.timeFormat, epim.timestampFormat, epim.timestamp2Format, epim.timestamp3Format, epim.fileTimestampFormat, and epim.compactTimestampMsFormat properties.

Locking: Disabled unlock/detach verification processing since the lock may have been affected by other operations between the unlock/detach and the verification, and only treat failure to run SQL as a fatal error.

CopyOrCreateCategoryAttributeAssociationOrder.sql: Contains SQL commands to extract Category Attribute association attribute sequence (for each taxonomy node) in the form of SQL commands that can be run on a target system to set the attribute sequence to match the source.

The output includes all attributes defined for the repository, plus the following columns:

• ITEM_ID: InternalRecordId for the record. Changes to the same repository record will be grouped together and sorted by ENTRY_DATE.

• MODIFY_ACTION: Identifies the action for which the history record was created.

• USER_LOGIN: Login name of the user who caused the history record to be created.

• ENTRY_DATETIME: Date and time the history record was created. If NULL, the record shows the current values.

• MODIFICATION_DATETIME: Date and time at which the values were changed. This will be sometime before the ENTRY_DATETIME value. When consecutive history records are for the same repository record, the MODIFICATION_DATETIME value will be very close to the ENTRY_DATETIME of the previous record.

ViewActiveWorkItems.jsp: Updated page to use the Enterworks.properties "epim.dateFormat" property for formatting the dates of when work items were created or last modified.

EpimUtils: Replaced hard-coded timestamp formats with epim.sqlDateFormat and epim.sqlTimeFormat properties.

DeleteWorkItemFromEnable.sql: Removed hard reference to "epx" database and replaced with parameter reference.

DamHelperBIC: Replaced hard-coded date and timestamp formats with epim.fileTimestampFormat, epim.dateFormat, epim.date2Format, epim.timestampFormat, and epim.timestamp2Format properties.

HelperBic: Replaced hard-coded date and timestamp formats with epim.dateFormat, epim.date2Format, epim.timestampFormat, and epim.timestamp2Format properties.