2023 releases

These release notes describe enhancements to and include resolved and known issues where applicable.

Note: Resolved issues included here are the highest priority issues reported by customers, not a complete list of bug fixes.

December 2023

Expectations and limitations

The following expectations and limitations should be considered for this release::

• If you're using the Client, a charge will be incurred and Flex Credit(s) will be deducted from your CONNECT account. For more information, see About flex credit usage in AVEVA Measurement Advisor.

• VMGThermo is not available for hydrocarbon dewpoint calculations. Only the GERG-08 calculation of the National Institute of Standards and Technology's Reference Fluid Thermodynamic and Transport Properties Database (NIST REFPROP) is supported.

• File Import is not supported.

• The on-premises AVEVA Gas Day Advisor interface is not supported within AVEVA Measurement Advisor.

• Microsoft Excel spreadsheets are no longer supported for reporting, as they can no longer directly access the SQL database.

• Administrative screens are not supported, except for the following:

  • All Queues

  • Max Retries

  • Task List

  • Time Calculator

  • Find and Delete Objects

  • Audit Data

New features and enhancements

• AVEVA Measurement Advisor Help is now available on the AVEVA Documentation portal at docs.aveva.com. It can be accessed directly from within AVEVA Measurement Advisor by selecting the help icon .

Resolved issues

The following is a list of fixed issues included in this release.

(Defect–2965039) Launch Endpoint not working in production: This defect fix addresses an issue where the AVEVA Measurement Advisor Client file could not be downloaded from the Cloud, because the download process referenced an incorrect file location.

Known issues

The following is a list of known issues as of this release:

• Description: Host-calculated meters and GQs do not support the REFPROP calculation in AVEVA Pipeline Operations for Gas. If you are using REFPROP for the hydrocarbon dewpoint calculation in AVEVA Measurement Advisor, then the host calculations in AVEVA Pipeline Operations for Gas will use Peng-Robinson using VMGThermo. Workaround: Not applicable.

November 2023

Expectations and limitations

The following expectations and limitations should be considered for this release::

• For this release of AVEVA Measurement Advisor, the following functionality is not supported:

  • VMGThermo is not available for hydrocarbon dewpoint calculations. Only the GERG-08 calculation of the National Institute of Standards and Technology's Reference Fluid Thermodynamic and Transport Properties Database (NIST REFPROP) is supported.

  • File Import is not supported.

  • The on-premises AVEVA Gas Day Advisor interface is not supported within AVEVA Measurement Advisor.

  • Microsoft Excel spreadsheets are no longer supported for reporting, because they can no longer directly access the SQL database.

  • Administrative screens are not supported except for the following: All Queues, Max Retries, Task List, Time Calculator, Find and Delete Objects, and Audit Data.

New features and enhancements

• The AVEVA Measurement Advisor online documentation now includes a guide to help you get started quickly using AVEVA Measurement Advisor. For more information, see Get started with AVEVA Measurement Advisor.

• Using MeasConfig, you can now import and export configuration override files.

• AVEVA Measurement Advisor is now available on the AVEVA Documentation portal at docs.aveva.com. It can be accessed directly from within AVEVA Measurement Advisor by selecting the help icon .

Resolved issues

• Case - 960294489 (Defect - 2531891) - doGroupClose has performance problems: This defect fix addresses an issue where the doGroupClose stored procedure was too slow when the close group had several thousand objects attached, resulting in a timeout error. The timeout error prevented the close procedure from completing.

• Case - 960308658 (Defect - 2541930) - Excessive calibrationReading dpKey creation in the production datapump queue: This defect fix addresses an issue where the calib_checkForCalibPoints task in the taskList was unnecessarily adding rows for datapump to replicate every time it ran when there were no calibration samples.

• Case - 960299745 (Defect - 2575876) - Accounting close complains about an "open" station that is not connected to a meter: This defect fix addresses an issue where the AccountingClose stored procedure was unable to close physical stations that did not have any meters connected or had only meters not actively connected.

• Case - 960277205 (Defect - 2561187) - Approved Daily PPAs screen timing out:

