cancel
Showing results for 
Search instead for 
Did you mean: 

Portal activity report

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Thanks for you reply.I am not really looking to code, but i am looking to fix this problem. What I am not understanding is that after running the aggregator application, does it create new data tables or we need to create those. if its creating new tables, why cant I retrieve them. ??

Former Member
0 Kudos

Hi Deepak,

In the "standard" way, you should use the <i>Portal Activity Report</i> iView

and not access the tables directly.

Therefore, there is no documentation regarding how exactly this data is saved and where.

Good luck in finding it,

Yoav.

Answers (0)