Configure raw data transfer to on-premises

If you have existing installations that already contain an on-premises AVEVA Measurement Advisor installation, and you want to continue sending raw data to the on-premises Electronic Flow Measurement (EFM) database, proceed as follows.

Note: AVEVA Measurement Advisor Cloud Data Connector for AVEVA Enterprise SCADA does not support the sending of gas meter and Gas Quality (GQ) event data in multi-SCADA environments that have single Cloud Measurement and on-premises validation enabled. AVEVA Measurement Advisor Cloud Data Connector for AVEVA Enterprise SCADA will not write event data to the on-premises AVEVA Measurement Advisor.

Important: The system does not synchronize configuration changes (for example, Meter or GQ configuration, or Areas of Responsibility [AOR]) between the on-premises and cloud versions of AVEVA Measurement Advisor. This OnPremMeasurementTransferEnabled key is only used for sending the raw data. You will need to manually perform any desired configuration changes to the on-premises AVEVA Measurement Advisor and migrate the configuration data to the cloud version. For further information, see "Import the Data Using measDataLoader" in the AVEVA Measurement Advisor Cloud Installer documentation.

To process data in both the primary on-premises and the secondary on-premises Measurement Advisor

When the OnPremMeasurementTransferEnabled key is set to true, perform the following steps to ensure data is successfully sent and processed in both the primary on-premises Measurement Advisor and the secondary on-premises Measurement Advisor:

1. Sign on to the primary on-premises Measurement Advisor system.

2. Either create or open the %DNADataRoot%\MeasurementAdvisor\config\setup\objectRegFiles\custom\configDesc.<systemName>.CD_UTIL.xml file.

3. Add the following parameter and set the booleanValue to Y:

   CD_DIST_OWNS_ALL_DATASETS

   The following is an example of a configDesc.<systemName>.CD_UTIL.xml file:

   <configDesc>

   <configCode>192</configCode>

   <configName>Dist Owns All Datasets</configName>

   <configDefine>CD_DIST_OWNS_ALL_DATASETS</configDefine>

   <description>The measurement system should act as though it owns all datasets.</description>

   <configTypeDesc:configTypeName>Boolean</configTypeDesc:configTypeName>

   <configSettingDesc:configSettingName>Behavior</configSettingDesc:configSettingName>

   <intValue></intValue>

   <numericValue></numericValue>

   <booleanValue>N</booleanValue>

   <nameValue></nameValue>

   <global>N</global>

   </configDesc>

4. Delete all entries from the following tables:

   • DatasetDefine

   • DatasetModeDefine

   • DatasetPrivilegeDefine

5. Execute the following commands:

   measObjectRegLoader -u cleanLoad -S <sql server>

   measLoader -u execAfterInstall -S <sql server>

6. Repeat the above steps on every on-premises Measurement Advisor system.

To configure the required settings for the raw data transfer to on-premises

7. In the %DNADataRoot%\CloudData\config\Settings directory, either create or open the MonitorMeasBufferDB.json file.

8. In the file, add the following configuration:

   {

   "MonitorMeasBufferDB": {

   "OnPremMeasurementTransferEnabled": true

   }

   }

9. Save the file.

10. If you have a dual-hosted AVEVA Enterprise SCADA CloudData service, make the same changes in the override file on both servers.

11. If the AVEVA Enterprise SCADA CloudData service is running, restart the service for the changes to take effect.