Initial Measurements
The usage data received from the AMI head-end system as a file in Itron OpenWay XML format is loaded into Oracle Utilities as initial measurement data. The following OSB projects, delivered in the base product, help manage the usage processing:
1. SGG-D8-ITRONXML-BASE contains components responsible for “actual” processing of incoming data. It should not be modified during configuration. This project can be upgraded without affecting the customization and environment settings added to SGG-D8-ITRONXML-CM.
2. SGG-D8-ITRONXML-CM allows for customization and simplifies future upgrades.
The runtime configuration settings for the SGG-D8-ITRONXML-CM project are stored in the xquery file EnvironmentSettings.xq. You can use this file to adjust initial measurement data processing. For example, if you want to load raw data you would specify “true” for the content of the populateRawIMD element.
The following table describes the elements included in the EnvironmentSettings.xq file:
Element | Description | Valid Values |
|---|
populateRaw | Determines if the initial measurement data is populated as raw data. | true false |
callPreProcessing | Determines if the preprocessing proxy service is called. | true false |
callPostProcessing | Determines if the postprocessing proxy service is called. | true false |
destinationRootElementInterval | Holds the name of inbound web service for the interval IMD seeder. | |
destinationRootElementScalar | Holds the name of inbound web service for the scalar IMD seeder. In most cases it is the same as destinationRootElementInterval. | |
destinationRootElementEvent | Holds the name of inbound web service for the device event seeder. | |
publishServices/service | Specifies the name of the business service within the OSB project used to publish data for external systems (such as Oracle DataRaker). | |
filterEvents | Determines if events should be filtered. | true false |
filterUsage | Determines if usage should be filtered. | true false |
filterRegisterSource | Determines if source register data should be filtered. | true false |
Publishing Initial Measurement Data
The SGG adapter can be configured to publish initial measurement data for use in Oracle DataRaker or other external systems. This functionality is supported through a combination of OSB components and BPEL composites.
Enabling Initial Measurement Data Publishing
Publishing data is enabled by referencing a publisher business service in the publishServices/service element in the EnvironmentSettings.xq file as follows:
<publishServices>
<service>[publisherBusinessService]</service>
</publishServices>
The following components provided with the SGG-D8-ITRONXML-CM OSB project are used in publishing measurement data to Oracle DataRaker:
• The DataRakerBusinessService business service is used to send data to a pre-configured JMS queue (defined as an Endpoint URI), from which the data will be published. This is the business service that should be specified in the EnvironmentSettings.xq file.
• The DataRakerServiceAccount service account is used to define and maintain the user name and password needed to access the JMS queue defined in the DataRakerBusinessService business service.
Configuring Initial Measurement Publishing Output
The SGGDRIntegration BPEL composite handles publishing the data to Oracle DataRaker or other systems. Initial measurement data is published in the “native” initial measurement data format (the format of the initial measurement seeder business object). This format includes normalized unit of measure and condition codes. See the Oracle Utilities Smart Grid Gateway Adapter Development Kit Administrative User Guide for more details about this format.
Note:
Initial measurement data published through this feature is published prior to validation, estimation, and editing (VEE) processing. In addition, filtering cannot be applied to data published through this feature.
The following parameters can be used to configure details of how the data is provided to Oracle DataRaker, including the directory where files are posted for Oracle DataRaker to consume, number of records per file, polling frequency, etc. These parameters are defined during installation. See the Oracle Utilities Smart Grid Gateway Installation Guide for more details about defining values for these parameters.
Parameter | Description | Default Value |
|---|
SGG_DR_INT_QUEUE | JNDI name of queue to publish SGG payloads. This is the JMS queue defined in the DataRakerBusinessService business service. This should NOT be changed. | DataRakerQueue |
SOA_DR_PUBLISH_SIZE | The number of records (SGG payloads) to accumulate in a published file. | 100 |
SOA_DR_FILE_SIZE | The maximum file size for the accumulated (SGG payloads) file in kilobytes. | 524288 |
SOA_DR_ELAPSED_TIME | The period of time in second which, when exceeded, causes a new outgoing file to be created. | 600 |
SOA_DR_POLLING_FREQ | The polling frequency in seconds of the staging directory for new files. | 60 |
SOA_DR_STAGING_DIR | Mount point/directory for the staging directory for accumulated SGG payload files. This is used internally and should NOT be changed. | /spl/sploutput/staging |
SOA_DR_INTEGRATION_DIR | Mount point/directory from which Oracle DataRaker will consume the converted XML files. | /spl/sploutput/int |
Filtering Initial Measurement Data
The SGG adapter can be configured to filter initial measurement data passed into SGG and the Oracle Utilities Meter Data Management application. Filtering data is enabled by setting the <filterUsage> element in the EnvironmentSettings.xq file to “true” as follows:
<filterUsage>true</filterUsage>
When filtering is enabled, only measurements whose <externalUOM> matches one of the values defined in the Itron - UOM Code to Standard UOM Mapping extendable lookup (D8-HeadendUOMLookup) are passed into the system for processing.
Processing Large Input Files
In some environments, the OSB project may begin processing a large input file before it has been completely copied to the input directory. To prevent this, configure the MinimumAge property in the “InboundProxyService” proxy service for the project. The MinimumAge property specifies the minimum age of files to be retrieved, based on the last modified time stamp. This enables large files to be completely copied to the input directory before they are retrieved for processing.
Prioritized Initial Measurement Processing
The SGG adapter prioritizes processing of initial measurements created from smart meter commands and/or completion events by setting the Execution Method flag in these types of initial measurements to “Real Time” (D1RT). In addition, initial measurements received with the Execution Method flag set to “Real Time” will be processed in real time rather than via batch processing. See Initial Measurement Data Prioritization in the Oracle Utilities Meter Data Management / Smart Grid Gateway Business User Guide for more information.
Parent topic