Changes since Execute 21.1.261

Schema Changes

  • Added additional fields for email reminders and notifications: NOTIFICATION.ALLOW_OPT_OUT, REMINDER.ALLOW_OPT_OUT, NOTIFICATION.PER_TASK and REMINDER.PER_TASK 21.1.267 #269583 #271420

Featuresī¸

  • Added a new streamlined Document Fetch API as part of Execute’s Advanced Data Export offering. This API makes it easier to slurp bulk data out of Execute to populate an internal data warehouse, or similar. #integration 21.1.273 #288479

    Execute’s new Document Fetch APIs provide a streamlined way to bulk extract documents from Execute.

    • A single streamlined API call vs. the Login > Run Report > Logout call for the current APIs.
    • Returns ALL data for request documents in a nice friendly machine readable JSON form.
    • Supports including calculated field values in the returned data (popular request from User Voice).
    • Easily filtering to return only documents modified since a provided date (makes it much easier to keep a remove warehouse up-to-date).

    Note: These APIs require the Execute Advanced Data Export (OData) module license.

    More information can be found in our New Postman-based API documentation.

  • Administrators can now allow users to opt-in/opt-out of specific email notifications and reminders, giving users more control (when appropriate), and reducing the administrative work for admins. #email 21.1.267 #264439

    When configuring email reminders and notifications, administrators can now…

    • Allow users to opt-out of receiving the notification/reminder by setting the Allow Opt-Out field on the notification/reminder to “Yes” (by default, users are not able to opt-out of reminders/notifications that they are included in)
    • Allow users to opt-in to receiving the notification/reminder by adding the new notify subscribers block to the reminder’s Recipients rule. i.e.

    Users are then able to adjust their email preferences from the new “Email Preferences” menu item under their name in the top-right of the Execute screen.

  • Users can now update values and entire columns directly from Execute’s browse screens. #system #ui 21.1.263 #258593

    If you’ve ever found yourself looking at a report in Execute’s browse screen and thought to yourself, ‘Gosh, that ain’t right. I need to update that!’, only to be slightly deterred by the prospect of actually opening the Well, AFE, Job, etc. to make the change… Have we got a thing for you!

    Users can now update individual values or entire columns right from the browse screens throughout Execute!

    From the browse screen, users can now click the toolbar’s pencil icon to enable bulk edit mode. This puts a pencil in each editable cell in your browse report which will allow updating the cell without leaving the report. In addition, the new “Bulk Update” option under the column dropdown allows a user to update the entire column (respecting any filters you have, of course).

    This new functionality respects the user’s edit permissions and will only allow updates to data they could have changed normally.

    Here is a quick demo:

