Hi out there,
we are running EP 7 SP 10. I am trying to activate the Portal Activity Reporting and I have some problem with the aggregation. In the server.log I see an error message from com.sap.portal.activityreport.aggregator: "Aggregation not possible at least partailly done". Here some lines from the log file:
"08/10/2007","13:19:48:165","Aggregation took 63 millis",
"08/10/2007","13:19:48:165","Commit done",
"08/10/2007","13:19:48:149","SQL DELETE: DELETE FROM WCR_AGGINFO WHERE AGGREGATIONLEVEL = h AND TIMESTAMPHOUR <= 1184152788117",
"08/10/2007","13:19:48:149","SQL DELETE: DELETE FROM WCR_WEBCONTENTSTAT WHERE AGGREGATIONLEVEL = h AND TIMESTAMPHOUR <= 1184152788117",
"08/10/2007","13:19:48:149","SQL DELETE: DELETE FROM WCR_USERSTAT WHERE AGGREGATIONLEVEL = h AND TIMESTAMPHOUR <= 1184152788117",
"08/10/2007","13:19:48:149","SQL DELETE: DELETE FROM WCR_USERNODELOGON WHERE TIMESTAMPHOUR <= 1186744788117",
"08/10/2007","13:19:48:134","SQL DELETE: DELETE FROM WCR_WEBCNODESTAT WHERE TIMESTAMPHOUR <= 1186744788117",
"08/10/2007","13:19:48:134","SQL DELETE: DELETE FROM WCR_USERNODESTAT WHERE TIMESTAMPHOUR <= 1186744788117",
"08/10/2007","13:19:48:134","Aggregation not possible at least partailly done",
"08/10/2007","13:19:48:134","First run at 10 Aug 2007 11:00:00 GMT",
"08/10/2007","13:19:48:118","query = SELECT MAX(TIMESTAMPHOUR) FROM WCR_AGGINFO WHERE AGGREGATIONLEVEL = h",
"08/10/2007","13:19:48:118","*********** Aggregating data from 1 Jan 2004 00:00:48 GMT to 10 Aug 2007 11:19:48 GMT ***********",
"08/10/2007","13:19:48:118","",
"08/10/2007","13:19:48:118","Current Database Time: 10 Aug 2007 11:19:48 GMT",
"08/10/2007","13:19:48:102","Aggregator Started...",
I have raised log and trace levels like mentioned in OSS 1054145 to get more information. But maybe anyone can already give me a hint how to hunt this down?!?
Best Regards
Juergen Kuechle.