This discussion is archived
1 Reply Latest reply: Oct 24, 2012 3:31 AM by DavidGreenfield RSS

Aggregate Consistent error

Dileep Newbie
Currently Being Moderated
During cube refresh I get below error.

ORA-37162: OLAP error XOQ-01707: Oracle job "JOB$_7151" failed while executing slave build "TEST_AW.TEST USING (LOAD NO SYNCH, SOLVE) AS OF SCN 2343152864870" with error "37162: ORA-37162: OLAP error ORA-33216: The TEST_AW!TEST_P3_PRTCOMP dimension does not have a value numbered -66140. XOQ-01600: OLAP DML error while executing DML "SYS.AWXML!R11_AGGREGATE_CONSISTENT" ORA-06512: at "SYS.DBMS_CUBE", line 234 ORA-06512: at "SYS.DBMS_CUBE", line 316 ORA-06512: at line 1 ".

Olap version: 11.2.0.3

Any suggestions?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points