on 01-11-2006 6:09 PM
Hi there,
I have done everything by following the docs to implement portal activity report and I was able to start the aggregator application. Aggregator application finishing its job on the following last few lines that I am cutting and pasting it here...
Info: aggregation of iViews and pages finished successfully query = INSERT INTO WCR_AGGINFO(TIMESTAMPHOUR,AGGREGATIONLEVEL,LASTAGGLEVEL,NUMAGGREGATES) VALUES (0,'h',' ',0) Commit done Inserted 1 rows in table WCR_AGGINFO
Info: updating Aggregation Info table finished successfully
SQL DELETE: DELETE FROM WCR_USERNODESTAT WHERE TIMESTAMPHOUR <= 1136995212440 SQL DELETE: DELETE FROM WCR_WEBCNODESTAT WHERE TIMESTAMPHOUR <= 1136995212440 SQL DELETE: DELETE FROM WCR_USERSTAT WHERE AGGREGATIONLEVEL = 'h' AND TIMESTAMPHOUR <= 1134403212440 SQL DELETE: DELETE FROM WCR_WEBCONTENTSTAT WHERE AGGREGATIONLEVEL = 'h' AND TIMESTAMPHOUR <= 1134403212440 SQL DELETE: DELETE FROM WCR_AGGINFO WHERE AGGREGATIONLEVEL = 'h' AND TIMESTAMPHOUR <= 1134403212440 Commit done Aggregation took 294 millis Sleeping until next aggregation period.
I tried to access the tables , but none of them exist.
it tried to access the infomation through iviews and
it will only show me one day report.
Does anyone one what else I can do to fix this problem
Hi Deepak,
You can try prakash weblog here:
It describes a way to save information yourself when a page is accessed, and develop your own reports based upon it.
It gives you more control, in two ways:
1. You decide what information to save and how/where.
2. You decide how to display it.
Hope that helps,
Yoav.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.