Changes in Execute 21.1.244

Notes

  • The Integration Agent installer is now included in Execute. Future updates will be automatically deployed.

Schema Changes

  • New column “DF_CONFIGURATION” added to SCHED and SCHED_H to store Dataflow integration configuration.

Featuresī¸

  • Future versions of the Integration Agent will automatically update themselves as necessary to avoid issues where integrations break because of incompatible Execute and Integration Agent versions. Note that manual steps are required to upgrade the Integration Agent this time, but future updates will happen automatically as required. #integration #166459

    The Execute Integration Agent, which facilitates integrations between Quorum-hosted Execute and on-prem systems, is now packaged with Execute and will, in the future, automatically update itself as required.

    If you are currently running the Integration Agent, however, you must manually update it as part of taking this Execute update. If this step is not taken, integrations using the Integration Agent will be broken.

    You can download the latest Integration Agent installer from Execute’s Tools > Configuration > Integration Agent Configuration menu.

    You’ll need to stop the current version of the Integration Agent (under your Windows Services panel).

    You can then run the downloaded installer on the server hosting the Integration Agent and install the Integration Agent over top of your existing Integration Agent installation’s root folder.

    Note that because the installer was downloaded from the web, you may need to unblock it before you’ll be able to run it by right clicking the downloaded file, selecting Properties, and then Unblock.

Enhancements

  • The Update Forecasts grid now supports sorting and filtering to make it more pleasant when managing large number of capital projects. #budget #161327
  • The Integration Agent status information has moved into the Help / About screen. #integration #179893
  • We’ve included the “ConnectionStringEncryptor.exe” helper in the Integration Agent package to make it easier for those who want to store encrypted database credentials in the databaseConnections.config file. #security #integration #216364
  • Administrators can now delete unneeded User Roles, Accounts, User Groups, Partners, and Position Rules. #admin #231563
  • Minor cosmetic enhancements and fixes to the new Job Scheduling capability. #opsched #237776
  • If exponents are your thing, you’ll be happy to know that Execute’s formulas now support the “Pow” function! #system #241158
  • Performance fixes to OData column validity checking on system startup. #integration #241699
  • Added the ability to synchronize schedules with Quorum’s Dataflow. #integration #243278

Bugs

  • Resolved an issue using the Integration Agent to replicate tables containing Small Int columns. #integration #236711
  • Fixed some minor issues where buttons in the schedule toolbar wouldn’t align properly when viewing a schedule in Execute #237228
  • Fixed permissions on the “Workflow/UpdateWorkflowInstances” API to ensure that it can not be called by a non-admin user. #security #workflow #api #239351
  • Resolved issue where the Schedule’s data grid would sometimes show activities in the wrong timezone. #opsched #240344
  • Removed the empty and unused “Project Report” tab from the Schedule’s Configuration tab. #opsched #240961
  • Resolved issue where the sorting of the Capital Summary and Monthly Capital Grids (Projects) were different. #budget #241067
  • Resolved an issue where the Integration Agent’s table replicator didn’t correctly handle Oracle numeric types with defined precision. #integration #241380
  • Fixed the sample plugin “replicate_queries_from_execute.config.sample” #integration #241568
  • Resolved issue where Data Selectors were unable to set boolean fields properly. #integration #241635
  • Improvemed the automatic recognition of URLs in text fields to better handle URLs containing parenthesis. #system #241881
  • Separators now display properly when viewing a Task pop-up window. #workflow #241936
  • Resolved an embarassing issue where the newly introduced API Keys were inadvertently consuming a license. #integration #242019
Ready to update?
  • For Quorum-hosted Aucerna Execute environments, email an upgrade request to Execute Support.
  • For on-prem instances of Execute:
    • Always ensure you have a recent backup of your Execute database before updating.
    • Download the installer from the Client Portal.