Fullscreen Image

To view the full Lucernex Online Help, sign in to Lucernex and click Help > Online Help. If you do not have your organization's Lucernex link, contact your Administrator.

Accruent DataMart 7.0.126 Release Notes

This upgrade is available to DataMart customers on November 8, 2024.

New DataMart application

LUC-12201, LUC-9030, LUC-11899

We have completely refactored DataMart with new technology to make it more secure, robust, and efficient. DataMart is now a Spring Boot application built on newer more robust and secure technology such as JDK 21. Review the install and update guide for the new prerequisites and system requirements. These changes align with our microservices architecture and facilitate the future move to the cloud.

Log file viewer

LUC-12438

Use the new Log file viewer to search, sort, and filter logs. Filter different files across multiple types of log including information, warnings, and errors.

Specify record types to synchronize

LUC-10806, LUC-10569

You can now reduce DataMart run times on full brush and deltas for very large volumes of data. If the enableDatamartSyncObject feature switch is turned on in your firm, your Administrator can now specify the record types to be consumed from Lucernex. This reduces run times for full brush and deltas with very large volumes of data that currently take days to synchronize.

Your Administrator can now select Datamart Sync Objects in the Manage Firm Properties tab of the Manage Features page to configure root record and child record types .

For example, if you want to limit the Contract data in DataMart to Expense related record types only, configure:

  • Root Record: Contract

  • Child Record: ExpenseSetup, ExpenseSetup/ExpenseSchedule

Contact Accruent Support for further information.

Exclude record types

LUC-10568

When the new enableAuditIgnoreDocumentsAndFolders feature switch is turned on in your firm, deltas on file and folder uploads are not recognized unless there is another update in the same entity where files were updated. In that scenario, the delta picks up the other changes as well as files uploaded.

If the files are uploaded in one entity and record updates are done in another entity, the delta is not affected for the entity that files were uploaded.

Contact Accruent Support for further information.

Improvements and issues fixed

Component Summary Reference #

Password fields

You can now toggle visibility of characters in password fields and list commonly used IWMS DataMart servers when choosing a server.

LUC-12438

Expense Allocation fields

These Expense Allocation fields now show the same values in Lucernex Production and Datamart:

  • AssetAssociatedProjectEntityID

  • AssetID (FK Asset Table)

  • EffectiveDate

  • Notes

  • ContractID (FK Contract Table)

  • ExpenseSetupID (FK ExpenseSetup Table)

LUC-10934

Delta incremental update of target database

Full brush rebuild of the target database from scratch and delta now run successfully for Lx Admin, PS Admin and System Admin users.

LUC-10671

Full brush

Full brush now runs correctly when unicode characters are present if the new datamart.unicode property in the datamart.properties file is set to true.

LUC-10648

Session Management

Session management is improved so that inactive sessions are removed in accordance with the values set in your Company settings such as Inactive Session Timeout (Minutes) and Maximum Session Timeout (Hours). Contact your Accruent representative for these values.

LUC-11431

ErrorNotify email A large volume of ErrorNotify emails is no longer sent. LUC-10188

Mappings

You must now enter a minimum of two characters for the mapping Name.

LUC-12570

Delta run

When you add a new project to the IWMS Integrated Workplace Management System. This is the Lucernex app url that your organization uses. For example, lxretail.lucernex.com. , and start a delta incremental update of target database run, the run statistics now reflect the number of projects updated in the same way as a full brush rebuild of the target database from scratch.

LUC-12436

Delta run

When you complete a delta run after adding fields with case sensitive names, the fields are now listed in the correct alphabetical order within the Datamart run SQL table.

LUC-9351

Mappings

When you change the Global Fields First or Only Global Fields option on a mapping, a warning now displays to inform you that the next run is a full brush and that your tables will be repartitioned.

LUC-9102

Item count

DataMart's item count for Folder and Budget line items now correctly matches the IWMS Integrated Workplace Management System. This is the Lucernex app url that your organization uses. For example, lxretail.lucernex.com..

LUC-9082

Query

When running a query, the partition table now shows the correct number of Projects.

LUC-9614

API Servers

DataMart is now optimized to run in a clustered environment with load balanced DM API servers. This improves application stability and performance when deployed across multiple servers.

LUC-11022

Delta run

Delta runs now correctly show ModifiedByID and ModifiedDate with the latest changes for these scenarios:

  • Convert a member to a manager manually in Lucernex

  • Convert a member to a manager using spreadsheet import

  • Convert a manager to a member using spreadsheet import

LUC-9519

Server Tasks

Tasks in the IWMS server now correctly stop after the timeout period. This prevents unnecessary resource consumption and improves efficiency.

LUC-7688

Errors Only filter

The Errors Only filter now correctly filters the events in the Execution Events pane to only display error events.

LUC-12440

Error log

The error log no longer displays Invalid column name errors when a run is successful.

LUC-12296

Run statistics

When a full run completes, this is now correctly indicated in the Execution Statistics pane so that all bars display as completed.

LUC-12516

Error recovery

Unexpected errors no longer display during a run when IWMS Integrated Workplace Management System. This is the Lucernex app url that your organization uses. For example, lxretail.lucernex.com. is unavailable and once IWMS is available, the run recovers more quickly.

LUC-12539

Delta run

Delta runs no longer display XML parse errors with Lucernex 24.10.

LUC-10952

Delta run

User defined fields are now correctly set to NULL when the field no longer has a value.

LUC-7380

Mappings

The Database Name and Mapping Name fields are now limited to 20 characters. If you enter more than 20 characters a message displays, instructing you to enter up to 20 characters.

LUC-7716