Skip Headers
Oracle® Database Error Messages
10g Release 2 (10.2)

Part Number B14219-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

18 ORA-33000 to ORA-37999

ORA-33000: (AGOPEN00) AGGMAP workspace object cannot be accessed because it was compiled by a more recent version of string.
Cause: The AGGMAP was already compiled by a more recent version of the product than was being used to execute this command.
Action: Recompile the AGGMAP in the current version.
ORA-33002: (XSAGDNGL00) In AGGMAP workspace object, the FLOOR argument of number must be less than the CEILING argument of number.
Cause: The user specified a floor argument greater than the ceiling argument.
Action: Adjust the floor and ceiling arguments so that the floor is less than the ceiling. OBSOLETE, please remove this
ORA-33003: (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimension and not otherwise referenced in the AGGMAP.
Cause: The user tried to specify a dimension in a dataflow-related clause in an aggmap which is already in another RELATION statement, DIMENSION statement, or possibly dimensioning the AGGMAP, or they specified a composite or conjoint dimension, or an object which is not a dimension
Action: Remove the conflicting reference or specify a valid object
ORA-33004: (XSAGDNGL01) workspace object is not a relationship array.
Cause: A RELATION clause in the AGGMAP named a workspace object that is not a relation.
Action: Name a valid self-relation in the RELATION statement.
ORA-33005: (XSAGDIMBREAK) Invalid breakout for dimension workspace object.
Cause: The user specified something that was not a valid dimension or relation on a BREAKOUTDIM line in an aggmap. This might be because the object was not a valid relation, was not over the specified dimension or was multidimensional
Action: Use a valid relation instead
ORA-33006: (XSAGDNGL02) The relation workspace object is not related to itself.
Cause: A relation was named in a RELATION clause of the AGGMAP that is not a self-relation.
Action: Name a valid self-relation in the RELATION statement.
ORA-33008: (XSAGDNGL03) The relation workspace object is not a relation over a base dimension of AGGMAP workspace object.
Cause: A relation was named in a RELATION clause of the AGGMAP that is not a relation for a base dimension of the AGGMAP.
Action: Name a valid self-relation in the RELATION statement, that is, one that has a dimension that dimensions the AGGMAP.
ORA-33009: (XSAGDNGLPREC) In AGGMAP workspace object, PRECOMPUTE may only be specified either for the entire AGGMAP or for individual RELATION statements.
Cause: PRECOMPUTE was specified both as a line in the AGGMAP and on at least one of the RELATION lines, or it was specified more than once as a line of the AGGMAP.
Action: Remove either the PRECOMPUTE line, or the PRECOMPUTE specification for all of the RELATION lines.
ORA-33010: (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
Cause: Two RELATION statements in the AGGMAP reference the same relation object.
Action: Remove the duplicate RELATION statement.
ORA-33012: (XSAGDNGL05) AGGMAP workspace object contains invalid syntax.
Cause: A line in the AGGMAP contains invalid syntax.
Action: Change the line to have valid syntax.
ORA-33014: (XSAGDNGL06) In AGGMAP workspace object, variable operator workspace object cannot be dimensioned by rollup dimension workspace object.
Cause: Operator variables cannot have the rollup dimension as one of their base dimensions.
Action: Modify the definition of the operator variable so that the current rollup dimension is not one of its bases.
ORA-33016: (XSAGDNGL07) In AGGMAP workspace object, workspace object is not a valid operator or variable name.
Cause: An invalid argument was supplied to the OPERATOR clause in the relation statement.
Action: Fix the OPERATOR clause so that it specifies either a valid variable name or a valid operator.
ORA-33018: (XSAGDNGL08) In AGGMAP workspace object, the data type of workspace object must be TEXT, not string.
Cause: An operator variable was supplied whose data type is not TEXT.
Action: Change the operator clause to reference a TEXT variable.
ORA-33022: (XSAGDNGL10) The measure dimension workspace object must be a TEXT or ID base dimension that does not dimension AGGMAP workspace object, but is in the same analytic workspace.
Cause: A MEASUREDIM was supplied in the AGGMAP that was not acceptable.
Action: Modify the MEASUREDIM clause to specify a valid dimension.
ORA-33024: (XSAGDNGL11) AGGMAP workspace object contains duplicate information.
Cause: The aggmap contains multiple instances of a clause that can only be specified once.
Action: Remove the extra clause.
ORA-33030: (XSAGDNGL14) In AGGMAP workspace object, you can have either a single independent PROTECT statement or PROTECT statements in your RELATION statements.
Cause: The AGGMAP either specified multiple PROTECT statements not on a RELATION line, or specified PROTECT statements both independently and on RELATION lines.
Action: Correct the AGGMAP to have valid syntax.
ORA-33036: (XSAGDNGL17) ARGS option workspace object must be a TEXT variable.
Cause: An ARGS value had a non-text data type.
Action: Use a text variable for ARGS.
ORA-33046: (XSAGDNGL22) In AGGMAP workspace object, you can specify only one SCREENBY clause.
Cause: The AGGMAP contained multiple SCREENBY clauses.
Action: Remove one of the SCREENBY clauses from the AGGMAP.
ORA-33048: (XSAGDNGL23) In AGGMAP workspace object, the relation workspace object and the relation workspace object are both over the same base dimension.
Cause: The AGGMAP contains incompatible RELATION statements.
Action: Remove one of the RELATION statements from the AGGMAP.
ORA-33050: (XSAGDNGL24) AGGMAP workspace object cannot be used to aggregate workspace object, because it is defined in a different analytic workspace.
Cause: The user attempted to aggregate a variable in another analytic workspace.
Action: Create an AGGMAP in the other analytic workspace to aggregate that variable.
ORA-33052: (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.
Cause: The user attempted to aggregate a variable with different dimensions than the AGGMAP. This is only possible with undimensioned AGGMAPs.
Action: Create a new undimensioned AGGMAP.
ORA-33058: (XSAGDNGL28) In AGGMAP workspace object, error code string is greater than the maximum error code of number.
Cause: The user specified an invalid ERRORMASK value.
Action: Remove the invalid value from the ERRORMASK list.
ORA-33060: (XSAGDNGL29) In AGGMAP workspace object, the value for the ERRORLOG MAX option must be greater than 0.
Cause: The user specified an ERRORLOG MAX of 0 or a negative number.
Action: Adjust the AGGMAP so that it uses a positive number.
ORA-33064: (XSAGDNGL31) In AGGMAP workspace object, the hierarchy dimension QDR workspace object cannot refer to the related dimension of the relation.
Cause: The user specified an invalid hierarchy dimension qualified data reference.
Action: Adjust the AGGMAP so that it uses a valid dimension value qualified data reference.
ORA-33066: (XSAGDNGL32) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must be a hierarchy dimension of the relation.
Cause: The user specified an invalid qualified data reference for the hierarchy dimension.
Action: Adjust the AGGMAP so that it uses a valid dimension value qualified data reference.
ORA-33068: (XSAGDNGL33) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must specify a positive dimension offset.
Cause: The user specified an invalid qualified data reference for the hierarchy dimension.
Action: Adjust the AGGMAP so that it uses a valid dimension value qualified data reference.
ORA-33070: (XSAGDNGL34) In AGGMAP workspace object, all QDRs of dimension workspace object must map to the same dimension position.
Cause: The user specified two conflicting hierarchy dimension qualified data references.
Action: Adjust the AGGMAP so that it uses a consistent qualified data reference.
ORA-33072: (XSAGDNGL35) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must be specified for every relation dimensioned by that hierarchy dimension.
Cause: Multiple dimensions share the same hierarchy dimension, but it is only qualified within a subset of the AGGMAP relations.
Action: Adjust the AGGMAP so that it uses consistent qualified data references.
ORA-33074: (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.
Cause: The hierarchy dimension offset is an invalid dimension position.
Action: Adjust the AGGMAP so that it uses valid qualified data references.
ORA-33076: (XSAGDNGL37) In AGGMAP workspace object, the value "number" is not a valid value of dimension workspace object.
Cause: The hierarchy dimension offset is an invalid dimension position.
Action: Adjust the AGGMAP so that it uses valid qualified data references.
ORA-33078: (XSAGDNGL39) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must refer to a dimension.
Cause: The user specified an invalid qualified data reference for the hierarchy dimension.
Action: Adjust the AGGMAP so that it uses a valid dimension value qualified data reference.
ORA-33080: (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.
Cause: The user included both RELATION and DIMENSION statements in the AGGMAP referring to the same AGGMAP.
Action: Remove one of the conflicting clauses.
ORA-33082: (XSAGDNGL41) In AGGMAP workspace object, the non-dimensioned valueset workspace object must have a parent QDR in its VALUESET statement over the VALUESET"s base dimension.
Cause: The VALUESET statement specified a scalar valueset but did not include a qualified data reference to specify the parent.
Action: Add a qualified data reference specifying the parent to the VALUESET statement.
ORA-33084: (XSAGDNGL42) In AGGMAP workspace object, you cannot qualify the dimensioned valueset workspace object.
Cause: The VALUESET line referred to a dimensioned valueset.
Action: Use a non-dimensioned valueset to limit the status of the dimensioned one.
ORA-33086: (XSAGINIT01) AGGMAP workspace object cannot be dimensioned by a conjoint dimension.
Cause: The specified AGGMAP was dimensioned by a conjoint dimension.
Action: Use the CHGDFN command to change the conjoint to a composite dimension.
ORA-33092: (XSAGCOMP04) number is not the name of a MODEL in any attached analytic workspace.
Cause: An invalid model name was attached to an AGGMAP.
Action: Remove the model from the AGGMAP or create a model with that name.
ORA-33094: (XSAGGMAPLIST01) Your expression uses too much execution space. Eliminate recursion or reduce the levels of nesting.
Cause: formulas likely refer to each other recursively or with a great deal of depth.
Action: eliminate recursion and flatten formula trees.
ORA-33098: (APABBR01) A value of "string" is not valid for the workspace object option.
Cause: An inappropriate value was specified for the named option.
Action: Set a legal value for the option.
ORA-33100: (APABBR02) Value "number" is not valid for the workspace object option.
Cause: An inappropriate value was specified for the named option.
Action: Set a legal value for the option.
ORA-33213: (CINSERT06) The target position for MAINTAIN ADD or MAINTAIN MOVE cannot fall in the range of session-only values.
Cause: The user specified a BEFORE or AFTER clause specifying a position in the range of SESSION dimension values.
Action: Do not use a position clause, or specify a position before the first SESSION value.
ORA-33214: (CINSERT02) The workspace object dimension is too large.
Cause: The dimension has too many values.
Action: Deleted values can still take up space in the dimension and cause this error. Try removing the deleted values by exporting the dimension to EIF and reimporting it with the REPLACE DELETE option.
ORA-33215: (CINSERT07) You cannot add session-only values to the workspace object dimension.
Cause: The user tried to add a SESSION dimension value while a spreadsheet spreadsheet cursor was open.
Action: Try adding the SESSION value while the cursor is not active.
ORA-33217: (CINSERT20) Custom member values cannot be added to concat dimension workspace object, or to any of its bases, because it is not defined as UNIQUE.
Cause: Only UNIQUE concat dimensions can have custom member values.
Action: Use the CHGDFN command to change the concat dimension to UNIQUE and retry.
ORA-33218: (CINSERT04) %K is not a valid value for the workspace object dimension. Values for this dimension can have at most number significant digits after rounding to number decimal places.
Cause: The user attempted to insert a value that had too many digits into a NUMBER dimension. For instance, the user might have tried to insert the value 99999 (5 digits) into a dimension with data type NUMBER(4).
Action: Use a smaller number for the dimension value, or define a new dimension with a larger precision and replace the old dimension with the new one.
ORA-33219: (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.
Cause: A value cannot be added to a dimension if it conflicts with an existing value in a unique concat dimension containing this dimension.
Action: The concat(s) causing the conflict could be CHGDFNed to NOT UNIQUE, or either of the duplicate values could be renamed to make them UNIQUE.
ORA-33223: (CMOVE03) You cannot move a session-only dimension value.
Cause: The user named a SESSION dimension value in the MAINTAIN MOVE command.
Action: Do not try to MAINTAIN MOVE session-only dimension values.
ORA-33247: (CRENAME03) %K is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.
Cause: A value cannot be renamed in a dimension if the new value conflicts with an existing value in a unique concat dimension containing this dimension.
Action: The concat(s) causing the conflict could be CHGDFNed to NOT UNIQUE, or either of the duplicate values could be changed to make them UNIQUE.
ORA-33261: (DBERRLEN) Analytic workspace string extension number truncated at number bytes while trying to read at number.
Cause: Either an internal error or a mistaken user has truncated the AW
Action: Export any data if possible and restore from backup
ORA-33262: (DBERR01) Analytic workspace string does not exist.
Cause: The analytic workspace requested does not seem to be in the current database
Action: Check that you are in the correct schema and have access to the requested AW.
ORA-33263: Could not create analytic workspace string
Cause: A serious error was encountered while trying to set up the tables for the named analytic workspace. Possibilities include a tablespace that can"t be written to, corrupted metadata about which AWs exist, bogus tables with names the code expects to be able to use, or the remains of a partially removed AW.
Action: There should be another error on the error stack. Consult it to determine what is causing the problem and remove that table.
ORA-33265: (DBERRBSZ) Analytic workspace string cannot be opened. Tablespace blocksize number does not match database cache size number.
Cause: The blocksize of the containing tablespace didn"t match database cache size.
Action: Change either size to make them consistent, or set olap_page_pool_size to 0 to allow automatic OLAP pool management when compatibility is greater than 10.2.
ORA-33267: (DBERRRLS) Analytic workspace string cannot be accessed because it has fine-grained access control applied to it
Cause: An attempt was made to access the specified analytic workspace"s LOB table. The OLAP option detected the table had fine-grained security applied to it. The OLAP option requires full access to this table to operate correctly.
Action: Remove the fine-grained access control.
ORA-33269: while operating on "string"
Cause: Error is raised to inform user what object was being worked on when an error occurred during the creation of an AW. It should always be signaled with 33263
Action: See error#33263
ORA-33270: (DBERR05) Analytic workspace string already exists.
Cause: The AW CREATE command was passed the name of an analytic workspace that already exists
Action: Specify a different name.
ORA-33274: (DBERR07) Timed out while trying to lock analytic workspace string for string.
Cause: A lock operation that was supposed to happen very quickly was taking too long. It can be due to another session being stopped while holding that lock, another session crashing while holding that lock, or an internal error.
Action: If another session is stopped, resume that session to let it release the lock. If another session has crashed, wait for a few minutes while PMON or SMON process is recovering that lock. Contact Oracle OLAP Support if none of the situations above apply.
ORA-33278: (DBERR09) Analytic workspace string cannot be attached in RW or EXCLUSIVE mode until the changes made and updated in MULTI mode are committed or rolled back.
Cause: There are still changes to this analytic workspace that were updated and not committed when the workspace was attached in MULTI mode.
Action: Either try attaching the workspace is RO or MULTI mode or commit or roll back the transaction before trying to attach the workspace in RW or EXCLUSIVE mode.
ORA-33280: (DBERR10) Analytic workspace string cannot be attached in MULTI mode until the changes made and updated in RW or EXCLUSIVE mode are committed or rolled back.
Cause: There are still changes to this analytic workspace that were updated and not committed when the workspace was attached in RW or EXCLUSIVE mode.
Action: Either try attaching the workspace is RO, RW, or EXCLUSIVE mode or commit or roll back the transaction before trying to attach the workspace in MULTI mode.
ORA-33282: (DBERR11) Cannot wait for analytic workspace string to become available since doing so would cause a deadlock.
Cause: Trying to wait for the workspace to become available caused a deadlock.
Action: Release an analytic workspace that some other user might be waiting for before proceeding to attach this analytic workspace in this mode.
ORA-33284: (DBERR12) Analytic workspace string cannot be opened in MULTI mode before converting it by the latest version of string.
Cause: The AW is stored in 9i format.
Action: Convert the AW to a later format
ORA-33288: (DBERR15) Another user has incompatible access to analytic workspace string, and the wait timeout has expired.
Cause: An attempt to access an analytic workspace conflicted with another user"s access, and the timeout specified has elapsed.
Action: Wait until the conflicting user is done.
ORA-33290: (DBERR17) Analytic workspace string cannot be attached in the mode you requested because another user has it attached in an incompatible mode.
Cause: An attempt to access an analytic workspace conflicted with another user"s access, and no timeout was specified
Action: Wait until the conflicting user is done.
ORA-33292: (DBERR18) insufficient permissions to access analytic workspace string using the specified access mode.
Cause: You do not have sufficient permissions to access this analytic workspace in the desired mode.
Action: Ask the owner of the schema or OLAP DBA to grant you sufficient permissions to access the {SCHEMA}.AW${AWNAME} table (for example, SCOTT.AW$FOO table).
ORA-33297: (DBERR22) Analytic workspace string cannot be opened because it was last modified by an incompatible version of string.
Cause: The user attempted to attach an old OLAP Services analytic workspace that cannot be converted by this version of OLAP Services.
Action: Either create a new analytic workspace or try using a version of OLAP Services compatible with the one that created this analytic workspace.
ORA-33298: (AWUPG01) Analytic Workspace string is already in the newest format allowed by the current compatibility setting
Cause: User ran the DBMS_AW.CONVERT procedure on an Analytic Workspace that was created in or previously upgraded to the current compatibility mode.
Action: If upgrading the Analytic Workspace is necessary, upgrade the database instance and then re-run DBMS_AW.CONVERT. If the new features offered by upgrading the Analytic Workspace are not required, then no action is needed.
ORA-33302: (DBVALID01) SEVERE ERROR: Record number multiply used.
Cause: The AW VALIDATE command has detected an error in the structure of the analytic workspace. This error will result in the corruption of one or more objects
Action: Export what you can of the analytic workspace.
ORA-33304: (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.
Cause: This is a benign message. The AW VALIDATE command found an analytic workspace has some inaccessible space.
Action: Either nothing, or export and recreate the analytic workspace
ORA-33305: (DBVALID06) Note: Record number was allocated but not used. This can result in wasted space. (PS number)
Cause: This is a benign message. The AW VALIDATE command found an analytic workspace has some inaccessible space.
Action: Either nothing, or export and recreate the analytic workspace
ORA-33306: (DBVALID03) The AW VALIDATE command cannot be used with read-only analytic workspace string.
Cause: The AW VALIDATE command does not support read-only access.
Action: Attach the analytic workspace read/write and try again.
ORA-33308: (DBVALID04) SEVERE ERROR: Record number used but not allocated
Cause: The AW VALIDATE command has detected a problem that will result in corruption of the analytic workspace. There is no corruption yet.
Action: Export and recreate the analytic workspace.
ORA-33309: (DBVALID05) SEVERE ERROR: Record number used but not allocated (PS number)
Cause: The AW VALIDATE command has detected a problem that will result in corruption of the analytic workspace. There is no corruption yet.
Action: Export and recreate the analytic workspace.
ORA-33313: (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.
Cause: User attempted to delete a variable, but some partitioned variable was defined to use that variable as the target of one of its external partitions.
Action: DELETE the partitioned variable or CHGDFN DROP PARTITION the the external partition from the partitioned variable, then delete the target variable.
ORA-33315: (XSDELDENTANON) You cannot delete workspace object while looping over unnamed composite workspace object.
Cause: While looping over the named anonymous composite, an attempt was made to delete an object which is dimensioned by it.
Action: Delete the object outside of a loop over the dimension.
ORA-33332: (DSSEXIST01) Use the AW command to establish a current analytic workspace. Then start your current activity again.
Cause: There is no currently active analytic workspace. The command that generated the error requires an active analytic workspace to operate on.
Action: Execute an AW ATTACH or AW CREATE command to establish an active workspace.
ORA-33334: (DSSEXIST04) Analytic workspace string is not attached.
Cause: The specified analytic workspace is currently not attached to the session, or the name is misspelled.
Action: Attach the analytic workspace with the AW ATTACH command, or correct the spelling of the name .
ORA-33336: (DSSEXIST04A) Analytic workspace string is not attached.
Cause: The specified analytic workspace is currently not attached to the session, or the name is misspelled.
Action: Attach the analytic workspace with the AW ATTACH command, or correct the spelling of the name .
ORA-33338: (DSSEXIST05) You cannot specify the EXPTEMP analytic workspace.
Cause: The command requires a non-temporary analytic workspace to operate on.
Action: Specify an analytic workspace other than EXPTEMP.
ORA-33413: (EIFMAKEF01) You cannot export compressed composite workspace object because one of its bases has limited status or a PERMIT READ restriction.
Cause: Export of a compressed composite to an EIF file or lob failed because one or more of the bases had some values that were not in the current status. This can be caused either by a LIMIT command or a PERMIT READ restriction on the dimension.
Action: Either set the base dimensions" statuses to ALL and remove their PERMIT READ programs, or export using the NOAGGR keyword.
ORA-33425: (EIFMAKEF15) CAUTION: Exporting NTEXT objects using string for the EIF file character set can cause loss of data. To preserve all NTEXT data, export using the UTF8 character set for the EIF file.
Cause: The user exported an object with data type NTEXT, but the EIF file that will result from the EXPORT command is not written in Unicode. Because no non-Unicode file can represent all possible Unicode data, it is possible that some data will be lost when converting from the Unicode NTEXT object to the EIF file. The EIF file will be written in the character set indicated by the "nls_charset" argument of the EXPORT command, or, if no such argument is present, in the database character set.
Action: If the user is certain that the contents of the NTEXT object can be represented in the specified character set, then no action is necessary. Otherwise, the user can add "nls_charset "UTF8"" to the EXPORT command string. This will result in the EIF file being written in UTF8 Unicode, which can represent all the data contained in NTEXT objects.
ORA-33427: (EIFMAKEF16) CAUTION: NTEXT object workspace object will be exported with type TEXT.
Cause: User attempted to export an object whose data type is NTEXT, but but the EIFVERSION option indicates a version of Express / Oracle OLAP that does not support the NTEXT data type. The object will be exported as a TEXT object instead.
Action: No action needed.
ORA-33429: (EIFMAKEF17) CAUTION: NTEXT expression will be exported with type TEXT.
Cause: User attempted to export an expression whose data type is NTEXT, but but the EIFVERSION option indicates a version of Express / Oracle OLAP that does not support the NTEXT data type. The expression will be exported as a TEXT object instead.
Action: No action needed.
ORA-33443: (ESDREAD14) Discarding compiled code for workspace object because analytic workspace string is not attached.
Cause: A program used an analytic workspace name in a qualified object name. The named analytic workspace is not attached at program run time.
Action: No action necessary. The program will be automatically recompiled. It is likely that the recompile will fail with an appropriate exception code, in which case the signaled condition should be corrected and the program re-run.
ORA-33445: (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.
Cause: Two variables are "partition-dependent" if they share any external partition target variables, or if one is the target of an external partition of the other. If object names referred to non-partition-dependent variables at compile time but refer to partition-dependent variables in the run-time context, the OLAP DML program, formula, or model will be automatically recompiled.
Action: None needed.
ORA-33447: (ESDREAD16) Discarding compiled code for workspace object because workspace object and workspace object, which were partition-dependent when the code was compiled, are now not partition-dependent.
Cause: Two variables are "partition-dependent" if they share any external partition target variables, or if one is the target of an external partition of the other. If object names referred to partition-dependent variables at compile time but refer to non-partition-dependent variables in the run-time context, the OLAP DML program, formula, or model will be automatically recompiled.
Action: None needed.
ORA-33448: (ESDREAD04) Discarding compiled code for workspace object because number now has string data, whereas it had string data when the code was compiled.
Cause: The datatype of the specified variable has changed.
Action: None needed.
ORA-33449: (ESDREAD17) Discarding compiled code for workspace object because the partition method or partition dimension of number has changed since it was compiled.
Cause: The partitioning method (LIST, RANGE, or CONCAT) or the partition dimension of the partition template is sufficiently different from what it was when the code was compiled that the code must be recompiled.
Action: None needed.
ORA-33450: (ESDREAD05) Discarding compiled code for workspace object because number now has more or fewer dimensions than it had when the code was compiled.
Cause: The dimensionality of the specified object has changed.
Action: None needed.
ORA-33452: (ESDREAD06) Discarding compiled code for workspace object because number is now dimensioned by workspace object. It was dimensioned by workspace object when the code was compiled.
Cause: The dimensionality of the specified object has changed.
Action: None needed.
ORA-33454: (ESDREAD07) Discarding compiled code for workspace object because number is now string workspace object, whereas it was string workspace object when the code was compiled.
Cause: The specified object has changed.
Action: None needed.
ORA-33456: (ESDREAD08) Discarding compiled code for workspace object because number is a(n) string, which string did not expect to find in a compiled program.
Cause: The type of the specified object has changed.
Action: None needed.
ORA-33458: (ESDREAD09) Discarding compiled code for workspace object because number is now type string, whereas it was type string when the code was compiled.
Cause: The type of the specified object has changed.
Action: None needed.
ORA-33460: (ESDREAD10) Discarding compiled code for workspace object because object workspace object is not in analytic workspace string.
Cause: The specified object is not in the same analytic workspace it was in when the compiled object was compiled.
Action: None needed.
ORA-33462: (ESDREAD10A) Discarding compiled code for workspace object because object number is not in analytic workspace string.
Cause: The specified object was not in the same analytic workspace it was when the compiled object was compiled
Action: None needed.
ORA-33468: (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object.
Cause: When the compiled code was saved, the specified object was a surrogate of a certain dimension. Now the specified object is a surrogate of a different dimension.
Action: No action needed; program automatically recompiles.
ORA-33557: (MAINTCHK01) You cannot string values of dimension workspace object during a loop over it.
Cause: User tried to insert or delete a value of the specified dimension while some loop over that dimension was active. The loop could be an explicit FOR or ACROSS loop, or a natural expression evaluation or OLAP_TABLE loop. Also, it could be a loop over the dimension itself or over a derived dimension (like a composite or partition template) or dimension alias that includes it. The insert or delete could be explicitly caused by the MAINTAIN command. It is also possible that the user attempted to assign a value to a variable or partition dimensioned by a composite during a loop over that composite using a qualified data reference (QDR), and that the exception was generated by the engine"s attempt to insert a new position in the composite to hold the new value.
Action: Move the dimension maintenance or QDR-based variable assignment outside the dimension loop.
ORA-33558: (LOCKCHECK01) The status or contents of the workspace object dimension cannot be changed while the LOCK_LANGUAGE_DIMS option is set to value.
Cause: A LIMIT or MAINTAIN was attempted on the named language dimension while the boolean option LOCK_LANGUAGE_DIMS was set to YES.
Action: SET LOCK_LANGUAGE_DIMS to NO and retry the MAINTAIN or LIMIT.
ORA-33625: (FRASSIGN02) You cannot use the APPEND keyword with concat dimension workspace object.
Cause: User used the APPEND keyword on a CONCAT target in a FILEREAD, SQL FETCH or SQL SELECT command.
Action: APPENDing a value to one of the CONCATs leaves automatically appends to the CONCAT.
ORA-33883: (MAKEDCL36) You cannot use the string attribute when you define an EXTERNAL partition with an existing target.
Cause: User gave the TEMPORARY keyword in the definition of an external partition whose target variable was previously defined.
Action: Any storage characteristics of the external partition are determined by the target variable. These attributes should be set when the target is defined, not when the external partition is defined.
ORA-33911: (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string.
Cause: User attempted to define an object that requires a certain compatibility setting in an AW that has not been upgraded to that compatibility level.
Action: Make sure that the database is running in the appropriate compatibility mode, and upgrade the AW.
ORA-33918: (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.
Cause: Not all kinds of dimensions can have surrogates. The user attempted to define a surrogate of a prohibited kind of dimension.
Action: Do not attempt to define a surrogate on this dimension.
ORA-33920: (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER.
Cause: The user attempted to define a surrogate without specifying a valid data type.
Action: Specify the data type (ID, NTEXT, TEXT, NUMBER, or INTEGER) in the definition of the surrogate.
ORA-33922: (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension.
Cause: The user attempted to define a surrogate on a dimension that has type DAY, WEEK, MONTH, or YEAR.
Action: Do not attempt to define a surrogate on this dimension.
ORA-33998: (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object.
Cause: The user attempted to include both a dimension and its surrogate in the DIMENSION statement of a model.
Action: Use either the dimension or the surrogate in the DIMENSION statement of the model, but not both.
ORA-34000: (MODCOMP13) You cannot use both workspace object and workspace object as model dimensions, because they are both surrogates of dimension workspace object.
Cause: The user attempted to include two dimension surrogates of the same dimension in the DIMENSION statement of a model.
Action: Use either of the two surrogates in the DIMENSION statement of the model, but not both.
ORA-34001: (MODCOMP14) Concat leaf dimension workspace object already is used in a DIMENSION statement, either explicitly or as a leaf of another concat dimension.
Cause: Either two concat dimensions which share a common leaf dimension, or a concat and one of its leaves where both specified in the DIMENSION statement(s).
Action: Do not specify overlapping concat dimensions, or any leaves of specified concat dimensions.
ORA-34019: (MSCGADD03) workspace object is not a LIST PARTITION TEMPLATE.
Cause: User attempted to MAINTAINT ADD or DELETE a list value from a RANGE or CONCAT partition template.
Action: Partitioning in a RANGE or CONCAT partition template cannot be changed using the MAINTAIN command.
ORA-34021: (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.
Cause: User attempted to MAINTAINT ADD or DELETE a list value from a LIST partition template, but didn"t specify which partition to add to or delete from.
Action: Specify the partition: maintain (template) add to partition (partitionname) (values) or maintain (template) delete from partition (partitionname) (values)
ORA-34059: (MSEXECUT12) You cannot delete non session-only dimension values from unique concat dimension workspace object.
Cause: The user tried to apply MAINTAIN DELETE to a non-SESSION value.
Action: Only use MAINTAIN DELETE to remove SESSION values from a concat dimension.
ORA-34061: (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.
Cause: Only UNIQUE concat dimensions can have custom member values.
Action: Use the CHGDFN command to change the concat dimension to UNIQUE and retry.
ORA-34141: (MXCGPUT00) You cannot use the ASSIGN keyword with DIMENSION workspace object.
Cause: User used the ASSIGN keyword on a DIMENSION target in a FILEREAD, SQL FETCH or SQL SELECT command.
Action: To create a new dimension value in a FILEREAD, SQL FETCH or SQL SELECT command, use the APPEND keyword.
ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.
Cause: The user attempted to assign a value to a dimension surrogate whose data type is INTEGER. INTEGER surrogates, like INTEGER dimensions, cannot have values assigned to them. They can only be referenced by position.
Action: Do not attempt to assign values to an INTEGER surrogate. Values will automatically appear and disappear from the INTEGER surrogate as positions are added to or removed from the underlying dimension.
ORA-34145: (MXCGPUT03) You cannot use the APPEND keyword with SURROGATE workspace object.
Cause: User used the APPEND keyword on a SURROGATE target in a FILEREAD, SQL FETCH or SQL SELECT command.
Action: To assign a value to a SURROGATE in a FILEREAD, SQL FETCH or SQL SELECT command, use the ASSIGN keyword.
ORA-34164: (MXCGVAR01) A dimension used to define a local string variable cannot be located. Execution cannot continue.
Cause: A local relation or valueset has become invalid, most probably because an object used by the currently executing program has been deleted.
Action: This is an internal error that should be referred to Oracle technical support.
ORA-34177: (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instantiate it.
Cause: User attempted to CHGDFN DELETE a partition template, but some partitioned variable had data in the partition specified for deletion.
Action: Drop the partitions that are causing the problem, then retry.
ORA-34179: (MXCHGDCL20) workspace object is not a PARTITION TEMPLATE.
Cause: User specified an object that is not a partition template where a partition template is required.
Action: Supply the name of a partition template.
ORA-34181: (MXCHGDCL21) workspace object is not a partitioned VARIABLE.
Cause: User specified an object that is not a partitioned variable in a place where a partitioned variable is required.
Action: Supply the name of a partitioned variable.
ORA-34183: (MXCHGDCL22) Partition number already exists.
Cause: User attempted to ADD a partition that already existed to a partitioned variable.
Action: None required - the partition already exists.
ORA-34210: (MXCHGDCL18) You cannot change workspace object to a dimension composite because one or more surrogates has been defined for it.
Cause: The user attempted to redefine a conjoint dimension as a composite, but the conjoint has one or more surrogates defined. A dimension that has surrogates cannot be redefined as a composite.
Action: Either delete all surrogates for the dimension, or do not attempt to redefine the dimension as a composite.
ORA-34243: (MXDCL11) You can only use the string keyword when defining a COMPOSITE.
Cause: User supplied the COMPRESSED keyword when defining an object that was not a COMPOSITE.
Action: If the intent is to create a compressed composite, make sure that the object type is COMPOSITE. Otherwise, remove the COMPRESSED keyword from the command string and rerun.
ORA-34260: (MXDCL25) You cannot use number to dimension a string because it is, or involves, a dimension composite. Use the composite"s bases instead.
Cause: The user attempted to use a COMPOSITE in the dimension list of an object that does not allow for such dimensions.
Action: Use the base dimensions of the COMPOSITE in the dimension list.
ORA-34276: (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.
Cause: The user attempted to use NUMBER(Precision) or NUMBER(Precision, Scale) as the datatype in a definition for some object other than a DIMENSION or VARIABLE, such as a FORMULA or PROGRAM. This error can also be produced in cases where a NUMBER data type is not allowed at all.
Action: Use the NUMBER type without specifying a precision or scale. If a NUMBER data type is not allowed at all, this fix will only change the exception message to something more specific.
ORA-34279: (MXDCL37) CONCAT can only be used when defining a DIMENSION.
Cause: The CONCAT keyword was used incorrectly.
Action: Retry the command without the CONCAT keyword.
ORA-34286: (MXDCL53) workspace object cannot be used in this context because it is a string.
Cause: User specified a dimension composite, conjoint, or partition template in a place where that kind of dimension is not allowed. For instance, a relation cannot be dimensioned by a composite, and only a variable can dimensioned by a partition template.
Action: Usually, the offending dimension can be replaced with its bases. For instance, a relation cannot be dimensioned by a a composite of PRODUCT and GEOG, but it can be dimensioned by both PRODUCT and GEOG instead.
ORA-34296: (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the form NUMBER(precision) or NUMBER(precision, scale).
Cause: The user attempted to define a NUMBER dimension without specifying a precision. The proper format for declaring a number dimension is NUMBER(Precision) or NUMBER(Precision, Scale). NUMBER with no precision or scale is not allowed.
Action: Use NUMBER(Precision) or NUMBER(Precision, Scale) to specify the datatype of a NUMBER dimension.
ORA-34342: (MXDSS01) IMPORTANT: Analytic workspace string is read-only. Therefore, you will not be able to use the UPDATE command to save changes to it.
Cause: This is an informational message that reminds you that you may not save changes to the specified analytic workspace.
Action: None, unless it was desired to save changes to the analytic workspace. In that case, detach and reattach the analytic workspace read-write.
ORA-34344: (MXDSS03) Analytic workspace string is not attached.
Cause: The command attempted to operate on an analytic workspace that is not currently attached, or the name of the analytic workspace is misspelled.
Action: Attach the analytic workspace or correct the spelling.
ORA-34346: (MXDSS04) The string analytic workspace cannot be detached.
Cause: The specified analytic workspace is an internal workspace and may not be detached by the user.
Action: Specify a different analytic workspace to detach.
ORA-34348: (MXDSS05) string is used only for internal purposes and cannot be accessed as an analytic workspace.
Cause: The command attempted to operate on an internal analytic workspace used by the system.
Action: Specify a different analytic workspace.
ORA-34350: (MXDSS06) string is an open analytic workspace.
Cause: The specified analytic workspace is currently in use.
Action: The desired action requires an analytic workspace that is not currently in use.
ORA-34357: (MXDSS10) string is not an alias of analytic workspace string.
Cause: User attempted to use AW UNALIAS on a non-existent alias.
Action: Make sure that the command specified the correct analytic workspace and alias. The alias must have been assigned (using AW ALIAS) during the current session and must not have been removed by a previous AW UNALIAS or AW DETACH command.
ORA-34358: (MXDSS14) number other users reading
Cause: Used for AW LIST output formatting when %d > 1
Action: None
ORA-34359: (MXDSS11) string appears twice in the alias list.
Cause: User included the same name twice in the alias list of an AW ALIAS or AW UNALIAS command.
Action: Remove the duplicate name and try again.
ORA-34360: (MXDSS15) number other users writing
Cause: Used for AW LIST output formatting when %d > 1
Action: None
ORA-34361: (MXDSS12) number other user reading
Cause: Used for AW LIST output formatting when %d == 1
Action: None
ORA-34363: (MXDSS13) number other user writing
Cause: Used for AW LIST output formatting when %d == 1
Action: None
ORA-34481: (MXMAINT07) You cannot string values of PARTITION TEMPLATE workspace object.
Cause: User attempted to use the MAINTAIN command with some keyword other than ADD or DELETE on a partition template.
Action: It is not possible to MAINTAIN a partition template, except to add or delete values of a partition list.
ORA-34487: (MXMAINT08) You cannot string values of non-unique concat dimension workspace object.
Cause: The specified MAINTAIN operation can only be applied to UNQUE concats.
Action: Use the CHGDFN command to change the concat dimension to UNIQUE and retry.
ORA-34489: (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.
Cause: The user attempted to use the MAINTAIN command on a dimension surrogate. The MAINTAIN command can only be used with real dimensions, not surrogates.
Action: Use the MAINTAIN command to modify the underlying dimension of the surrogate instead.
ORA-34514: (MXOPERR) You cannot string string data in the expression that begins with "string".
Cause: The user attempted an invalid operation.
Action: none
ORA-34656: (MXSQL24) Additional WHERE clause conditions with CURRENT OF <cursor name> syntax
Cause: A SQL UPDATE or DELETE statement tried to use the CURRENT of <cursor name> syntax with a WHERE clause containing multiple conditions.
Action: When using the CURRENT OF <cursor name> syntax make sure it is the only condition in the WHERE clause.
ORA-34719: (NLSCHARSET03) Character data loss in NTEXT/TEXT conversion
Cause: When character set conversion happens between TEXT and NTEXT either implicitly or explicitly, some characters are lost due to no mapping characters in the destination character set.
Action: Make sure all the characters can be mapped to destination character set or set NLS_NCHAR_CONV_EXCP to be FALSE. Note: This message is the OLAP equivalent of ORA-12713.
ORA-34722: (NLSCHARSET05) CAUTION: Character data loss in character set conversion from string to string
Cause: Some operation required a string to be converted into a different character set, but the string contained characters that didn"t exist in the new character set.
Action: Choose different character sets.
ORA-34726: (NLSCHARSET06) CAUTION: String truncated during character set conversion from string to string
Cause: Some operation required a string to be converted into a different character set. The string required more bytes in the new encoding, and exceeded some byte limit on its allowable length, causing some characters to be removed from the end of the string.
Action: If the byte limit is due to using the ID datatype, consider using the CHAR datatype instead. If the byte limit is due to the limit of 4000 bytes per line of CHAR data, break the long line up into multiple lines.
ORA-34802: (OCI11) OLAP OCI operation caused ROLLBACK past an UPDATE of an attached analytic workspace. Current operation canceled.
Cause: ROLLBACK past the UPDATE of one of the attached Analytic Workspaces was called. The current operation is aborted, and the Analytic Workspace detached.
Action: Change the called SQL procedure to avoid the ROLLBACK
ORA-34840: (OPCREATE01) The string option must be declared with datatype string.
Cause: An attempt was made to declare the option with the wrong datatype.
Action: Declare the option with the correct datatype.
ORA-34841: (OPCREATE02) The string option must be declared with the READONLY attribute.
Cause: An attempt was made to declare the option without the READONLY attribute.
Action: Declare the option READONLY.
ORA-34871: (PERMIT06) Session-only value "value" of workspace object has been deleted because a PERMIT change has revealed a duplicate value.
Cause: Execution of a PERMIT command revealed a permanent dimension or surrogate value having the same name as the SESSION value.
Action: If the SESSION value is still needed, add it with a different name.
ORA-34896: (PPMONTHS00) At least 12 month names must be given. Only number were provided.
Cause: There must be at least one name for each month. Not enough names were provided.
Action: Provide at least 12 names.
ORA-34897: (PPMONTHS01) Blank lines are not allowed in the MONTHNAMES option.
Cause: There is at least one blank line in the string populating the MONTHNAMES option. We do not allow blank month names.
Action: Remove the blank line(s) from the string.
ORA-34900: (PPWKDAYS00) At least 7 day names must be given. Only number were provided.
Cause: There must be at least one name for each day. Not enough names were provided.
Action: Make sure there are at least 7 names in the string.
ORA-34901: (PPWKDAYS01) Blank lines are not allowed in the DAYNAMES option.
Cause: There is at least one blank line in the string populating the DAYNAMES option. We do not allow blank day names.
Action: Remove the blank line(s) from the string.
ORA-35016: (QFCHECK00) The analytic workspace and EIF file definitions of workspace object have a mismatched type.
Cause: Importing from an EIF file or LOB into an existing Analytic Workspace object failed because the definition of the existing object was too different from the definition of the object in the EIF file or LOB.
Action: Import the object into an Analytic Workspace that does not already contain an object with the same name.
ORA-35017: (QFCHECK06) The Analytic Workspace and EIF file definitions of workspace object have different partitioning methods.
Cause: Importing from an EIF file or LOB into an existing Analytic Workspace object failed because the definition of the existing object was too different from the definition of the object in the EIF file or LOB.
Action: Import the object into an Analytic Workspace that does not already contain an object with the same name.
ORA-35018: (QFCHECK01) The analytic workspace and EIF file definitions of workspace object have a mismatched data type.
Cause: Importing from an EIF file or LOB into an existing Analytic Workspace object failed because the definition of the existing object was too different from the definition of the object in the EIF file or LOB.
Action: Import the object into an Analytic Workspace that does not already contain an object with the same name.
ORA-35019: (QFCHECK07) The Analytic Workspace and EIF file definitions of workspace object have different partition dimensions.
Cause: Importing from an EIF file or LOB into an existing Analytic Workspace object failed because the definition of the existing object was too different from the definition of the object in the EIF file or LOB.
Action: Import the object into an Analytic Workspace that does not already contain an object with the same name.
ORA-35020: (QFCHECK02) The analytic workspace and EIF file definitions of workspace object have mismatched dimensioning.
Cause: Importing from an EIF file or LOB into an existing Analytic Workspace object failed because the definition of the existing object was too different from the definition of the object in the EIF file or LOB.
Action: Import the object into an Analytic Workspace that does not already contain an object with the same name.
ORA-35021: (QFCHECK08) The EIF file definition of workspace object has some partitions that are not present in the existing Analytic Workspace object.
Cause: Importing from an EIF file or LOB into an existing Analytic Workspace object failed because the definition of the existing object was too different from the definition of the object in the EIF file or LOB.
Action: Import the object into an Analytic Workspace that does not already contain an object with the same name.
ORA-35022: (QFCHECK03) The analytic workspace and EIF file definitions of workspace object have a mismatched relation.
Cause: Importing from an EIF file or LOB into an existing Analytic Workspace object failed because the definition of the existing object was too different from the definition of the object in the EIF file or LOB.
Action: Import the object into an Analytic Workspace that does not already contain an object with the same name.
ORA-35023: (QFCHECK09) The analytic workspace and EIF file definitions of workspace object have incompatible partition definitions.
Cause: Importing from an EIF file or LOB into an existing Analytic Workspace object failed because the definition of the existing object was too different from the definition of the object in the EIF file or LOB.
Action: Import the object into an Analytic Workspace that does not already contain an object with the same name.
ORA-35024: (QFCHECK04) The analytic workspace and EIF file definitions of workspace object have mismatched time dimension attributes.
Cause: Importing from an EIF file or LOB into an existing Analytic Workspace object failed because the definition of the existing object was too different from the definition of the object in the EIF file or LOB.
Action: Import the object into an Analytic Workspace that does not already contain an object with the same name.
ORA-35026: (QFCHECK05) The analytic workspace and EIF file definitions of workspace object have a mismatched ALIASOF dimension.
Cause: Importing from an EIF file or LOB into an existing Analytic Workspace object failed because the definition of the existing object was too different from the definition of the object in the EIF f