Semarchy xDM 2025.1 release notes

MDM-7254: With PostgreSQL, the application server hosting the xDM instance and the database server must be in the same timezone to avoid inconsistent dates in the integration loads.

MDM-7917: A boolean field default value is set to null when creating a record and to false when editing it.

MDM-7949: A model with a physical column name using a reserved name raises a validation error but can be deployed.

MDM-8034: When stopping xDM using the Tomcat Manager, a Severe message is logged with org.apache.catalina.loader.WebappClassLoaderBase.checkThreadLocalMapForLeaks…​. This message is a known Tomcat issue that can be ignored.

MDM-8703: Data import from Excel does not properly handle dates before February 28, 1900.

MDM-8977: Changing a reference to a fuzzy-matching entity while authoring a master record is not taken into account.

MDM-9184: Existing FS_ and FP_ reference column values in a basic entity are overwritten by an enricher when this record is modified by the API or by authoring.

MDM-10193: When a record in an entity is updated, records with the same ID in inheriting entities are also updated.

MDM-10269: Using the SEM_NUMBER_TO_CHAR function with a string argument does not raise a model validation error but fails with an invalid number error in the log.

MDM-10319: Authoring the same record in two different browser windows makes the second authoring fail with a java.lang.IllegalStateException: Current Step (products) should be a form step error.

MDM-10738: Duplicate flexElement error occurs at runtime when using a transition named like a form element (e.g., "field", "container") in a business view.

MDM-12415: Long-integer values higher than 9223372036854700 raise errors when authoring (Invalid ID for data type (longInteger)) or browsing (<entity name> not found) records.

MDM-13099: When moving an attribute from one group to another governed by a different survivorship rule, any overridden value within this attribute causes all other attributes in the new group to be considered overridden as well. Consequently, the values of these attributes may be nullified during the subsequent execution of the certification process, unless override values have previously been defined. To minimize potential negative impacts on data consistency and accuracy, designers should consider moving attributes with pre-existing overridden values to a group that does not include any other attributes.

MDM-13176: REST clients have been enhanced to address limitations when handling responses with empty or null bodies and to support additional 2xx status codes. These updates ensure broader compatibility with standard HTTP responses, particularly 202 Accepted and 204 No Content.

MDM-14347: Email notifications can now be configured for workflow instances and user task events to notify candidates, assignees, and administrators of key workflow events, including task assignments, task expiration dates, and workflow due dates. Additionally, users with specific roles can now receive email notifications when a task reaches its time limit.

MDM-14725: Semarchy xDM supports PostgreSQL 16 across on-premises installations and cloud platforms, including Azure Database for PostgreSQL - Flexible Server, Amazon RDS for PostgreSQL, and Amazon Aurora PostgreSQL.

MDM-15834: Designers can now create custom SemQL expressions to define fuzzy lookup rules for matching parent and child records. These rules can be used to either automatically populate a reference relationship through an enricher or provide suggestions to users within steppers, based on the similarity between the parent and child records.

MDM-15835: A new Fuzzy lookup classification enricher is available to automatically classify records by applying SemQL-based fuzzy lookup rules that assess attribute similarity and compare child records with parent records. The enricher then uses the results from these rules to generate a lookup score and identify the most suitable reference. In MDM applications, the enricher integrates with steppers to automatically populate reference relationships. This enricher serves as an alternative to AI-based classification methods, offering a rule-based approach for categorizing data.

MDM-15924: When configuring a reference picker within a stepper, the new Fuzzy Lookup Rule property allows records to be filtered based on a specified fuzzy lookup rule. This property applies to both auto-complete lists and collection table views, leveraging fuzzy logic to suggest more precise and contextually relevant record options for users to select.

MDM-15925: To help users make more informed and accurate reference selections when using fuzzy lookup capabilities, a relevance score is now displayed for each record in both auto-complete lists and collection picker table views. The score, calculated based on the applied fuzzy lookup rule, determines how records are filtered and sorted. In a collection’s table view, users can toggle between filtered results and a full list of available results using the Filter by Fuzzy Lookup button. The name of the applied fuzzy lookup rule is displayed in a tooltip for this toggle button.

MDM-15796: During model validation, users may encounter the warning message: One or several workflow definitions contain warnings. even when no data-driven workflows have been created in the Workflow Builder.

