Skip to Content
2
Former Member
Aug 10, 2007 at 11:55 AM

Portal Activityreport -> Aggregation not possible at least partially done

292 Views

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.