Activity Report iView

[Former Member]

Hello all,

I have a question regarding Activity Report iView. We are using two portals. The support package level is SPS11 patch 6. The activity Report iView only works on one of the portals correctly. The data are displayed well. But the same iView on the other portal doesn't display any data. The message appears like: No data available for the chosen period.

I made the same settings on each portal.

I also made the right settings in the data configuration service.

Does anyone knows why the iView only works on one of our portals?

Thanks a lot in advance.

Best wishes

[Former Member]

Hi,

I have the same issue right now. Does anyone found out why is happening like this???

I really appreciate any inputs, Thanks a lot!!

[Former Member]

Hello,

There could be various reasons for such behaviors. I will present 2 of the most common reasons:

1. "DuplicateKeyException" issue -

An hourly aggregation takes place every hour during the day. When running a clustered environment, all server nodes "wake up" at the same time and try to perform the aggregation, so actually there is a race (since all server nodes are running the same application), and starting this moment data can't be collected (You can get a hint in NW7.0 from the "Status of Activity Reporting" iView when the following message appears: "The database contains non-aggregated data that is more than 2 hours old").

In order to release the "Traffic jam" which was formed, one should find the duplicated entry (Usually in the WCR_USERSTAT DB table), and remove it manually. Sometimes it is better to remove all the entries from this timestamp and maybe even the whole table.

However, this will only release the jam, but will not insure that it won't happen again on the next aggregation. In order to do so, you can take one of the following actions:

(a) Install NW04-SP21/NW7.0-SP13 and on.

(b) The recommended solution - Install the latest version of Activity Report, which can be downloaded from SAP note 1084379 - "Portal Activity Report - Latest version (SDA file)".

This behavior was fixed in NW04-SP21 / NW7.0-SP13, and was even improved in future versions (NW7.0 - SP17).

For further details please see SAP note 1054145.

2. The selected iViews are not same iViews which are in fact inside the role -

The aggregation is OK, all the data is present within the DB, but when you try to generate a content report (iView/Pages report), you receive nothing or very little.

This usually happens when one adds to the report the source iView itself (the ancestor), rather than the role which this iView was assigned to (Notice that the iView which lay under the role has a different ID and a different PCD URL than the ancestor iView). This causes the report to display the source iView, which of course, is not accessible to any of the end users.

Hope this helps!

Lior Baz

Installed Base Development

NetWeaver Portal Platform

SAP Labs Israel