Home » RDBMS Server » Server Administration » OLAP DML error "ORA-35571: The maximum number of load errors has occured." while executing (oracle 11.2.0.1.0 linux 2.6)
OLAP DML error "ORA-35571: The maximum number of load errors has occured." while executing [message #517911] Fri, 29 July 2011 07:32 Go to next message
kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI
Senior Member
Dear sir /Madam,

In our development database, we have created 5 dimensions and a cube with 2 measures in OLAP. All these are mapped to relational tables. When we try to load this cube (MAINTAIN CUBE option from AWM) we are getting this below error:


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-35571: The maximum number of load errors has occured." while executing DML "SYS.AWXML!R11_LOAD_MEASURES('CUBE_CALLER_EXPERIENCE.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)


i request you to advise further what are the database parameter i should look for as a DBA ?.

thank you
kesavan
Re: OLAP DML error "ORA-35571: The maximum number of load errors has occured." while execu [message #517914 is a reply to message #517911] Fri, 29 July 2011 07:39 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-35571: (XSRWLD07) The maximum number of load errors has occured.
 *Cause: The number of load errors has exceeded the specified maximum.
 *Action: Fix the load errors or increase the maximum number allowed and rerun the load.

Regards
Michel
Previous Topic: Precautions before drop user
Next Topic: how to find out no.of CPUs allocated to a specific Database ?
Goto Forum:
  


Current Time: Sun Dec 01 12:26:21 CST 2024