Oracle Database Errors or Warnings from Error ORA-36226 to ORA-36250

SQLServerF1

ORA-36226: (XSLPDSC07) The syntax of the $LOOP property on formula workspace object is incorrect.
Cause: Unrecognized contents in the $LOOP property of a formula in the table function measure list.
Action: Restrict the contents of the $LOOP property to valid elements (other than OPTIMIZED and MEASURES) of the table function LOOP directive.
ORA-36230: (XSANALYZ00) object workspace object cannot be used in the ANALYZE command
Cause: An object that cannot be analyzed was used in the ANALYZE command.
Action: Analyze VARIABLES, RELATIONS, DIMENSIONS, or SURROGATES.
ORA-36231: (XSANALYZ01) object workspace object cannot be used in the INHIERARCHY clause
Cause: An invalid INHIERARCHY object was referenced.
Action: Use either a VALUESET or boolean VARIABLE.

ORA-36232: (XSANALYZ02) a level list was specified when a language dimension was present
Cause: A level list dimension was specified when a language dimension was present.
Action: Remove the USING clause.
ORA-36233: (XSANALYZ03) the dimensionality of object workspace object does not match the ANALYZE command
Cause: The dimensionality of the object did not match the ANALYZE command syntax used.
Action: Match the ANALYZE syntax to the dimensionality of the specified object.
ORA-36234: (XSANALYZ04) all objects in the current status of the NAME dimension must have the same dimensionality when used with the ANALYZE command
Cause: The dimensionality of at least one of the objects listed in the NAME dimension does not match the rest of the objects.
Action: Make sure all objects listed in the NAME dimension have the same dimensionality.
ORA-36235: (XSANALYZ05) the database compatibility must be 11.0.0.0 or higher
Cause: The compatibe mode is not 11.0.0.0 or higher
Action: Make sure the compatible mode is 11.0.0.0 or higher

ORA-36236: (XSANALYZ06) the AW format must be 11.0.0.0 or higher to use the ANALYZE command
Cause: The AW version is less than 11.0.0.0
Action: Make sure the compatible mode is 11.0.0.0 or higher and upgrade the AW
ORA-36237: (XSANALYZ07) analytic workspace string.string must be attached RW or EXCLUSIVE mode
Cause: The analytic workspace was already attached RO or MULTI mode.
Action: Detach the analytic workspace.
ORA-36238: (XSANALYZ08) object string.string does not exist
Cause: The object name does not exist
Action: Check the spelling and case of the object name
ORA-36250: (XSVALSET00) VALUESET workspace object should be a non-dimensioned valueset, not a dimensioned valueset
Cause: A dimensioned valueset is used where a non-dimensioned valueset is required.
Action: Correct the phrase to have a non-dimensioned valueset.

Above are list of Oracle Database Errors or Warnings from Error ORA-36226 to ORA-36250 received while performing certain operation against Oracle Database or related products.

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *