Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Measurement Advisor Cloud Data Connector for AVEVA™ Enterprise SCADA

Understand the Raw Data Monitor application

  • Last UpdatedAug 07, 2024
  • 2 minute read

The Raw Data Monitor application is responsible for transferring AVEVA Pipeline Operations for Gas telemetry data to the cloud. When data arrives in the raw tables on the local Electronic Flow Measurement (EFM) buffer database, the Raw Data Monitor application in the on-premises environment iterates through all the raw tables and transfers the data to the Measurement Advisor endpoint.

The table below describes the contents of the MonitorMeasBufferDB.json file.

{

"MonitorMeasBufferDB": {

"BatchLimit": 100,

"MaxNumberOfRetriesPerBatch": 5,

"MaxNumberOfRetriesPerRow": 1,

"DatabaseCheckInterval": "00:01:00",

"ProcessCheckInInterval": "00:06:00",

"OnPremMeasurementTransferEnabled": false,

"MonitoredStoredProcedures": {

"writeCommItem": true,

"writeCurrentData": true,

"writeGasAnalysisRawDy": true,

"writeGasAnalysisRawHy": true,

"writeGasAnalysisRawSa": true,

"writeObjectEvent": true,

"writeReadingRawDy": true,

"writeReadingRawHy": true,

"writeReadingRawHyByBSAPList": true,

"writeReadingRawIrr": true,

"writeReadingRawMi": true,

"writeReadingRawMy": true,

"writeSimpleObjectEvent": true

}

}

}

Setting

Default

Description

BatchLimit

100

Maximum number of rows that will be queried from the EFM buffer database for each table and transferred to the cloud endpoint as a single batch.

MaxNumberOfRetriesPerBatch

5

Maximum number of retries that will be performed when executing each batch of rows.

MaxNumberOfRetriesPerRow  

1

Maximum number of retries that will be performed when executing the fall-back method of row-by-row transfer, after the single batch method has failed all its retries.

DatabaseCheckInterval

00:01:00

Interval at which the application checks the database for new rows to process.

The format of the interval is as follows:

HH:MM:SS

Where:

  • HH = the hour(s)

  • MM = the minute(s)

  • SS = the seconds

ProcessCheckInInterval

00:06:00

Interval at which the process checks in to the Gas Measurement service’s process monitor.

The format of the interval is as follows:

HH:MM:SS

Where:

  • HH = the hour(s)

  • MM = the minute(s)

  • SS = the seconds

    Note: This should be larger than the DatabaseCheckInterval setting.

OnPremMeasurementTransferEnabled

false

Set to true to enable the Raw Data Monitor application to transfer data to the OnPrem Measurement database.

For further information, refer to Configure raw data transfer to on-premises.

MonitoredStoredProcedures

"writeCommItem": true,

"writeCurrentData": true,

"writeGasAnalysisRawDy": true,

"writeGasAnalysisRawHy": true,

"writeGasAnalysisRawSa": true,

"writeObjectEvent": true,

"writeReadingRawDy": true,

"writeReadingRawHy": true,

"writeReadingRawHyByBSAPList": true,

"writeReadingRawIrr": true,

"writeReadingRawMi": true,

"writeReadingRawMy": true,

"writeSimpleObjectEvent": true

Collection of EFM stored procedure names used to infer the list of buffer tables to monitor for new data.

Defining these values as true or false will indicate whether or not the stored procedure's data will be transferred.

TitleResults for “How to create a CRG?”Also Available in