Portal Activity Report - Aggregator Finds Table Missing
I am having a problem with the aggregator tool associated with the portal Activity report.
When I run the aggregator I get the error message:
query = SELECT MAX(TIMESTAMPHOUR) FROM WCR_AGGINFO WHERE AGGREGATIONLEVEL = 'h'
Exception during query:
java.sql.SQLException: ORA-000942: table or view does not exist
Fatal: Couldn't get first aggregation timestamp entry.
Any ideas why the table is missing and how to fix it?
I know I have turned on the data configuration service and I have checked the documentation on the aggregator at http://help.sap.com/saphelp_nw04/helpdata/en/13/20a21d8f6048e8908611539aed131c/frameset.htm