Changes since Execute 21.1.244

Notes

  • This update fixes Document Synchronization plugins to respect the timezone configured in the plugin file. Previously, all dates were assumed to be in your server’s local time. This means that, upon upgrade, synchronized dates may change if the configured timezone in the plugin is not the same as the server’s timezone. 21.1.261
  • If you are using Execute’s out-of-the-box integration with Peloton-hosted WellView/SiteView, please note that previous versions of that integration will cease to function at the end of Feb 2024 and you must take additional steps to upgrade to the newest version and continue to use this integration beyond that date. 21.1.255 #243175
  • If you are currently using Execute’s legacy integration with SharePoint, please get in touch with Quorum Support prior to upgrading to this version. 21.1.246

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
  • Added a new field “IS_REMOVED_VERSION” to the AFE and AFE_H tables to differentiate between deleted AFEs and deleted AFE versions (unrevise/unsupplement) to support the new Undelete feature. 21.1.246

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:

  • If you’ve ever found yourself wondering “just where is this field used” or “is this field safe to remove”, we think you’ll like our new functionality that helps you answer those very questions. The new “References” tab on a field’s configuration screen shows you the rules, tabs, reports, etc. that make use of that field. #admin 21.1.257 #257716
  • Support was added for new Peloton 2.0 APIs for our integration with WellView/SiteView. #peloton 21.1.255 #243175

    This release includes support for Peloton’s new 2.0 APIs (affecting Peloton SaaS customers).

    Peloton has announced their plans to deprecate their existing APIs (used by previous versions of Execute’s integration with Peloton SaaS) by the end of February.

    Customers who wish to use/continue to use this integration must:

    1. Contact Peloton support and request written permission to enable this integration (cc’ing Execute Support). Peloton requires customers obtain written permission prior to integrating with third parties.
    2. Upgrade Execute to this version or later.
    3. Work with Execute Support to update their configuration to use the new integration.
  • Initial release of the Configuration Migration feature which makes it easier to migrate configuration from one environment (such as a TEST environment) to an another environment (such as PROD). This feature is new and still in active development. At this time, we strongly recommend working with someone from Quorum Professional Services if you need to make use of this tool. #admin #system 21.1.249 #239691
  • Improved support for integration with document management systems such as SharePoint and DynamicDocs. #system 21.1.246 #246071

    With this update, Execute now includes support for integrating with the following document management systems:

    • Quorum’s DynamicDocs
    • Microsoft’s SharePoint

    Execute now supports multiple pluggable “AttachmentStores” which can selectively take over the storage of attachments.

    • Each attachment store can decide which document(s) (AFE, Well, …) it should store attachments for.
    • Execute supports pushing and maintaining additional meta-data for each attachment to help searching/sorting/categorization/etc. in the document management system.

    This gives a great deal of flexibility. For example, you can use SharePoint for “approved” AFE attachments, DynamicDocs for Well-level attachments, and the built-in storage for everything else.

    Plugins for these integrations are found under plugins_available\integration\product_integrations\document_management.

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
  • Removed legacy 3rd party component on the Job’s Team Tab. #security 21.1.261 #260180
  • Added a new service health endpoint to simplify external monitoring of Execute services. #system 21.1.260 #254999
  • Improved the error message when an HTTP source is not found in the Integration Agent’s configuration. #integration 21.1.260 #259445
  • Added a new Regular Expression validation rule to allow building all manner of interesting field validation rules. i.e. numeric, serial numbers, phone numbers, … It even allows you to specify that the field should contain unique values. #system #admin 21.1.260 #259850
  • Document Link Summary Tabs now support Extended Document Links. #system 21.1.260 #262829
  • When building browse reports on Custom Tab configuration, administrators can now see the field’s display name and not just the database column name. #admin 21.1.259 #258791
  • Upgraded the 3rd party component used by the user permissions screen. #security 21.1.259 #259244
  • Improved documentation on the ‘Reset Task’ API. #integration 21.1.259 #259297
  • Replaced the 3rd party component on the ‘Set Document Type’ button on Notifications and Reminders. #security 21.1.259 #261077
  • Brand new API-based real-time export of approved AFEs from Execute into Quorum On Demand Accounting. #integration 21.1.258 #260257
  • Improved handling of minor account number formatting differences between On Demand Well Ops (WellEz) and Execute. For example, Execute having “100 / 01 " while ODW is configured with “100.01 " will no longer cause an issue when exporting AFEs and importing field estimates. #integration 21.1.258 #260479
  • Replaced the legacy component used on the Job’s Approval tab. #security 21.1.257 #260183
  • Replaced a legacy 3rd party component used by the header on a Job’s Discipline tabs. #security 21.1.256 #257877
  • Replaced a legacy 3rd party component used by the header on Discipline configuration tabs. #security 21.1.256 #258264
  • Improved error messages when exporting projects to Val Nav. #integration #valnav 21.1.256 #259893
  • Added a new ‘TABLE’ mode to Execute’s SQL Warehouse feature that separates the pushing of data to the warehouse, from the processing of that data into the helper views. This mode is intended for large environments, or those where the existing views aren’t performant. #integration 21.1.256 #260441
  • If you are a heavy user of document links, you can now create extended document links (see extended_document_link.config.sample). This allows you to show links for documents linked to other linked documents. And because that sentence left more questions than it answered, here is an example: A common setup is for a Pad Site to be linked to one or more Wells. A Well is linked to one or more Jobs. A Job is linked to an AFE. This feature allows you to say, “I’d like to see those AFEs that are linked to Jobs that are linked to the Wells on this pad as virtual document links on my Pad Site so that I can, among other things, make use of Execute’s formulas to give me a total AFE cost across all the Jobs on all the Wells on my Pad.” #admin 21.1.255 #257218
  • Replaced legacy components on the Job/RTx Discipline’s Configuration tab. #security 21.1.255 #257588
  • Administrators can now see the size of text fields from both the document’s field list and the “Field Info” browse report. Similarly, document reference fields now indicate which document type is referenced. Finally, calculated fields are also now marked as such, making it easier to identify which fields are calculated. #admin 21.1.255 #257711
  • Added new formula functions “DocumentLinkTextValueCombined” and “DocumentLinkChildrenTextValueCombined” to make it easier to quickly summarize field values from related documents, such as including a comma-separated list of Well UWIs on your Pad Site. #formula 21.1.255 #257318
  • We’ve added “Description” fields to store notes about workflow definitions and custom tabs to help administrators keep things nicely organized. #admin 21.1.255 #257212
  • Administrators using the browse screen to report on FIELD_INFO configuration will be pleased that we’ve added the “Editability Rule - Display Name” and “Visibility Rule - Display Name” fields to make it easier to figure out which rules are actually in use. #admin 21.1.255 #257213
  • If you find yourself selecting a lot of data using Execute’s Table Data Selectors, we’ve added “Select All” and “Select None” buttons to make life easier. While we were at it, we also added larger limits to the number of rows to show, and we’ve made Execute remember each user’s preferred number of rows. #system #ui 21.1.255 #257214
  • If you struggled to find the descriptions of available user privileges, you weren’t alone. We’ve renamed the “Administrator Privileges” to “Available Privileges” and added a link to this helpful list from the User Role configuration screen. By the way, you can also hold your mouse over a privilege while you are in the User Role configuration screen to see the description. #admin 21.1.255 #253801
  • Execute includes a cool feature where a user can request to be notified (by email) when another user moves their activities on a schedule. We’ve resolved a bug that prevented this notification from working if the user owned any undated activities. #opsched 21.1.255 #255857
  • Updated the Schedule View configuration documentation to reference “greater” and “less” than operators. #opsched 21.1.255 #256670
  • We’ve continued to clean-up the sample data selector plugin files. #plugins 21.1.255 #256784
  • Users reporting on Workflows and Workflow Task status will be happy that we’ve added columns for the root document type, root document display name, and workflow name. This makes this report much more useful! #workflow #reporting 21.1.255 #257213
  • If you have trouble finding columns in our detail-level reports, we have good news! We have adjusted the report builder’s “Available Columns” search to search on the full name of columns so that if you are searching for “partners” on an “AFE - Partners” report, you’ll actually see the partners columns as you’d expect. #admin 21.1.255 #257213
  • We’ve made it easier for administrators to create plugins (such as Data Selectors and Synchronizations) that point at the Execute database by adding a new database alias “EXECUTE_INTERNAL” which can be used in your plugin’s connection string. (Ex: “Connection List=server; Id=EXECUTE_INTERNAL”) #admin 21.1.253 #254272
  • Various performance improvements to Operational Scheduling #opsched 21.1.251 #244269
  • Having trouble finding a particular well or activity on your schedule? We have a thing for that! The new schedule search box makes it incredibly easy to find an activity that is hiding somewhere in your schedule! #opsched 21.1.251 #244269
  • Updated version of SQL Server database library. #system #security 21.1.249 #247055
  • Improved handling of newly added tasks when rolling out a workflow against a complete or mostly complete workflow instance. Tasks autocomplete if the tasks that immediately follow are also complete and the task is set to require manual completion or the task’s completion rule is met. #workflow 21.1.249 #247181
  • Updated integration with Dynamic Docs to work with the latest DynamicDocs APIs. #integration 21.1.249 #249213
  • Migrated the Job’s Copy Teams backend toolkit from Angular to React. This is part of a larger initiative to eliminate our dependency on an aging version of Angular. #security 21.1.247 #171883
  • Increased the default size for formula editing windows to make editing those monster formulas more pleasant than trying to peer at it four lines at a time. #system 21.1.247 #244477
  • A while ago, we added a great feature to Execute’s Document Synchronization to automatically inactivate records when they no longer appeared in the source data. Now, we’ll automatically reactivate those records if they come back! #integration 21.1.247 #245783
  • We’ve added a new “Copy from Sample " button when creating a new in-app plugin to make it much easier to preload your plugin with a sample from the plugins_available folder. #admin #system 21.1.247 #246432
  • Administrators with the “Manage Excel Templates " privilege can now upload and manage Excel Template Reports from Tools > Configuration > Manage Excel Template Reports. #admin #reporting 21.1.247 #246435
  • Added support for publishing Execute events to a file on a remote server using SFTP. #integration 21.1.247 #246490
  • Added new AFE-level calculated fields to allow reporting on reviewer and approver counts (both totals, and those who have completed their work). #afe 21.1.247 #247494
  • Changed the default minimum password length to 12 (doesn’t affect environments using SSO). #security 21.1.247 #247637
  • Added handy Select All / Select None buttons to the support package generation screen. #admin 21.1.247 #247724
  • The project reforecasting process now better identifies when a project needs forecasting, and better handles changes to historical AFE actuals (such as when changing mappings). #budget 21.1.246 #164376
  • Added a new AFE-level field “Available Project Capital” which shows the remaining capital available for an AFE (total capital available for allocation project activities less any AFEs allocated to those activities). This makes it easy to build business rules that alert the user when their AFE exceeds the available budget. #afe 21.1.246 #243837
  • Forced a “recalculate” when creating Excel Template Reports to resolve issues using those sheets directly in systems which don’t support Excel calculations natively. By the way, if you find it cumbersome to manage your Excel Template reports in Execute we’ll have a thing for that in the next update! #system 21.1.246 #244228
  • Added an alert when adding a connection string to a SQL Server database without enabling end-to-end encryption in the connection string (Encrypt=true). We strongly recommend enabling end-to-end encryption when configuring Execute to connect to any SQL / Azure SQL database over an untrusted network. #security #integration 21.1.246 #244240
  • We made the account group on accounts an optional field so make implementation easier for those of you who don’t need the cosmetic grouping of AFE costs by account group. In addition, this makes it possible to sync the list of accounts from a 3rd party system that doesn’t have a similar concept of Account Group. #afe 21.1.246 #244439
  • Accidentally deleted the wrong document? We’ve all done it. We’ve now added a “Undelete” action to deleted records that brings that document back from the dead. In general, the rule of thumb is that “if you can delete it, you can now undelete it!”. (Note that for AFEs specifically, Undelete is only available for AFEs deleted after taking this update.) #system 21.1.246 #244584
  • If you are a heavy user of Document Links, you’ll be overjoyed to know that you can now create summary tabs that list all linked documents of a specified type and give the administrator and the end-user the ability to control which columns they see. These are controlled by the new “plugins_available\customization\tabs\documentlinksummary.config.sample” plugin #system 21.1.246 #245826
  • Sample configuration for integration with Quorum’s OnDemand Accounting system #afe 21.1.246

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
  • Resolved issue where the timezone in Document Synchronization plugin files was being ignored. #integration 21.1.261 #263907
  • Resolved issue where custom tables exported to the SQL Warehouse / Azure SQL were empty. #integration 21.1.261 #266641
  • Resolved an issue where the task reactivation button would disappear when paging through tasks on large workflows. #workflow #admin 21.1.260 #257198
  • The WellEz Estimate Account Filter now respects the path specified in the plugin file. #integration #wellez 21.1.260 #265670
  • When we rolled out the new configuration migration functionality, we inadvertently locked down several of our implementation tool loaders to only work for administrators with the configuration migration privilege. We have restored the original permissions. #admin 21.1.259 #255269
  • Resolved an issue where long-running (greater than 30 minutes) jobs using the Integration Agent would fail. #integration 21.1.259 #258072
  • Updated the task banner (for Advanced Workflows) to use the document’s display name rather than the database name. #ui 21.1.259 #259954
  • Resolved an issue where large data sets could cause the Integration Agent to run out of memory. #integration 21.1.259 #261468
  • Resolved minor issue where the suggested filename for Job (RTx) position rule data loaders was incorrect. #admin 21.1.258 #259353
  • The data loaders exported by the configuration migration tool are now sorted by name to make it easy to navigate the individual files and compare with other loaders. #loader 21.1.257 #259967
  • Resolved issue where long-running configuration migrations could fail because the system was “helpfully” cleaning up temporary files prior to them being processed. #loader 21.1.257 #260261
  • Fixed ’null reference’ exception that could occur when re-importing projects from Val Nav. #integration #valnav 21.1.256 #248308
  • Resolved critical memory leak in Operational Scheduling module that could cause the service to eventually run out of memory and become unresponsive. #performance 21.1.256 #258407
  • Minor fixes and improvements to the recently release Peloton API-based integration. #integration #peloton 21.1.256 #259593
  • Resolved issue where ‘On Demand Well Operations Entity/Job Name Sync’ would fail to run. #integration #wellez 21.1.256 #259831
  • Resolved issue where ‘Can Product After’ flag was not being correctly read from Val Nav Template when importing projects from Val Nav. #integration #budget #valnav 21.1.256 #259883
  • Fixed an issue where the Configuration Migration tool wouldn’t correctly migrate Discipline tabs between environments. #admin 21.1.255 #251884
  • Resolved issue where updates to Custom Business Rule names (such as a custom field permission) wouldn’t immediately be visible elsewhere within Execute. #admin 21.1.255 #253436
  • Fixed up view definitions for legacy Val Nav capital database views. #integration 21.1.255 #256835
  • Fixed multiple issues dealing with inactivated fields in a Workflow Definition (such as fields showing with an empty name, and being unable to remove them from the task reset list of fields). #admin 21.1.255 #256906
  • Fixed date filtering issues (using the In Range operator) in the new-style grids throughout Execute. #ui 21.1.255 #257773
  • Resolved issue when creating helper views in Azure SQL warehouse where an existing global object could cause the creation/update of the helper view to fail. #integration 21.1.255 #258148
  • Resolved an issue that prevented creating a new SQL Server database when using SQL Server authentication. #system 21.1.255 #259011
  • If you are still waiting for your schedule to print, we have resolved an issue where the “Print” button on a Schedule would appear to be stuck and never actually print the schedule. Sorry! #opsched 21.1.255 #257366
  • Added the missing element in table_data_selection.config sample plugin file. #plugins 21.1.255 #247786
  • Resolved an issue where an administrator setting the “Fields that are cleared on task reactivation” list on a workflow’s Reactivation Rules tab, switching to a different tab, and coming back again would be greeted by an unexpected (and unintentional) error. #workflow 21.1.253 #246266
  • Resolved an issue where RTX disciplines that were migrated from the former RTD module were unable to be removed from the RTX. #well delivery 21.1.253 #246500
  • When adding a new “Additional Storage Table” we’ve added a message to let you know that it was successfully added so that you aren’t left wondering, “Wait. That happened so quickly! Did something happen?” #admin 21.1.253 #249709
  • We’ve resolved an issue where the Integration Agent was unable to replicate the results of a database calculation/function from Oracle into Execute. #integration 21.1.253 #256139
  • We’ve improved the reliability of our AzureSQL Data Warehouse functionality by increasing the timeouts to allow slow running queries time to finish. #integration 21.1.253 #256838
  • Use the default values parameter of the Document Create API now works properly with date fields #api 21.1.253 #256115
  • Fixed an issue where the new “Document Link Summary” tabs would break if a document was linked to another document of the same type. #system 21.1.251 #252853
  • Various improvements to debug logging on invalid JSON requests (only visible when debug logging is enabled). #system 21.1.251 #255396
  • Fixed an issue where the Update Multiple (triggered from the Browse) feature would fail if you had two or more columns with identical names. Note that this fix prevents the overall feature from breaking when there are duplicate columns. Update Multiple is not able to update columns where the name is not unique. #system 21.1.249 #236586
  • Resolved issues where Execute would occasionally incorrectly start up in recovery mode and require a restart. #system 21.1.249 #241065
  • Resolved an issue where a misconfigured plugin (containing a reference to the removed AgentDbAccessFactory) would prevent the service from starting correctly. #system 21.1.249 #241439
  • Prevent using the Unzoned feature on date fields in the Schedule document. All dates on a schedule must be relative to the schedule’s timezone and may not be unzoned. #system 21.1.249 #245404
  • Resolved an issue where inactivating a field could break the column configuration popup on the browse screen if that column as previously selected as a visible column. #system 21.1.249 #247707
  • Fixed an issue when creating a new custom field. Sometimes the new fields was incorrectly checked against other fields for overlapping names. #system 21.1.249 #250039
  • Fixed the issue introduced in the previous release where the AFE Print pop-up would show an DataTables Warning. #afe 21.1.249 #252024
  • Various fixes to Execute’s integration with Dataflow. #integration 21.1.249 #253328
  • Resolved an issue where “re-evaluate workflow " would incorrectly delete sub-workflows. #workflow 21.1.247 #244969
  • Document Link Summary tabs are now hidden on un-saved documents to avoid an annoying pop-up error. #system 21.1.247 #246910
  • Support packages no longer inadvertently include some security sensitive configuration files. #system #security 21.1.247 #247060
  • Resolved issue where API keys were still inadvertently taking a license in some situations. #integration 21.1.247 #247599
  • Resolved issue where slow connectivity to Azure SQL or Snowflake could block saving documents elsewhere in Execute. #integration 21.1.247 #247975
  • Fixed an issue where the background process that updated Jobs with the latest schedule information would create zillions of sessions rather than just creating one and reusing it. Fortunately, these sessions were internal (no licensing effect), but it looked messy in the logs. #opsched 21.1.246 #241305
  • Updated the “custom_table.config.sample” to include an example of the GridHeight attribute which is used to control the size of the table. #system 21.1.246 #241634
  • Fixed issue where the Data Loaders were unable to load data into a table added to an Additional Storage Table. #system 21.1.246 #242480
  • Removed the configuration lock on the WELL and SITE fields on the RTX document so that administrators are able to update configuration for these fields (such as to adjust field-level permissions, and list field filters). #well delivery 21.1.246 #243510
  • Fixed an issue where formulas with many nested if() statements were extremely slow to compile/evaluate. #system 21.1.246 #244145
  • An activity being the destination of multiple relations caused an error when adding from the job scheduler. These activities are now skipped. #opsched 21.1.246 #244317
  • Fixed an issue where a broken formula on a document would break the “Undo” button for that document. #system 21.1.246 #244529
  • Fixed an issue where a % sign included in a report title would prevent you from exporting that report to Excel. #system 21.1.246 #244942
  • Resolved issue where Account Rules could show “UNDEFINED TEMPLATE ‘contains’” when using Account Rule by Pattern. #afe #admin 21.1.246 #245202
  • Resolved an issue where the schedule view configuration tool would fail to work properly on schedules without any activities. #opsched 21.1.246 #245393
  • Resolved issue where the Review Completed Date field would only consider System Reviewers. #afe 21.1.245 #236197
  • Resolved an issue where errors returned by Document Validation Rules were formatted as unassuming “Info” messages, instead of the much more alarming “Error” styling as intended. #system 21.1.245 #241345
  • Resolved an issue showing date-type columns in the Project Reforecasting screen. #budget 21.1.245
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.