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