This discussion is archived
2 Replies Latest reply: Jul 27, 2011 8:59 AM by 446982 RSS

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

446982 Newbie
Currently Being Moderated
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

Legend

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