This defect fix addresses an issue where the retrieval of Approved Daily Prior Period Adjustments (PPAs) sometimes would time out.

Known issues

The following is a list of known issues as of this release:

Description: Host-calculated meters and GQs do not support the REFPROP calculation in AVEVA Pipeline Operations for Gas. If you are using REFPROP for the hydrocarbon dewpoint calculation in Measurement Advisor, then the host calculations in AVEVA Pipeline Operations for Gas will use Peng-Robinson using VMGThermo. Workaround: Not applicable.

July 2023

Expectations and limitations

The following expectations and limitations should be considered for this release:

If you're using the Client and you connect as a user, a charge will be incurred and Flex Credit(s) will be deducted from your CONNECT account. For more information, refer to Understanding Flex Credit Usage for AVEVA Measurement Advisor.

• For this release of AVEVA Measurement Advisor, the following functionality is not supported:

  • VMGThermo is not available for hydrocarbon dewpoint calculations. Only the GERG-08 calculation of the National Institute of Standards and Technology's Reference Fluid Thermodynamic and Transport Properties Database (NIST REFPROP) is supported.

  • File Import is not supported.

  • The on-premises AVEVA Gas Day Advisor interface is not supported within AVEVA Measurement Advisor.

  • Microsoft Excel spreadsheets are no longer supported for reporting as they can no longer directly access the SQL database.

  • Administrative screens are not supported except for the following: All Queues, Max Retries, Task List, Time Calculator, Find and Delete Objects, and Audit Data.

New features and enhancements

• Previously, user-defined Microsoft SQL error messages (defined in errorMessageDesc) that had an error code greater than, or equal to, 50,000 were raised by calling raiserror. An example of the error is as follows:

  Msg 51002, Level 16, State 1, Procedure <procName>, Line 8 PQL File: {fileName} Line: {fileLineNumber}:: Cannot create temp table

  Now, all user-defined messages will be raised as an error 50,000. The user-defined messages will have the code from errorMessageDesc embedded in the string. The following is the new format for the same error:

  Msg: 50000, Level: 16 State: 1, Procedure: <procName>, SQL Line: 8, PQL File: '{fileName}' Line {fileLineNum}:: MeasError: 510002 Cannot create temp table

  If there are applications or screens that parse the error message for the code, they will require a change in their routines.

  Important: This is used only if you have created custom screens. If the screen makes use of the Sightline.Utilities.ContainsError routine, no change is required. To facilitate the change, measObjectRegLoader -u languageLoad copies the error messages from errorMessageDesc to errorMessageCultureDesc; all error messages are selected from this table. During the copy, the format for the arguments of the message are changed from C printf style such as the %d, %s style format to a positional-independent style such as %1!, %2! used by internationalization.

• Now, you can quickly set the year in the following date/time selection dialog boxes:

  • Balance Connectivity window

  • GQ/GQ Connection window

  • Point/Object Connection Information window

  • Station Point Connection Information window

  • Connection Information window

  • Close Group Information window

  • Manual Aggregation window

  • Recalculation window

  • Select Date Range window

  • Refresh on the Properties windows

    For more information, refer to the Refresh data dialogs in the AVEVA Measurement Advisor User documentation.

• We have made changes to the primary factor calculations for pulse and corrector meters. Now, the primary factor is converted when displaying or saving in different base conditions than the standard base conditions (14.73 PSI/60ºF). For more information, refer to Additional primary factor information in the AVEVA Measurement Advisor User documentation.

• We have introduced a new application called the MeasConfig tool. It is provided to allow the Administrator to configure the Object Registry of AVEVA Measurement Advisor without the need to edit and create ObjectRegFiles using a text editor. For more information, refer to Use the MeasConfig tool to make updates to the object registry in the AVEVA Measurement Advisor Installer documentation.

• We have introduced an option (CD_CALC_WOBBE_INDEX) to turn off the default Wobbe Index calculations when a gas quality (GQ) row is entered into AVEVA Measurement Advisor. This is useful when you do not want modifications to the data as it is collected. This option is enabled by default.

