Category Archives: ORA Database Error Messages

ORA-32637: Self cyclic rule in sequential order MODEL

oracle

ORA-32637: Self cyclic rule in sequential order MODEL
Cause: A self-cyclic rule was detected in the sequential order MODEL. Sequential order MODELs cannot have self cyclic rules to guarantee that the results do not depend on the order of evaluation of the cells that are updated or upserted
Action: Use ordered rule evaluation for this rule

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32636: Too many rules in MODEL

oracle

ORA-32636: Too many rules in MODEL
Cause: The number of rules (possibly after rule unfolding) exceeded the maximum number of rules allowed
Action: Reduce the number of rules

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32635: not a single cell reference predicate

oracle

ORA-32635: not a single cell reference predicate
Cause: A predicate that is not a single cell reference predicate was specified where a single cell reference predicate was expected. A single cell reference predicate is either a constant expression or a predicate of the form
Action: Make sure that the predicate is a proper single cell reference. In some cases, you might have to put explicit type conversion operators (or casts) on the constant expression

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32634: automatic order MODEL evaluation does not converge

oracle

ORA-32634: automatic order MODEL evaluation does not converge
Cause: Evaluation using automatic rule ordering did not reach a convergence point
Action: Modify the rules or use sequential order instead

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32633: MODEL subquery FOR cell index returns too many rows

oracle

ORA-32633: MODEL subquery FOR cell index returns too many rows
Cause: Subquery in MODEL FOR cell index returned more than the allowed maximum
Action: Split the rule into multiple ones

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32632: incorrect subquery in MODEL FOR cell index

oracle

ORA-32632: incorrect subquery in MODEL FOR cell index
Cause: An illegal subquery was specified in MODEL FOR cell index. A subquery used in a MODEL FOR cell index can not have subqueries, correlation, binds and references to WITH tables
Action: Check the SQL statement and rewrite if necessary

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32631: illegal use of objects in MODEL

oracle

ORA-32631: illegal use of objects in MODEL
Cause: An object column was used as a MODEL column. Object types are not allowed as partition by, dimension by or measure expressions
Action: Check the SQL statement and rewrite if necessary

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32630: multiple assignment in automatic order MODEL

oracle

ORA-32630: multiple assignment in automatic order MODEL
Cause: A MODEL cell was updated on the same measure in multiple MODEL rules. Multiple assignment is not allowed in automatic order MODELs as it causes in ambiguity and nondeterminism
Action: Use sequential order MODEL or rewrite the rule to avoid this

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32629: measure used for referencing cannot be updated

oracle

ORA-32629: measure used for referencing cannot be updated
Cause: A measure used in nested referencing is updated by a MODEL rule in the automatic order MODEL
Action: Modify the SQL statement or use sequential order MODEL

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32628: invalid nesting of MODEL cell reference

oracle

ORA-32628: invalid nesting of MODEL cell reference
Cause: MODEL cell reference was nested too deeply
Action: Avoid deep nesting of cell references and rewrite if necessary

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/