MDM-15810: When using the Mass Update action in an MDM application, users with read-only access to an entity can still modify or remove data from its attributes, despite receiving warnings that indicate insufficient permissions.

MDM-15907: In an MDM application, when a hyperlink field is configured with a string datatype, using URL as the link source and set to open in a new window, the Display Text value is rendered incorrectly in the collection view, appearing cut off from the bottom. This issue occurs specifically when there is only a single-line value in each column of the collection.

MDM-15960: During model validation, if an enricher output references a non-existent attribute, a warning is displayed instead of an error. Additionally, trying to access documentation for affected items in the MDM application’s user interface triggers an error message, indicating that the documentation is unavailable or inaccessible.

MDM-16081: The Platform Administration section of the REST API documentation for the PUT method on the admin/users endpoint incorrectly lists BasicAuth as a supported authentication mode. An API key is required to successfully use this endpoint for user replacement.

MDM-16092: Third-party library upgrade: Apache Commons IO.

MDM-16102: The SEQ_NEXTVAL function implementation for Snowflake leads to improper sequence value generation.

MDM-16107: When using Snowflake as the database system, paginated queries generated by DataPageJdbcHelper return inconsistent and unpredictable pagination results.

MDM-16108: A validation error stating Some workflow definitions are not valid appears after validating a model in the Application Builder. Additionally, in the Workflow Builder, the error The root entity and its child entities manipulated in the selected stepper must be declared in the Entities section of this workflow definition occurs inconsistently, even when all required entities are correctly declared.

MDM-16120: In Oracle database environments, clicking the application icon on the xDM welcome page causes an infinite loading loop and triggers a java.sql.SQLSyntaxErrorException error.

MDM-16125: With the optimization parameter xdm.namedqueries.singlerecordexpressions.optimise enabled, calls to named queries fail in the following scenarios: when a named query of type Single Record Expression includes a reference relationship that targets a foreign attribute with a name differing from that of the referenced entity; and when a SemQL expression is specified at a non-root level within the query, which triggers an invalid SemQL request error.

MDM-16129: After upgrading to version 2024.1.8, validation rules using square brackets in LIKE statements may fail in SQL Server environments, potentially resulting in valid data being incorrectly rejected. This issue is associated with the fix for MDM-15633. Users can disable this fix by setting the optional system property com.semarchy.xdm.sqlserver.escapeSquareBracketsInLikeExpressions to false if reverting to the previous behavior is required.

MDM-16137: When entering values for attributes of type decimal, an incorrect error message is displayed if the total digit count exceeds the allowed limit of 21 digits. Instead of indicating the maximum digit limit for the value, the error incorrectly refers to the number of decimal digits, even when none are entered.

MDM-16160: When a collection table contains a column with HTML and JavaScript embedded within the value property, the resolved content fails to display immediately. The correct content becomes visible only after resizing the table’s column.

MDM-16161: When authoring a golden record for a fuzzy-matching entity, attempting to update the reference to a parent fuzzy-matching entity using the parent’s FDN attribute does not update the parent reference (FID or FDN attributes) during the certification process.

MDM-16196: Accessing the Semarchy login page causes an increase in the number of open cursors. These cursors do not close automatically, potentially leading to an ORA-01000: maximum open cursors exceeded error on Oracle databases.

MDM-16197: When using the Collection picker type in a reference selection form, the results list in the dialog displays no left margin, with the text in the first column aligned directly with the left edge of the window.

MDM-16201: Third-party library upgrade: Netty common.

MDM-16204: Exporting data from an MDM application’s interface to CSV or Excel formats does not preserve the date format specified in the user profile, resulting in inconsistencies when the data is viewed in external tools like Excel.

MDM-16234: In the My Tasks interface, a Missing named parameters error occurs when the value property of a column in the selected task’s collection contains a SemQL expression with a colon (:), such as in timestamp formats. This error prevents the collection from being displayed.

MDM-16257: Third-party component upgrade: Snowflake JDBC driver.

MDM-16475: When configuring a collection, if a column is set as a component of type Hyperlink and the Display Text property contains an apostrophe ('), no data is displayed for that column or any subsequent columns. This issue occurs regardless of whether the display text is set using a literal value or a SemQL expression containing an apostrophe. Additionally, no errors are logged in the PDE log.

MDM-16501: SMTP servers fail to send candidate or assignee notifications if the application logo is missing from the image bank. This issue occurs without any error being logged in the PDE log.