2 Replies Latest reply on Jul 27, 2011 3:59 PM by 446982

    ORA-34492: ORA-08176: consistent read failure; rollback data not available

    446982
      Hi David ,

      We ran a Cube using Maintain option in the fact table volume of 0.1 billion data with 6 dimension table and 3 dimension hierarchy table(each having 6-9 levels) and encounter below error:
      The fact table having 24 range partitions(each having ~4 million data) and based on month . Cube partitioning is on Monthly level . Fact table join with Time dimension is at daily level . Sparsity check against all dimensions and dimension hierarchies .
      We see 1st partition data has been processed (4 million) and throwing below error while trying to process cube for next partition and failed under Load section .

      Any clue ? Is it due to resource of database or misconfiguration in cube ? Is there any specific parameters under database which could resolve the issue ?

      INI: error creating a definition manager, Generic at TxsOqConnection::generic<BuildProcess>INI: XOQ-01600: OLAP DML error "ORA-34492: ORA-08176: consistent read failure; rollback data not available
      " while executing DML "SYS.AWXML!R11_LOAD_MEASURES('MARKET_SALES_CUBE.CUBE' SYS.AWXML!___R11_LONG_ARG_VALUE(SYS.AWXML!___R11_LONG_ARG_DIM 1) SYS.AWXML!___R11_LONG_ARG_VALUE(SYS.AWXML!___R11_LONG_ARG_DIM 2) SYS.AWXML!___R11_LONG_ARG_VALUE(SYS.AWXML!___R11_LONG_ARG_DIM 3) 'NO')", Generic at TxsOqStdFormCommand::execute



      An error has occurred on the server
      Error class: Express Failure
      Server error descriptions:
      INI: error creating a definition manager, Generic at TxsOqConnection::generic<BuildProcess>
      INI: XOQ-01600: OLAP DML error "ORA-34492: ORA-08176: consistent read failure; rollback data not available
      " while executing DML "SYS.AWXML!R11_LOAD_MEASURES('MARKET_SALES_CUBE.CUBE' SYS.AWXML!___R11_LONG_ARG_VALUE(SYS.AWXML!___R11_LONG_ARG_DIM 1) SYS.AWXML!___R11_LONG_ARG_VALUE(SYS.AWXML!___R11_LONG_ARG_DIM 2) SYS.AWXML!___R11_LONG_ARG_VALUE(SYS.AWXML!___R11_LONG_ARG_DIM 3) 'NO')", Generic at TxsOqStdFormCommand::execute

      at oracle.olapi.data.source.DataProvider.callGeneric(Unknown Source)
      at oracle.olapi.data.source.DataProvider.callGeneric(Unknown Source)
      at oracle.olapi.data.source.DataProvider.executeBuild(Unknown Source)
      at oracle.olap.awm.wizard.awbuild.UBuildWizardHelper$2.construct(Unknown Source)
      at oracle.olap.awm.ui.SwingWorker$2.run(Unknown Source)
      at java.lang.Thread.run(Thread.java:595)


      Thanks in advance,
      DxP