Enhancements

  • Improvements to calculated field performance for formulas that involved a divide by zero. #performance 21.1.274 #291058
  • Browse reports (and many other report tabs) now support frozen titles, and columns using the new pushpin icon. #reporting 21.1.274 #296096
  • Upgraded 3rd party library (underscore.js) to eliminate a potential security vulnerability. #security 21.1.274 #298303
  • The new Show Field Usage function takes a while to work on very large record types. We’ve added a loading bar so that you won’t be left wondering, “Is it working?” #admin 21.1.273 #288972
  • Updated HTTP caching headers to improve page load performance across the system. #system #performance 21.1.273 #288982
  • Added additional guidance on the Plugin management screens to help administrators avoid common mistakes. #admin 21.1.272 #288483
  • Improved error messages with Quorum OnDemand Accounting (ODA) integration. #integration 21.1.272 #290415
  • Added support for new concurrent operational scheduling licenses. #opsched 21.1.271 #270672
  • We’ve made improvements to the Integration Agent’s auto-update mechanism to make it more reliable for organizations with restrictive firewalls. #integration 21.1.271 #279370
  • We’ve made some improvements to the error messages returned by our Integration Agent so that troubleshooting is a whole lot easier when things don’t go according to plan. #integration #valnav 21.1.270 #265027
  • We’ve significantly improved the import speed for new activities on a busy schedule. In our test of importing 7,300 rows, we reduced the import time from 4.5 minutes to a brisk 7 seconds (a time savings of one metric coffee break!). #performance #opsched 21.1.270 #268392
  • A bit of spring cleaning on the Integration Agent to ensure things keep running smoothly. #integration agent 21.1.270 #268543
  • To keep Execute’s Job Scheduling feeling snappy, we’ve limited the number of rows shown in the Job Hopper to 1000. Users will see a warning if they are seeing a partial result set, and searching will still search all rows and just return the (maximum 1000) matching rows. #performance #ui #opsched 21.1.270 #269387
  • We’ve reduced the volume of schedule data we read from the Execute server on each schedule change. This will substantially improve the performance of operational scheduling for large schedules and users with high-latency Internet connections. #performance #ui #opsched 21.1.270 #269388
  • We’ve seriously reduced the amount of data loaded, and the number of API calls made when loading a tab in Execute. This has the effect of substantially improving tab loading/switching performance, especially for very large (many custom fields) documents and users with high-latency Internet links. #performance #ui 21.1.270 #274567
  • Execute’ Support Package Generator is great for sending a copy of your environment’s configuration to Quorum for help. Unfortunately, generating the support package was quite slow for certain configurations. We’ve made some improvements to the speed and memory usage for these configurations. #performance #system #admin 21.1.270 #275762
  • Execute’s Data Warehouse feature ensures Execute data is efficiently replicated in an external AzureSQL or Snowflake. Sometimes, however, if you made a pile of changes in Execute, syncing those changes into the warehouse could take a bit of time. If you tried restarting Execute while that was happening, it would apparently hang without any obvious indication of why. We’ve added some logging to make it easier to see what’s going on. #performance #integration 21.1.270 #275780
  • Document Synchronization and Bulk Loads could perform poorly when dealing with very large numbers of records with a unique validation rule (such as PARTNERS, ACCOUNTS, …). In one environment with ~150k partners, the system would take many seconds to process each partner. With this enhancement, that same environment is loading records at a blazing 300 pps (partners per second). #performance #integration 21.1.270 #279727
  • We’ve made some improvements to responsiveness when pasting large amounts of data from Excel (using our import/update multiple record functionality). #performance 21.1.270 #280994 #280995
  • We’ve continued to clean-up and finesse our Data Selector sample configuration files to make them easier to understand and implement. #plugins 21.1.270 #281351
  • Huge speed improvement when using the job hopper to add jobs to a large schedule. #performance #opsched 21.1.269 #269386
  • Support for the 2.1 version of Peleoton’s APIs for Peloton-hosted instances of WellView and SiteView. #peloton #integration 21.1.267 #268639
  • Execute’s performance graphs (on the About page) now include past history instead of starting blank when you open the page. In addition, performance history is now included in the Execute Support Package to help our team troubleshoot issues. #system 21.1.267 #269390
  • Added configuration options to user.config to hide the default Wells and Jobs tabs on a Site, and the default Jobs tab on a Well. This is useful if you’ve built your own versions of these tabs using Document Link Summary tabs. #well delivery #system 21.1.267 #276708
  • Added helpful comments to the Snowflake helper views to describe foreign-keys for document reference fields. Note that these comments only show when viewing the view definition (such as by querying the Information Schema). #integration 21.1.267 #280427
  • We’ve added the ability to make notifications and reminders for Workflow Tasks. Previously, the ability to customize and extend notifications for Advanced Workflows was limited. Now, using the new “Workflow Task” notification/reminder type, administrators have a lot more control. #email #well delivery #workflow 21.1.267 #269583 #271420

    When creating a new Notification or Reminder, administrators can now use the new “Workflow Task” document type to build custom notifications for workflow tasks which much greater control than was previously available.

    These new notification types allow building more complex rules like:

    To help get you started, we’ve created a new sample notifications for the Job (RTx) module:

    Note: There is currently a known issue that makes it impossible to build notifications when a task activated/reactivated and assigned to a user. We are aware of this and working on a fix in a coming release.

  • If you’ve ever looked at the Execute email notifications and thought, “Gosh. These emails sure look retro!”, we have good news. The Execute email notifications have received a fresh coat of paint and look much nicer! #email 21.1.267 #264438
  • Updated version of .NET SDK used by (and included in) Execute. #system #security 21.1.267 #276751
  • We’ve seen some occurrences of long-running jobs (imports, generating support packages) being resubmitted by something. This is occasionally causing issues like overloading the Execute service with invalid requests or importing duplicate records. While we continue to investigate the cause of this, we’ve added new logging which will record if/when this happens. In addition, the new Duplicate API Call Detection setting can be used to reject these duplicate requests if you are encountering problems in your environment. #system 21.1.267 #278529
  • Deprecated functionality where workflows on parent documents could include/reference fields from child documents. In practice, this functionality was unlikely to be used since it could only work in very specific cases. On startup, however, Execute will check for references of this type and, if encountered, will prevent the system from starting up. If this happens, revert to Execute 21.1.264 and contact Execute Support. #workflow 21.1.265 #248415

    Previously, Execute’s Advanced Workflows allowed administrators to reference fields (either as task-fields or in Blockly rules) from child documents. In practice, these references would rarely work (since the behaviour becomes ambiguous as soon as a parent record has multiple children of the same type) and this functionality has been removed.

    Specifically, we have removed:

    1. The ability for a Project-level workflow to reference fields on linked Wells or Sites
    2. The ability for a Site-level workflow to reference fields on linked Wells or Jobs
    3. The ability for a Well-level workflow to reference fields on linked Jobs

    As a safety check, Execute 265 and higher will check for these invalid references and, if encountered, will fail to start and the server log will contain a message like this:

    2024-05-06 11:17:01.613 [ERR] Exception: System.ApplicationException: Upgrade incomplete. Precondition failed for upgrade of database to version 30: There are 2 task paths that must be addressed. Please contact Execute Support.
    

    If this happens, revert to Execute 21.1.264 and contact Execute Support.

  • Technical updates to the Job’s (RTX) Partner tab. #security 21.1.264 #260186
  • Improved error message when the Integration Agent connecting to Execute is the wrong version. #integration 21.1.264 #262830
  • The configuration migration tool now copies inactive custom tabs (which are often used for sub-views). #integration 21.1.264 #265018
  • Added a “Drop Table” flag to the Integration Agent Table Replicator configuration. This allows the Integration Agent to automatically drop and recreate the target table when changes happen. #integration 21.1.264 #268182
  • Added support for expression-based event filtering when using Enteprise Events for non-AFE document types. #integration 21.1.264 #270877
  • Added the ability to import actuals from a CSV file located on a remote SFTP server. #integration 21.1.263 #267410
  • Added ‘filename’ as an option when building expressions in Dynamic Docs and SharePoint configurations. #integration 21.1.263 #267534
  • Removed legacy option for GIT-managed plugin files. This was never actually turned on for customer environments. #system 21.1.262 #258547
  • Added support for publishing data to Quorum’s DataHub. #integration 21.1.262 #267291

