OraFAQ Forum: Server Administration » OLAP DML error "ORA-35571: The maximum number of load errors has occured." while executing

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)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

OLAP DML error "ORA-35571: The maximum number of load errors has occured." while executing [message #517911]

Fri, 29 July 2011 07:32

kesavansundaram
Messages: 134
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

Report message to a moderator

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

Michel Cadot
Messages: 54145
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 11:32:40 CDT 2013

Total time taken to generate the page: 0.11442 seconds