Activation of aggregate & was canceled (next table name)

What causes this issue?

For each aggregate your own tables are created in ABAP Data Dictionary
and on the database. All the table names beginning with &V2& are
reserved for these tables.
The already used tables are managed in the catalog of the aggregates
(Table RSDDAGGLGT). When determining the next free table name according
to this management table the table name &V3& was determined. However,
an active table is already available under this name in the ABAP
Dictionary. Active tables are not automatically overwritten.

System Response

No more aggregates could be activated.

How to fix this error?

Remove the inconsistency in the catalog. In order to do this, delete
the tables that are no longer contained in the management catalog.
For this start report program [DS:REPO.RSDDAGG????]????</>.
Then save the aggregate &V1& for InfoCube &V4& again.
Reproduce the error again, then...
Search in OSS for a note on error message <ZH>RSDD003</>, the problem
may already be known.
Write a problem message. Please include the long text of this problem
message and describe which changes to the aggregates led to this error.

Error message extract from SAP system. Copyright SAP SE.