• The following configDesc properties are now passed to the measurement calculation library which no longer needs to be recompiled to change these settings. However, we do not recommend that any of them be changed.

  • CD_CALCLIB_USE_CONSTANT_ZAIR — Y

  • CD_INCLUDE_H2O_HEATING_VALUE — N

  • CD_EXCLUDE_O2_FROM_HV — N

    This allows customizations of the calculations by changing the value of the variable.

    Important: The default value of CD_EXCLUDE_O2_FROM_HV has been changed from Y to N to better reflect the usage of the majority of our customers. This only affects the AGA-5 thermal calculation. For more information, refer to Update the backwards compatibility overrides in the AVEVA Measurement Advisor Installer documentation

• A new configuration item, CD_MINIMUM_CLIENT_VERSION, has been added. It is used to ensure you are using the minimum supported version of the client. It should never be edited.

• As a result of some changes to the internationalization process, we have introduced the following configuration overrides in the configDesc. Enabling these language items will load example translations into the database and make them available in the client application.

  They are as follows:

  • CD_CHINESE

  • CD_FRENCH

  • CD_GERMAN

  • CD_ROMANIAN

  • CD_RUSSIAN

  • CD_SPANISH

    Additionally, we have formally removed the following configDesc settings:

  • CD_OASYS_VERSION

  • CD_RDBMS

  • CD_REALTIME_IS_OLD_VERSION

• Any changes to the Internal Storage profile needed by Cloud administrators can be updated through the Unit Summary window in the Client. An administrator is now allowed to edit the Internal Storage profile, though it is a reserved profile. Other reserved profiles are not available for edit.

• The QWhale component used by the Bulk Validation code editing window is no longer supported and has been removed. It has been replaced by a text box.

• The Configure the object registry section in the AVEVA Measurement Advisor Installer documentation has been updated to make it applicable to a cloud environment.

• Now, AVEVA Measurement Advisor gives the option to calculate Z ratio when the Internal Storage unit profile is configured with an alternate set of base conditions other than the standard base conditions (14.73 PSI/60ºF). Previously, only the standard base conditions in the Internal Storage unit profile were supported for Z ratio calculation.

• We have documented how to configure the Cascading Properties, making it applicable to a cloud environment. For more information, refer to Configure cascading properties in the AVEVA Measurement Advisor documentation.

• We have documented how to configure the timezones using the MeasConfig tool. For more information, refer to Define a new timezone in the AVEVA Measurement Advisor Installer documentation.

• We have worked to improve the documentation associated with Accounting Close. For more information, refer to Accounting close in the AVEVA Measurement Advisor User documentation.

• We have enhanced the Close Group and Connect History user documentation to provide more detail. For more information, refer to Close group summary and Connect history in the AVEVA Measurement Advisor User documentation.

• We have enhanced Maintaining Identity Columns to automate the process and the building of object lists. Therefore, it is no longer necessary for users to manually configure the building of the object lists or to periodically check the tables with Identity Columns to see if they need to be reset as they approach the maximum number.

• We have introduced background information, planning information, and procedures for accomplishing a data migration from your on-premises system to the Cloud. For more information, refer to the Data Migration chapter in the AVEVA Measurement Advisor Installer Guide.

