Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Any ideas?

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question