Bugs

  • Fixed an issue where a misconfigured plugin would cause the menubar to fail to load. #system 21.1.274 #245798
  • Fixed an error where users were unable to update activity duration on activities in Execute’s operational scheduling module. #opsched 21.1.274 #289480
  • Improved the clarity of error messages raised when a Document Link Summary view is misconfigured to make finding and fixing the mistake easier. #system 21.1.273 #253151
  • Fixed an annoying issue where switching schedule views would sometimes jump to a different view a few seconds later. #opsched 21.1.273 #288470
  • Fixes to the export of AFEs to Peloton-hosted SiteView (2.1 APIs). #integration #peloton 21.1.273 #291362
  • We resolved an issue where we were inadvertently creating automated document links to Project Snapshots. #system #budget 21.1.273 #291678
  • Resolved issue where Blockly rules referencing the now deprecated Advanced blocks would fail to compile. #workflow 21.1.272 #283239
  • Fixed issue where NET estimate was not correctly exported to Quorum OnDemand Accounting (ODA). #integration 21.1.272 #290332
  • Fixed an annoying issue where the route for review comment box would clear itself when you clicked outside of the comment box. #afe 21.1.271 #228443
  • Fixed an issue where document synchronizations would create multiple rows if the document’s visibility rule excluded the AFE Navigator Service User. #integration #system 21.1.271 #237917
  • We’ve ensured that errors when connecting to databases (such as using the Connection String Editor’s test button) don’t expose the connection string which may contain security credentials. #security #integration 21.1.271 #268092
  • We’ve added some additional safety checks to ensure you don’t accidentally bulk import the same data twice (causing duplication). #system 21.1.271 #268614
  • Resolved issue where the sample connection string for EXECUTE_INTERNAL wasn’t able to be copied into a plugin because of case-senstivity issues. #system 21.1.271 #269490
  • The system will now wait for all scheduled tasks to complete before shutting down. #system 21.1.271 #280989
  • Resolved an issue where the Integration Agent’s table replicator couldn’t handle null boolean values on SQL Server. #integration agent 21.1.270 #268904
  • We’ve eliminated a potential memory leak in Operational Scheduling where the detail grids (below the gantt) weren’t always cleaned up properly when we didn’t need them any more. #performance #opsched 21.1.270 #279943
  • Added a rate limiter to the new Duplicate API call checker to avoid overloading logs. #system 21.1.270 #284913
  • Execute will now prevent certain long-running and computationally expensive jobs (import/update multiple, and generate support package) from being started multiple times simultaneously. This would sometimes happen if a user rapidly clicked on the start button, causing the job to be submitted multiple times. In the case of imports, this could cause the data to be imported multiple times. #system 21.1.269 #274986
  • Resolved an issue where the support package would fail to generate successfully when including Document Metadata. This issue was introduced in the previous email enhancements because the newly added fields had unspecified field lengths (not a problem for Execute, but unexpected for the support package generator). #system 21.1.269 #281821
  • Resolved an issue where AFE Numbers containing “&” caused errors when exporting to ODA or ODW. #workflow 21.1.267 #267409
  • Resolved an issue where the /Documents/Field/UpdateMultiple API wouldn’t allow you to set top-level document fields. #api 21.1.267 #274988
  • Fixed the mail icons on the Job’s Team tab and restored the behavior where it would automatically populate the new email with a link to the Job. #well delivery 21.1.267 #277169
  • Fixed an embarrassing typo in the function description for all of our Table* formula functions. #formula 21.1.267 #280425
  • Resolved issue where the new bulk editing from browse screen feature would not work for workflow task reports. #reporting 21.1.267 #272576
  • Resolved issue where Export to QByte would fail when using the Integration Agent. #integration 21.1.264 #267950
  • Resolved issue where configuration migration would fail to match accounts on Overhead Rules. #admin 21.1.264 #271118
  • Improved output message when using the “Test” button on a Workflow Task’s Hide Rule. #admin 21.1.264 #271760
  • Resolved issue preventing the legacy reporting tool from connecting to Execute. #reporting 21.1.264 #272493
  • Resolved issue where choosing a contributor on a Job’s Team-tab would fail if the User Identifying Columns were modified from the default. #well delivery 21.1.264 #273009
  • Fixed the issue where the ‘Extension’ property when publishing Execute event data to a remote SFTP server was ignored. This meant that all the newly created files were given no extension, instead of whatever was configured. #integration 21.1.263 #268098
  • Resolved issue where the AFE’s release validation rule was being incorrectly invoked on Custom Document Actions. This prevented some plugins from working as expected. #afe 21.1.262 #267702
  • Resolved an issue where the Integration Agent was unable to connect to HTTP/HTTPS services. #integration 21.1.262 #267829
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.