• AVEVA Measurement Advisor Help is now available on the AVEVA Documentation portal at docs.aveva.com. It can be accessed directly from within AVEVA Measurement Advisor by selecting the help icon . Now, a reference to the help pages is stored in the new sightlineHelpDesc table, which is is populated in the objectRegFiles. If an entry is not found, it will display a default page. The help pages for each screen can be accessed by clicking Help or F1 in the client. You will be directed to the appropriate page of the documentation hosted on the AVEVA Doc Portal. (https://docs.aveva.com/bundle/measurement-advisor-cloud/page/703822.html).

Resolved issues

• Case - 960120166 (Defect - 1607392) - measobjectregloader is not processing the -P option properly: This defect fix addresses an issue where the optional Project Override dropdown on the Save and Load tab in MeasConfig was not populating the configDesc table properly.

  Important: The objItemDomainCodes used for CD_CHINA have been changed to avoid a conflict with CD_BALANCING. An update script, R2021SP1toR2023.sql, is provided to renumber some of the conflicting objItemDomainCodes for the following:
  –objItemDomainDesc
  –objItemDomainCultureDesc
  –numericSetAlterConditionDesc
  This can be run on the on-premises database as part of the data migration plan.

• Case - N/A (Defect - 1655390) - HostCalc Gasmeter and GQ names that were truncated to 31 characters no longer sync results to EFM: This defect fix addresses an issue where, to accommodate AVEVA Enterprise SCADA requirements, the names of Meter and Gas Quality records must be a maximum of 31 characters.

  Important: To adjust this back to 32 characters if you do not have an AVEVA Enterprise SCADA system, set the value with a custom override of objItemDesc.sysdefNumericValue.

• Case - 960133339 (Defect - 1657316) - Meter data editor does not calculate the energy on the last row when displaying in EOP: This defect fix addresses an issue where the end-of-period to top-of-period conversion was being performed twice within the Meter Data Editor.

• Case - 960132975 (Defect - 1664313) - tasklist.sql file not loading and running correctly when adding arguments: This defect fix addresses an issue where, when providing a string argument to a taskList override, a stored procedure with a syntax error would be generated when the user updated the Object Registry.

  Important: Updating the Object Registry is now performed by the MeasConfig Tool.

• Case - N/A (Defect - 1667630) - Meas 2023 - WithFileImportDataExchangeGQData test fail and incorrect calculation error handling: This defect fix addresses an issue with a Gas Calculation error that occurred when the data was initially processed.

  Important: A problemMessage column has been added to the gas quality (GQ) adjustment manager tables. This allows creation of a problematicContext record when errors occur.

• Case - N/A (Defect - 1667651) - writeRemoteOHC doesn't use the Daily Time Preference from the unit profile: This defect fix addresses a conversion issue where last/missing timestamp values were not converted properly based on the Unit Profile timestamp preference.

• Case - 960139102 (Defect - 1682354) - Meter Data editor Keyboard shortcuts not working: This defect fix addresses an issue where some keyboard shortcuts were not functioning as expected, including CTRL + S to save and shortcuts for changing granularities.

  Refer to Keyboard Shortcuts in the AVEVA Measurement Advisor User documentation.

• Case - 960138661 (Defect - 1680367) - Error when opening Organization Connectivity from Contact Summary: This defect fix addresses an issue where an error would occur when the Organization Connectivity was opened from the Contact Summary.

• Case - N/A (Defect - 1691187) - Meter Data Editor "save" fails without notification when editing only rows that have VR check: This defect fix addresses an issue where users were incorrectly informed they could not edit a row with a Volume Ratio problem. Now, users are prompted to accept, reject, or cancel the edit.

• Case - N/A (Defect - 1699837) - objItemDesc.sysdefNumericValues.CD_API14_4_EXTRA_GQ_COLUMNS.xml does not have all the values set: This defect fix addresses missing allowable ranges for validation objects.

  Thresholds (mol frac):

  • Min = 0 mol frac

  • Max = 1 mol frac

  • Tolerances (%):

  • Min = 0%

  • Max = 100%

    Updated defaults:

  • GQ Ethylene reas chk — High threshold = 1 mol frac (was 0.008)

  • GQ Ethylene oper chk — High threshold = 1 mol frac (was 0.008)

  • GQ Ethylene hist avg chk — Threshold = 0.05 mol frac (was 5)

• Case - 960144780 (Defect - 1704915) - Time format not respecting AM/PM setting in Date Range Selection dialog: This defect fix addresses an issue where the time in the Date Range Selection dialog box was always displayed in a 24-hour format, regardless of the time format being used. In cases where English was in use, if the AM/PM time format is selected in the User Options, the time should have been displayed in hh:mm:ss tt format.

• Case - 960145929 (Defect - 1710530) - Issue with energy calculation on first row when inserting data into Client: This defect fix addresses an issue where calculating the energy for the first row in the Meter Data Editor when viewing the data with an end-of-period (EOP) unit profile would give an error saying the gas composition didn't exist even though it did.

• Case - 960139233 (Defect - 1717500) - Duplicate rows in mtrGPSPostProcessingQueue fails the post validation process: This defect fix addresses an issue where the meter Post Validation fails with an error when there is a duplicate in the post-processing.

• Case - 960147620 (Defect - 1747041) - Late data estimation inserts several requests to ORQ: This defect fix addresses an issue where late data estimation would generate estimated keys for data that had already been estimated. This would occur only when the estimation granularity was set to Default and meter or gas quality was receiving data in more than one granularity (e.g., both daily and hourly).

• Case - 960153420 (Defect - 1778756) - FK_OIDD_REF_GCDD constraint integrity: This defect fix allows referential integrity between the object properties table and the calculation table, which was previously disabled.

• Case - 960159838 (Defect - 1786849) - Group close date is not aligning correctly with the end of the gas day:

  This defect fix addresses several issues:

  • The close group close date was not being saved correctly to align with the end of the gas day.

  • When more than one close group was selected, only one was closed. Now, all selected groups are closed.

  • Undo Close can be performed on multiple close groups.

  • The Close Group Summary now updates automatically when a group is closed or unclosed.

  • The default close date is now the beginning of the current month unless a later date has already been closed.

  • When choosing the close date, the minimum is the most recent close date of the selected groups.

• Case - 960157899 (Defect - 1791052) - Use energy adjustment message when recalculating meter data with GQ edit state in manual override: This defect fix addresses an issue where the mass would be set to NULL when the meter Recalculation Policy was set to Recalculate Energy and Dewpoint. The Adjustment Reason was incorrect and now properly indicates that an energy recalculation occurred.

• Case - N/A (Defect - 1837684) - Error when closing a group not closed for over six months: This defect fix addresses an issue where the user would get an error when closing a close group that had not been closed for more than six months.

• Case - N/A (Defect - 1834467) - Incorrect Z ratio description in documentation: This defect fix addresses an issue where the Z ratio was incorrectly described in the user documentation.

• Case - N/A (Defect - 1857882) - MeasObjectRegLoader does not handle overrides where the keys are multiple columns: This defect fix addresses an issue where Object Registry Custom overrides were not working for tables that do not have a code column. This includes issues with deleteList, postProcessingList, and objItemPostProcessingList.

• Case - 960132595 (Defect - 1883305) - DST not accounted for in Daily vs Hourly Aggregation check: This defect fix addresses an issue where the Daily Meter versus Hourly Aggregation check was not taking into account DST changes, causing the check to pass or fail incorrectly. The Daily Gas Quality (GQ) versus Hourly Averages was also corrected.

• Case - 960181260 (Defect - 1909751) - Precision issue when converting temperatures: This defect fix addresses an issue where converting temperatures between units resulted in a precision error, causing the stored value to differ slightly from the field value (up to the 12th decimal place). This floating point discrepancy has been corrected.

• Case - 960120166 (Defect - 1954396) - MeasObjectRegLoader/Measloader issues when customizing a system - (2 of 3): This defect fix addresses issues loading the Object Registry files when using both project overrides and server-specific overrides. This prevented successful system customization. Now, files are loaded in the following order: baseline files, project overrides, and then server overrides.

• Case - N/A (Defect - 1973858) - Inverted Zratio changes broke calibration: This defect fix addresses an issue where the calibration was not retrieving all the configuration required for the calculation.

• Case - 960205402 (Defect - 2021401) - GQ Ripple from backup GQ results in ORQ with retries=10 when config to use MQ: This defect fix addresses an issue where a meter configured with a Host GQ calculation policy of Default Effective GQ and a zone gas quality (ZQ) with a backup was incorrectly using the backup ZQ instead of the measured gas quality (MQ).

  Important: The ripple should use the MQ value, not the backup ZQ.

• Case - 960205868 (Defect - 2030405) - Manual meter recalculation stuck in queue: This defect fix addresses an issue where manual meters configured to recalculate volume and energy would get stuck in a queue when there was a change to a backup gas quality. The system now recalculates energy correctly when the backup GQ changes.

• Case - N/A (Defect - 2049928) - Liquid meter backup GQ ripple not recalculating dewpoint: This defect fix addresses an issue where configuration ripples caused by backup GQ changes for liquid meters were not recalculating correctly if the Backup GQ Recalc Policy included hydrocarbon dewpoint calculation. Dewpoint calculation is not performed for liquid meters.

• Case - N/A (Defect - 2086723) - BSW value misinterpreted in liquid calculations: This defect fix addresses an issue where the base sediment and water (BSW) value was used as a fraction instead of a percentage, resulting in incorrect calculations.

  Important: BSW is now converted to a fraction when used in net standard volume (NSV) calculations. Historical records should multiply BSW by 100 for consistency. (BSW is now commonly referred to as S&W%.)

• Case - 960193362 (Defect - 2110999) - Incorrect timezone installation instructions: This defect fix updates the installation instructions for configuring timezones to use the MeasConfig tool.

• Case - N/A (Defect - 2139073) - Coriolis meters are calculating an incorrect flow pressure effect: This defect fix addresses an issue where volume calculations for Coriolis meters used absolute pressure without converting to gauge pressure.

  Important: The AGA-11 2013 Calculation configuration now includes Atmospheric Pressure to support this conversion.

• Case - N/A (Defect - 2148022) - Incorrect meter configuration loaded in Gas Calculator: This defect fix addresses an issue where navigating to the Gas Calculator from the Meter Data Editor for a Coriolis meter would incorrectly load the configuration for an Orifice meter.

• Case - N/A (Defect - 2149306) - Linepack meters not calculating average temperature or pressure: This defect fix addresses an issue where Linepack meters failed to calculate average temperature or pressure when those values were not provided.

• Case - N/A (Defect - 2149308) - AOR filtering isn't working on the Rejected Readings Summary: This defect fix addresses an issue where rejected meter reading data was not displayed when the Area of Responsibility (AOR) filter was applied.

• Case - N/A (Defect - 2157634) - Use In/Out Values summing rule double-counts input values: This defect fix addresses an issue where the Use In/Out Values summing rule would double-count values when a child object was input to more than one parent object in the balance hierarchy.

• Case - N/A (Defect - 2158889) - Bulk revert performance issue with large datasets: This defect fix addresses a performance issue with the bulk revert operation when run against large datasets (e.g., more than 50,000 rows).

• Case - 960281055 (Defect - 2453841) - Duplicate row in queue prevents data processing: This defect fix addresses an issue where meter data sent to Measurement Advisor was followed by an update to GQ and meter data before processing, resulting in a duplicate row in the queue and failure to process.

• Case - 2472960 (Defect - 2476198) - MeasRecalc fails the calculation for manual meter requests: This defect fix addresses an issue where changing a meter to manual calculation mid-gas day caused the batch calculation to fail if other meters remained on automatic.

• Case - N/A (Defect - 2493282) - ExcelMediator form uses unsupported Excel spreadsheet: This defect fix addresses an issue with the ExcelMediator form, which uses a Microsoft-owned DLL and Excel spreadsheet. Excel spreadsheet use is not supported in the current release.

• Case - N/A (Defect - 2493116) - Administrative screens cannot access Cloud database: This defect fix addresses an issue where Administrative screens could not access the Cloud database.

  Note: These screens are available only to System Administrators and include All Queues, Max Retries, Task List, Time Calculator, Find and Delete Objects, and Audit Data.

• Case - N/A (Defect - 2495690) - CD_DISPLAY_MEASUREMENT_POINT override removed for Cloud: This defect fix addresses an issue with the configuration override for CD_DISPLAY_MEASUREMENT_POINT, which required stored procedures unavailable in the Cloud.

  Note: This override has been moved to the Legacy On-Premises Configuration Overrides list.

Known issues

The following is a list of known issues as of this release:

• Description: Host-calculated meters and GQs do not support the REFPROP calculation in AVEVA Pipeline Operations for Gas. If you are using REFPROP for the hydrocarbon dewpoint calculation in Measurement Advisor, then the host calculations in AVEVA Pipeline Operations for Gas will use Peng-Robinson using VMGThermo. Workaround: Not applicable.