Hi
We have some problems using the Activity Report in SAP NW portal 6.0 (on WebAS 6.40).
The report type for hits on iviews/pages does not return any data at all. We get the "No content available for the specified period" result.
We have tried to change from/to data etc. but nothing helps.
I have made a SQL trace for this report at it reads the database table WCR_WEBCONTENTSTAT. I have checked the table and a lot of data exists in it. If I run a query directly on the table WITHOUT from/to-date in the WHERE-clause I get a lot of results, so I suspect the data-criteria in the activity report to be the cause of "No content available for the specified period"
Anyone who knows how to interpret the values og column "TIMESTAMPHOUR" in these WCR_* tables?
I.e. the value 1155758400000 - which data and hour would that be?