重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-33557: (MAINTCHK01) You cannot string values of dimension workspace [打印本页]

作者: michaeljet 时间: 2016-9-2 11:05
标题: ORA-33557: (MAINTCHK01) You cannot string values of dimension workspace

ORA-33557: (MAINTCHK01) You cannot stringvalues ofdimension workspace

object during a loop over it.

Cause: User tried to insert or deletea value of the specified dimension while some

loop over that dimension was active. The loop could be anexplicit FOR or

ACROSS loop, or a natural expression evaluation orOLAP_TABLE loop. Also, it

could be a loop over the dimension itself or over aderived dimension (like a

composite or partition template) or dimension alias thatincludes it. The insert or

delete could be explicitly caused by the MAINTAINcommand. It is also possible

that the user attempted to assign a value to a variableor partition dimensioned by

a composite during a loop over that composite using aqualified data reference

(QDR), and that the exception was generated by theengine's attempt to insert a

new position in the composite to hold the new value.

Action: Move the dimension maintenanceor QDR-based variable assignment

outside the dimension loop.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)