Update DBProcessConfig.json
- Last UpdatedAug 27, 2024
- 3 minute read
The file DBProcessConfig.json holds the settings used for sending data from Autosol Communications Manager to AVEVA Measurement Advisor (via the Data Connector component). The table below lists the keys included in DBProcessConfig.json and their descriptions. A sample DBProcessConfig.json follows.
Included in the description of the current file is what kind of data is being transferred, and the order of stored procedures used to transfer it.
You should not have to edit this file, unless you want a new kind of data to be transferred, or to remove an existing data transfer if it is not required (for example, if you were not recording any daily history data, you might elect to remove that section.)
|
DBProcessConfig.json |
Description |
|---|---|
|
HistoryHourly Section |
|
|
STEP1 |
Name of the stored procedure used to copy imported Autosol Communications Manager hourly meter and gas quality (GQ) history data to the electronic flow measurement (EFM) buffer database. |
|
STEP2 |
Name of the stored procedure used to match up imported Autosol Communications Manager hourly meter and GQ history data to the format used by the EFM buffer database. |
|
STEP3 |
Name of the stored procedure used to clean up and delete imported Autosol Communications Manager hourly meter and GQ history data after it has been processed into the EFM buffer database. |
|
BatchSize |
The number of records to be processed in each batch for the stored procedures in this group. |
|
HistoryDaily Section |
|
|
STEP1 |
Name of the stored procedure used to copy imported Autosol Communications Manager daily meter and gas quality (GQ) history data to the electronic flow measurement (EFM) buffer database. |
|
STEP2 |
Name of the stored procedure used to match up imported Autosol Communications Manager daily meter and GQ history data to the format used by the EFM buffer database. |
|
STEP3 |
Name of the stored procedure used to clean up and delete imported Autosol Communications Manager daily meter and GQ history data after it has been processed into the EFM buffer database. |
|
BatchSize |
The number of records to be processed in each batch for the stored procedures in this group. |
|
EventObject Section |
|
|
STEP1 |
Name of the stored procedure used to copy logged alarm records from imported Autosol Communications Manager data to the EFM buffer database. |
|
STEP2 |
Name of the stored procedure used to copy logged event records from imported Autosol Communications Manager data to the EFM buffer database. |
|
STEP3 |
Name of the stored procedure used to match up logged imported Autosol Communications Manager event and alarm data to the format used by the EFM buffer database. |
|
STEP4 |
Name of the stored procedure used to clean up and delete imported Autosol Communications Manager event and alarm data after it has been processed into the EFM buffer database. |
|
BatchSize |
The number of records to be processed in each batch for the stored procedures in this group. The default is 500 records. |
|
ConfigObject Section |
|
|
STEP1 |
Name of the stored procedure used to copy imported Autosol Communications Manager configuration data to the EFM buffer database. |
|
STEP2 |
Name of the stored procedure used to match up imported Autosol Communications Manager configuration data to the format used by the EFM buffer database. |
|
STEP3 |
Name of the stored procedure used to clean up and delete imported Autosol Communications Manager configuration data after it has been processed into the EFM buffer database. |
|
BatchSize |
The number of records to be processed in each batch for the stored procedures in this group. The default is 500 records. |
|
Settings Section |
|
|
MaxRetryCount |
The number of times a database process will be tried before it is marked as failed. The default is 2. |
|
FailedRowCleanupThreshold |
The maximum number of records in a batch that can fail before the entire batch is marked as failed. The default is 20. |
|
AuditRowCleanupThreshold |
The maximum number of records in a batch that can be cleaned up before the entire batch is marked as failed. The default is 60. |
|
CheckinIntervalInSeconds |
Defines how often the database process agent must check in with AVEVA Measurement Advisor after which they are marked as failed. The default is 20. |
Sample DBProcessConfig.json File
{
"TaskSchedule": {
"HistoryHourly": {
"STEP1": {
"ProcName": "ACMsplit_historyRecordsHy"
},
"STEP2": {
"ProcName": "ACMtransform_combinedHistHy"
},
"STEP3": {
"ProcName": "ACMcleanup_historyRecordsHy"
},
"BatchSize": "500"
},
"HistoryDaily": {
"STEP1": {
"ProcName": "ACMsplit_historyRecordsDy"
},
"STEP2": {
"ProcName": "ACMtransform_combinedHistDy"
},
"STEP3": {
"ProcName": "ACMcleanup_historyRecordsDy"
},
"BatchSize": "500"
},
"EventObject": {
"STEP1": {
"ProcName": "ACMcopy_alarmRecords"
},
"STEP2": {
"ProcName": "ACMcopy_eventRecords"
},
"STEP3": {
"ProcName": "ACMtransform_eventRaw"
},
"STEP4": {
"ProcName": "ACMcleanup_eventRecords"
},
"BatchSize": "500"
},
"ConfigObject": {
"STEP1": {
"ProcName": "ACMcopy_configRaw"
},
"STEP2": {
"ProcName": "ACMtransform_configRaw"
},
"STEP3": {
"ProcName": "ACMcleanup_configRecords"
},
"BatchSize": "500"
}
},
"Settings": {
"MaxRetryCount": "2",
"FailedRowCleanupThreshold": "20",
"AuditRowCleanupThreshold ": "60",
"CheckinIntervalInSeconds": "20"
}
}