Skip to Content
0
Former Member
Jan 11, 2006 at 06:09 PM

Portal activity report

24 Views

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