1 Reply Latest reply: Oct 24, 2012 5:31 AM by DavidGreenfield RSS

    Aggregate Consistent error

      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:

      Any suggestions?