My Oracle Support Banner

IOTPM: Metric: Sum Time Where Sensor Parameters Exceeds A Limit (Doc ID 2669289.1)

Last updated on MAY 22, 2020

Applies to:

Internet of Things Cloud Service - Version 20.1.2 and later
Information in this document applies to any platform.

Goal

Customer would like to achieve the following business Requirement creating a Metric and using it in a Rule:

Business Requirements:
Some sensors may give dirty values from time to time, or some sensors may give peaks for example when the machine is switched on there is a pressure peak.

Is it possible to trigger the Rule when the condition is present for more than a certain number of seconds/minutes settable in order to do not take into account dirty values or temporary peaks that exist due to a physical fact (the machine switches on)

Questions regarding Metric creation:

1) Should customer use Time Sum Aggregator?
2) Can Oracle provide one example of Metric code because customer gets the following error:



Error: Error
Cause: Error on metric SQL query parsing - (1, 18): mismatched input
''Sensors'' expecting {'+', '-', '*', '/', FROM}

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.