Categories & Metrics - Active Portal

[Former Member]

I have defined 2 categories(category A & Category B) & some Metrics under each of these categories. I have also scheduled these Metrics to run under the same Time Interval and checked both "Current" & "Historize" in the Metric configuration. Also verified that each of these Metrics do return proper values when I do a Load Sample data.

Question:

However when I query the MetricHistory table, I see that Metric Values are inserted only for Metrics under Category A. There are no records for Metrics defined under Category B??? The configuration of these Metrics are identical. Any ideas?

[Former Member]

Hi Srini,

xMII contains two .htm pages you can use to view the current and historic values of your Metrics. The URLs are:

http:///Lighthammer/ActivePortal/MetricCurrent.htm and http:///Lighthammer/ActivePortal/MetricHistory.htm

(See the Help Documentation topic "Metrics and Monitoring Example").

When you view your Metric, you can right click on the applet and go to Data -> Detail. There may be an error message in there that will help you figure out what the problem is. There may also be information in your General Log.

Kind Regards,

Diana Hoppe

SAP xMII Technical Support

[Former Member]

Diana,

Thanks for your inputs. I checked the History URL:

http:///Lighthammer/ActivePortal/MetricHistory.htm

Here I selected a category, Metric and did a right click on the applet and went to Data -> Detail.

There were 2 fields - DateTime, MetricValue for the Selected Metric. What I saw was something like this.

02/13/2007 12:30:00 - 200

02/13/2007 12:35:01 - 210

02/13/2007 12:40:00 - 205 and so forth

So there were values for every 5 minutes, same as what I expected(since the scan time of the Metric was set at 5 minutes)

Now, there were another set of values just below the above values which was something like this -

02/13/2007 12:30:10 - 800

02/13/2007 12:35:11 - 850

02/13/2007 12:40:10 - 825 and so forth

Question:

1) The difference between the 1st set & 2nd set is only in the seconds, the minutes are the same - 12:30, 12:35 & 12:40 between these.

I never expected the 2nd set of values to show up in the page since the scan times are set at 5 minutes apart.

2) These values , I thought should come from the MetricHistory table in the ActivePortal database. When I query the MetricHistory table for the above Metric, I don't see any records for the second set of values???

Any ideas??

[Former Member]

Hi Rajesh,

There are no records in the MetricCurrent table as well. I verified the Metrics configuration for Category B Metrics once again. It seems to be allright. The load sample data returns values for the tags. So there seems to be no problem with that. The Historize & Current modes are checked as well. The Scan group is also set to 5min.

Now when the scheduler runs at 5 mins interval, it must update the MetricCurrent and MetricHistory tables with the Metric values. This is not happening and no records are found with these MetricIds? The role in the Metric config is set to Administrators.

Another set of metrics defined for Category A works fine and records are inserted in the MetricCurrent & MetricHistory tables. As mentioned, the Metric config for both these Categories are identical....

Thanks

[Former Member]

Hi Srini,

Loading data is not related with the scheduling or storing the data because whenever you press load data it runs the query template you mapped. Is there any difference between the expressions of Metric A & Metric B? Because while writing the expressions for the metric there should be space between the operands and operator. If both are having same expressions then the problem is something else..

One last thing i can suggest is go to the Active Portal database and see the content of table Metric Defenition. May be that helps...

Thanks,

Rajesh.

[Former Member]

Rajesh,

I understand that - Loading & Scheduling are two different things. There are no expressions defined. The metric here is just the direct tag output. I checked the Metric definitions table. Metric Ids have also been created for these Metrics. But somehow these Metrics are not getting Historized or stored either in the MetricHistory or MetricCurrent table.

Thanks

[Former Member]

Hi Srini,

When you say you saw a second set of values - were these values in a separate table when you did the right click Data -> Detail? I may be better able to assist if you would submit a message through the SAP Support Portal where you can send screenshots, copies of your query templates, and whatever other information may be relevant - some issues are difficult to diagnose without having all the pieces.

Kind Regards,

Diana Hoppe

[Former Member]

Hi Srini,

Can you check the values in the Metric Current table as well once. If the values are there then there is no problem in the configuration, otherwise check your metric configuration once.

Thanks,

Rajesh.