Is there a easy solution for ORA-08004: sequence SEQ_1HOUR_USAGE_ID.NEXTVAL exceeds MAXVALUE and can
We're running Ops Center 12.3.0 with a remote DB. Rollups have been failing for months and at first it was thought (via the SR that's still open) that the issue was with the tablespace growth. However, after a truncate, the rollups still fail. After a recent test (using the cli to run a rollup manually), we uncovered these errors:
cacao.0:Caused by: java.sql.SQLException: ORA-08004: sequence SEQ_1HOUR_USAGE_ID.NEXTVAL exceeds MAXVALUE and cannot be instantiated
cacao.0:ORA-06512: at "OC12CSCHEMA.RM_RESOURCE_1HOUR_TREND_BR", line 3
cacao.0:ORA-04088: error during execution of trigger 'OC12CSCHEMA.RM_RESOURCE_1HOUR_TREND_BR'