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

31 QSM-00501 to QSM-03120

QSM-00501: unable to initialize Summary Advisor environment
Cause: The Summary Advisor external procedure initialization process failed.
Action: Contact Oracle Worldwide Support.
QSM-00502: OCI error
Cause: A OCI callback routine reported an error
Action: Contact Oracle Worldwide Support.
QSM-00503: out of memory
Cause: Summary Advisor failed to allocate the necessary memory.
Action: Contact Oracle Worldwide Support.
QSM-00504: internal error
Cause: An internal error occurred.
Action: Contact Oracle Worldwide Support.
QSM-00505: syntax error
Cause: A syntax error occurred.
Action: Correct syntax error if possible or contact Oracle Worldwide Support.
QSM-00506: no fact-tables could be found
Cause: The fact-filter is not specified, and there are no fact-tables in the warehouse. A fact-table is a table having foreign-key constraints to one or more of the dimension-tables in the data warehouse.
Action: Check the fact-filter is correctly specified; check that appropriate constraints exist; and the user has privileges to access the tables
QSM-00507: no dimensions could be found
Cause: The database does not have any dimensions
Action: Create the dimensions in your warehouse
QSM-00508: statistics missing on tables/columns
Cause: The system metadata does not contain statistics on one or more tables or columns. The Advisor needs cardinalities of all fact-tables, and of the level-keys of all dimensions in the data warehouse.
Action: Run ANALYZE on the tables and summaries in the warehouse to collect statistics
QSM-00509: invalid parameter
Cause: The indicated parameter has an invalid value
Action: Supply a value in the proper range
QSM-00510: statistics missing on materialized views
Cause: The system metadata does not contain statistics on one or more materialized views. The Advisor needs cardinalities of all materialized views in the data warehouse.
Action: Run ANALYZE on the tables and materialized views in the warehouse to collect statistics.
QSM-00511: invalid fact-tables specified in fact-filter
Cause: The tables specified in the fact-filter are not valid fact-tables. A fact-table must have foreign-key constraints to one or more of the dimension-tables in the data warehouse.
Action: Check the fact-filter is correctly specified; check that appropriate constraints exist; and the user has privileges to access the tables
QSM-00512: invalid summaries specified in the retention-list
Cause: The summaries specified in the retention-list are not valid.
Action: Check the spelling of the summary-names; check that they are valid; and the user has privileges to access them.
QSM-00513: one or more of the workload tables is missing
Cause: One or both of the workload tables are missing. The two workload tables which should be present in the user"s schema are V_192216243_F_5_E_14_8_1 and V_192216243_F_5_E_15_8_1; the former is mapped to WORK$_IDEAL_MVIEW and the latter to WORK$_MVIEW_USAGE. The workload tables are created by the Oracle Trace Formatter when the data-collection-file (oraclesm.dat) is formatted by the user.
Action: Check whether the Formatter succeeded in formatting the data collection. Sometimes the V_192216243_F_5_E_14_8_1 (i.e WORK$_IDEAL_MVIEW) may not be created whereas the other table is created. The most likely cause of this is the init.ora parameters needed to invoke mview-rewrite are not enabled. Check your documentation for all the init.ora parameters which need to be set for mview-rewrite to occur. Another possibility is no GROUP BY queries were issued during the time the data was collected, in which case, run the Trace collection for a longer time to get a representative sampling of the queries issued in the data warehouse.
QSM-00514: the size of must-retain summaries exceeds specified space limit
Cause: The specified space limit is greater than the size of must-retain summaries.
Action: Reduce the number of must-retain summaries or increase the space limit
QSM-00515: operation cancelled by user
Cause: The operation has been cancelled by the user
Action: None
QSM-00516: illegal status detected for run
Cause: The run has encountered an illegal value in the status field of the mview$_adv_log table. This could be internal error or an application error.
Action: Contact Oracle Worldwide Support.
QSM-00517: Summary Advisor requires a COMPATIBLE setting of 8.1.0.0 or greater
Cause: The current database has a compatibility setting that is earlier than the supported server version.
Action: Adjust the instance parameter COMPATIBLE to 8.1.0.0 or greater.
QSM-00518: Java is not enabled. Please execute INITJVM.SQL and INITQSMA.SQL
Cause: The current database has has not be created or upgraded to support Java stored procedures. Summary Advisor requires Java stored procedures.
Action: Log into the database with SYSDBA privileges. Execute the INITJVM.SQL script which is found in the ORACLE home directory under JAVAVM. Next, execute the INITQSMA.SQL script found in the ADMIN directory under the ORACLE home.
QSM-00519: Summary Advisor is not installed. Please execute INITQSMA.SQL.
Cause: The current database has has not be created or upgraded to support Summary Advisor. Summary Advisor requires several Java stored procedures.
Action: Log into the database with SYSDBA privileges. Execute the INITQSMA.SQL script found in the ADMIN directory under the ORACLE home. **** **** Messages 520-700 are in the 9i Summary Advisor Java modules 701-708 are Hypothetical Workload generator journal messages
QSM-00710: data access error in module string
Cause: SQL Access Advisor detected a severe error while accessing the advisor repository.
Action: See the accompanying error message for approprate actions.
QSM-00750: the specified value string for parameter string is invalid or contains an invalid item
Cause: The user attempted to set a task parameter using invalid data.
Action: Adjust the data value and retry the operation.
QSM-00751: the file string could not be opened for write access
Cause: Access Advisor could not create the script or report due to a file system error.
Action: Verify the location for file write access and retry the operation.
QSM-00752: the parameter string contains an invalid combination of options string
Cause: The user specified correct option keywords, but entered a combination that is not supported within Access Advisor.
Action: Validate the correct option usage and retry the operation.
QSM-00753: the specified value string is out of the acceptable range of string to string for parameter string
Cause: The user attempted to set a task parameter using invalid data.
Action: Adjust the data value and retry the operation.
QSM-00754: task string does not reference a valid workload and therefore cannot be executed
Cause: The user attempted to execute a advisor task that requires a workload.
Action: Specify a workload for the task and retry the operation.
QSM-00755: a set of workload statements already exists for workload string
Cause: The user attempted to save workload data into an existing workload that already contains data without specifying APPEND or REPLACE.
Action: Validate the import mode retry the operation.
QSM-00756: the specified workload string is being used by one or more advisor tasks
Cause: The user attempted to modify or delete a workload that is currently being used by another task.
Action: Remove the workload reference from the advisor task and retry the operation.
QSM-00757: the specified workload string is not referenced by task string
Cause: The user attempted to delete invalid workload reference from the task.
Action: Validate the workload reference and retry the operation.
QSM-00758: the specified parameter string is not valid for workload string
Cause: The user attempted to access a workload parameter that is does not exist for the specified workload. The parameter may be misspelled or the user selected a parameter that is not supported by the particular advisor.
Action: Validate the parameter name and retry the operation.
QSM-00759: the user string does not exist for the specified workload statement
Cause: The user attempted to add a new SQL statement with an invalid username.
Action: Adjust the name and retry the operation.
QSM-00760: the import mode string is invalid for the current operation
Cause: The user attempted to store data in the repository with an invalid import mode.
Action: Use one of the following valid values: NEW, APPEND, or REPLACE.
QSM-00761: the priority string is invalid for the current operation
Cause: The user attempted to store data in the repository with an invalid priority.
Action: Use one of the following valid values: 1, 2, 3.
QSM-00762: the specified Summary Advisor workload string does not exist
Cause: The user attempted to import an advisor workload from an invalid or non-existent Summary Advisor workload.
Action: Validate the Summary Advisor workload identifier and retry the operation.
QSM-00763: the owner string was not found while validating user-defined workload string.string
Cause: The user attempted to import an advisor workload from a user who may not access to the table.
Action: Validate the location of the user-defined workload.
QSM-00764: the column string was not found in the user-defined workload table string.string
Cause: The user attempted to import an advisor workload from a user table that does not contain the required column.
Action: Validate the user-defined workload table and retry the operation.
QSM-00765: cannot validate user-defined workload because table string.string is invalid.
Cause: The user attempted to import an advisor workload from a table that is not accessible.
Action: Validate the location of the user-defined workload.
QSM-00766: a SQL statement is required for the current workload operation
Cause: The user attempted to create an entry in a workload collection without specifying a SQL statement.
Action: Validate the SQL statement and retry the operation.
QSM-00767: a SQL cache is not available to user string
Cause: The user attempted to collect a workload from the SQL without having authorization.
Action: Validate the user account and retry the operation.
QSM-00768: the search condition is invalid for the requested operation
Cause: The user provided a invalid SEARCH argument to an Access Advisor workload operation. A search condition must be a valid SQL search condition using only the column names specified in the procedure documentation.
Action: Correct the search condition and retry the operation.
QSM-00769: the SQL statement string was not found for workload string
Cause: The user attempted to access a SQL statement that does not exist in the workload.
Action: Validate the SQL statement identifier and retry the operation.
QSM-00770: the specified workload string is already referenced by task string
Cause: The user attempted to add a workload reference to a task when the task already contains the reference.
Action: Validate the workload reference and retry the operation.
QSM-00771: the specified SQL statement cannot be stored in the workload because it has no valid table references
Cause: The user attempted to add a workload statement that contains table references that are either system-specified or user-specified invalid tables.
Action: Validate the workload statement and retry the operation.
QSM-00772: the specified SQL statement cannot be stored in the workload due to a statement error
Cause: The user attempted to add a workload statement that contains invalid SQL syntax or an invalid column reference.
Action: Validate the workload statement and retry the operation.
QSM-00773: the parameter string contains the invalid string name string
Cause: The task or workload parameter contains a name that is either too long or does not exist in the database.
Action: Validate the parameter value and retry the operation.
QSM-00774: there are no SQL statements to process for task string
Cause: While executing, the specified task found no valid SQL statements to analyze. Possible causes are: an empty workload, table filtering, or username filtering.
Action: Validate the workload and the appropriate task parameters and retry the operation.
QSM-00775: the specified SQL statement cannot be stored in the workload due to invalid table references
Cause: The user attempted to add a workload statement that contains one or more invalid identifier for the parsing user.
Action: Validate the workload statement and retry the operation.
QSM-00776: the user-defined workload string is missing the following column: string
Cause: The user attempted to import a workload from an external table; however, the table does not contain all of the required columns.
Action: Adjust the target workload table and retry the operation.
QSM-00777: the specified directive string is unsupported at this time
Cause: The user attempted to create a directive that is not currently supported.
Action: Check the advisor documentation for valid directives.
QSM-00778: the specified output filename string is invalid or cannot be accessed
Cause: The user attempted to create a report or script in a file that cannot be written or created.
Action: Adjust the file name or directory and retry the operation.
QSM-00779: the specified directive conflicts with the existing directive string
Cause: The user attempted to add a directive that cannot operate with an existing directive.
Action: Check the advisor documentation for valid directives.
QSM-00780: the task string could not be executed because the workload string is being modified
Cause: While attempting to execute a task, Access Advisor checks for exclusive access to all of the referenced workloads. If any cannot be reserved, then the execution fails.
Action: Wait until the referenced workloads are free for exclusive access retry the operation.
QSM-00781: the specified value string is invalid for parameter string. Valid keywords are string
Cause: The user attempted to set a task parameter using invalid data.
Action: Adjust the data value and retry the operation
QSM-00782: the specified value string is an invalid date format for parameter string
Cause: The user attempted to set a task parameter using invalid date formatting directives.
Action: See the Oracle documentation for valid date-formatting and retry the operation.
QSM-00783: the specified value string contains an invalid date for parameter string
Cause: The user attempted to set a task parameter using invalid date formatting.
Action: A date literal must be in the form DD/MM/YYYY HH24:MI:SS.
QSM-00784: the string string referenced in the list string is invalid for parameter string
Cause: The user attempted to set a task parameter using an invalid username or table specification.
Action: Validate the object name and retry the operation.
QSM-00785: the directive string is not supported for task string at this time
Cause: The user attempted to add an invalid directive to the current task.
Action: Validate the directive and retry the operation.
QSM-00786: the name string is invalid for directive string
Cause: The user attempted to add a directive that contains an empty or invalid object name.
Action: Correct the name and retry the operation.
QSM-00787: the tablespace string is invalid for directive string
Cause: The user attempted to add a directive that contains an empty or invalid tablespace name.
Action: Correct the name and retry the operation.
QSM-00788: the table string is invalid for directive string
Cause: The user attempted to add a directive that contains an empty or invalid table specification.
Action: Correct the name and retry the operation.
QSM-00789: the string string is invalid for directive string
Cause: The user attempted to add a directive that contains an empty or invalid attribute.
Action: Correct the value and retry the operation.
QSM-00790: the workload string cannot be modified or changed because it is being used by task string
Cause: The user attempted to change or delete a workload that is referenced by an active task.
Action: Remove references to a workload from any tasks that reference that workload, unless the task is in its initial task state.
QSM-00791: the specified SQL statement cannot be stored in the workload because is contains unsupported statement type
Cause: The user attempted to add a workload statement that contains an invalid statement type. Supported statement types are INSERT, DELETE, UPDATE, SELECT and MERGE.
Action: Validate the workload statement and retry the operation.
QSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables have missing statistics
Cause: The user attempted to add a workload statement that contains a table without statistics. Access Advisor requires all referenced tables to have valid statistics.
Action: Validate the workload statement and retry the operation.
QSM-00793: the specified SQL Tuning Set string does not exist
Cause: The user specified a SQL Tuning Set that has not been defined in the SQL Tuning Set repository.
Action: Correct the SQL Tuning Set name and retry the operation.
QSM-00794: the statement can not be stored due to a violation of the string filter
Cause: The user attempted to manually add a workload statement that failed a filter test. Manual statements must meet the same filtering guidelines as imported statements.
Action: Adjust the attributes or the filter and retry the operation.
QSM-00795: the SQL Tuning Set repository has not been implemented
Cause: The user attempted to collect a workload from a SQL Tuning Set repository that has not yet been implemented or enabled.
Action: Validate the existence of the repository and retry the operation.
QSM-00796: the specified SQL statement cannot be stored in the workload because table string does not have valid statistics
Cause: The user attempted to add a workload statement that references a table with missing statistics.
Action: Gather statistics for the referenced table and retry the operation.
QSM-00797: the specified workload string does not exist for the current user
Cause: The user attempted to reference an Access Advisor workload using a name that does not exist in the Advisor repository.
Action: Adjust the name and retry the operation.
QSM-00798: the specified workload string already exists
Cause: The user attempted to create the specified workload using a name that already exists in the Advisor repository. Task names must be unique to the database user.
Action: Adjust the name and retry the operation.
QSM-00799: the user-defined workload table string cannot be found
Cause: The user has attempted to import a workload from an external table that does not exist or cannot be accessed.
Action: Adjust the target workload table and retry the operation.
QSM-00800: the specified workload name string is invalid
Cause: The user has specified an invalid workload name.
Action: Adjust the target workload name and retry the operation.
QSM-00801: the specified username string is invalid
Cause: The user has specified an invalid username.
Action: Adjust the target username and retry the operation.
QSM-00802: An error occurred while implementing action string (string) string.
Cause: While performing IMPLEMENT_TASK, a specific action operation failed.
Action: Make the necessary adjustments as specified in the secondary message and retry the operation.
QSM-00803: The STORAGE_CHANGE parameter value string cannot be zero or negative for partial workloads.
Cause: While performing EXECUTE_TASK, the user specified a STORAGE_CHANGE value that is incompatible with the type of workload data.
Action: Set a positive STORAGE_CHANGE value.
QSM-00804: not enough space for mandatory access structures
Cause: While performing EXECUTE_TASK, the user specified a STORAGE_CHANGE value that leaves no space for mandatory access structures, such as primary key indexes.
Action: Set a greater STROAGE_CHANGE value.
QSM-00805: the specified recommendation string value string is invalid
Cause: The user has specified an invalid value when attempting to change a recommendation attribute.
Action: Adjust the target attribute value and retry the operation.
QSM-00806: The string parameter value must be specified when STORAGE_MODE is set to TOTAL
Cause: While performing EXECUTE_TASK, the user specified a STORAGE_MODE of TOTAL, but failed to set the DEF_MVIEW_OWNER and DEF_INDEX_OWNER to valid owner names.
Action: Set the specified owner to a valid name
QSM-00999: Advisor feature is not currently implemented
Cause: The user attempted to execute an unsupported advisor operation.
Action: Verify the availability of the operation.
QSM-01001: query rewrite not enabled
Cause: When query rewrite is disabled, no query rewrite will take place.
Action: Enable query rewrite with ALTER SESSION SET QUERY_REWRITE ENABLE command.
QSM-01002: no query rewrite when OPTIMIZER_MODE is rule based
Cause: Query rewrite did not occur because the OPTIMIZER_MODE was set to RULE.
Action: Change the optimizer mode using the OPTIMIZER_MODE parameter.
QSM-01003: no query rewrite on DDL queries
Cause: If query contains any data definition operations, no query rewrite will take place.
Action: none.
QSM-01004: no query rewrite before view merging
Cause: Internal session parameter _QUERY_REWRITE_2 is set to FALSE
Action: Change session parameter with ALTER SESSION command.
QSM-01005: no query rewrite when query has slave SQL
Cause: Current prcess is a kxfx slave
Action: none
QSM-01006: query rewrite disabled for this query block
Cause: During query rewrite, certain view query blocks cannot be rewritten.
Action: none
QSM-01007: query has NOREWRITE hint
Cause: When query contains a NOREWRITE hint, no query rewrite will take place for that query block.
Action: Remove the NOREWRITE hint from the query
QSM-01008: no query rewrite for update queries
Cause: If a query or part of it has any DML update operations, no query rewrite will take place.
Action: none
QSM-01009: query rewritten with materialized view, string, using text match algorithm
Cause: The query was rewritten using a materialized view, because query text matched the definition of the materialized view
Action: none
QSM-01010: table(s) in the query not found in materialized view, string
Cause: If the materialized view does not reference the base tables found in the query, it cannot be used for rewrite
Action: none
QSM-01011: when heuristic rewrite not set, rewrite hint required
Cause: When using a stored outline, a rewrite hint is required for query rewrite
Action: none
QSM-01012: SAMPLE clause present in FROM
Cause: If a query contains a SAMPLE clause, query rewrite will not take place
Action: none
QSM-01013: nested aggregates or CONNECT BY/START WITH clause present
Cause: If the query contains nested aggregates, CONNECT BY clause, or START WITH clause, query rewrite will not take place
Action: none
QSM-01014: top level operator in WHERE clause of the query is an OR
Cause: If the top-level operator in the WHERE clause is an OR and there is more than one table in the FROM list, then query rewrite will not take place.
Action: none
QSM-01015: GROUP BY clause has non-columns
Cause: No query rewrite, if there is no valid column in the GROUP BY clause.
Action: none
QSM-01016: Query rewrite does not support, aggregate, string
Cause: No query rewrite, if the query contains any DISTINCT aggregates other than COUNT, MIN or MAX.
Action: none
QSM-01017: aggregate argument cannot be converted to canonical form
Cause: Argument of each aggregrate in the query needs to be convertible into a canonical form for query rewrite.
Action: none
QSM-01018: single table materialized join view rewrite not required
Cause: Materialized join view is more expensive for rewrite than using the base table
Action: none.
QSM-01019: no suitable materialized view found to rewrite this query
Cause: There doesn"t exist any materialized view in the dataware house that can be used to rewrite this query.
Action: Consider creating a new materialized view.
QSM-01020: materialized view, string, is ineligible
Cause: Materialized view is probably disabled or stale.
Action: Consider enabling the materialized view for rewrite or refreshing it.
QSM-01021: materialized view, string, not found in the hint list
Cause: There is a rewrite hint list specified in the query, but this materialized view is not among the hinted ones.
Action: Include this materialized view in the rewrite hint list.
QSM-01022: a more optimal materialized view than string was used to rewrite
Cause: Query Rewrite always chooses the most optimal materialized view based on certain parameters, such as cardinality of the materialized view, number of joins etc. The materialized view specified was found to be less optimal.
Action: To force using a materialized view, consider using a rewrite hint.
QSM-01023: materialized view, string, has GRANT errors
Cause: Materialized view probably has some metadata errors.
Action: Consider recreating it.
QSM-01024: materialized view, string, has unknown compile errors
Cause: Materialized view probably has some metadata errors.
Action: Consider recreating it.
QSM-01025: materialized view, string, not found
Cause: The specified materialized view is not found in the database.
Action: Check the spelling or create a new materialized view
QSM-01026: query rewrite is disabled for, string
Cause: Query rewrite could not use this materialized view, because query rewrite was not enabled for it.
Action: Enable query rewrite for the materialized view with ALTER MATERIALIZED VIEW "mv" ENABLE QUERY REWRITE command, where "mv" is the name of the materializev view.
QSM-01027: materialized view, string, is unusable
Cause: Materialized view probably has some metadata errors.
Action: Consider recreating it.
QSM-01028: materialized view, string, is currently being refreshed
Cause: Materialized view cannot be used for query rewrite while it is being refreshed
Action: Rerun the query, after the refresh operation is completed.
QSM-01029: materialized view, string, is stale in ENFORCED integrity mode
Cause: A stale materialized view cannot be used for query rewrite when the query rewrite integrity mode is set to ENFORCED.
Action: Refresh the materialized view or alter the rewrite integrity mode with ALTER SESSION QUERY_REWRITE_INTEGRITY = STALE TOLERATED command.
QSM-01030: materialized view, string, has PL/SQL functions in ENFORCED integrity mode
Cause: A materialized view with PL/SQL functions in its definition cannot be used for query rewrite when query rewrite integrity is set to ENFORCED.
Action: Consider running the query in STALE TOLERATED mode.
QSM-01031: materialized view, string, is stale in TRUSTED integrity mode
Cause: A stale materialized view cannot be used for query rewrite when the query rewrite integrity mode is set to TRUSTED.
Action: Refresh the materialized view or alter the rewrite integrity mode with ALTER SESSION QUERY_REWRITE_INTEGRITY = STALE TOLERATED command.
QSM-01032: materialized view, string, not found
Cause: There was no associated metadata for the materialized view.
Action: Check the spelling and re-run the query.
QSM-01033: query rewritten with materialized view, string
Cause: The specified materialized view was used to rewrite the given query.
Action: none
QSM-01034: materialized view, string, needs a dimension level to join table, string
Cause: One or more hierarchical relationship(s) in the table(s) could not be established.
Action: Consider adding a level in the dimension to provide the missing intra- table relationships.
QSM-01035: a row level security policy exists on this table
Cause: Any row level security policy that may exist on a base-table prevents exact text match query rewrite.
Action: none.
QSM-01036: unmatched column, string, present in query after view merging
Cause: Clearing the columns after view merging failed due to some reasons - bug??
Action: none
QSM-01037: Query Rewrite failed to allocate the necessary query join graph
Cause: Join graph allocation and initialization failed, possibly due to one or more undetermined operand(s) in the query expression.
Action: none
QSM-01038: logical operator(s) could not be processed
Cause: One or more logical operator(s) in the query predicates could not be processed, possibly due to invalid operator(s).
Action: none
QSM-01039: selection present on right hand side of an outer join
Cause: Query cannot be rewritten if any predicate contains a selection on the right hand side of an outer join.
Action: none
QSM-01040: match between the materialized view (string) and query join graphs failed
Cause: Query rewrite will not take place if the joins in the query and the materialized view do not have any match.
Action: none
QSM-01041: materialized view, string, does not match with a measure in the query
Cause: If a measure (such as SUM, AVERAGE) in the query cannot be matched or computed from the materialized view, it will not be used for rewrite.
Action: none
QSM-01042: anchor and matching join arc check failed for string
Cause: If there is a lossy join in the materialized view that doesn"t exist in the query, query rewrite will not take place.
Action: none
QSM-01043: join back attempted on a table to the RHS of a semi or anti join for string
Cause: Query Rewrite will not occur if a join back is required to a table that appears to the right hand side of a semi or anti-join.
Action: none
QSM-01044: join back attempted on a view for string
Cause: Query Rewrite will not occur if a join back to a table is required to find any missing columns.
Action: none
QSM-01046: complex join back on correlated columns not allowed (string)
Cause: Query Rewrite will not occur if a join back is required on a column that is referenced by a sub-query.
Action: none
QSM-01047: complex join back on non-MAV rewrite not allowed (string)
Cause: Query Rewrite can occur by means of a complex join back only during a MAV rewrite.
Action: none
QSM-01048: join back level(s) not present (string)
Cause: Query Rewrite requires joining back to a level of a dimension to find a missing information.
Action: Consider creating a dimension.
QSM-01049: semi-join check failed for materialized view, string
Cause: If there is a semi join in the query, then Query Rewrite will create (select distinct <pk-list>, <ref-col> from mjv) where <pk-list> is the list of rowids/pk of all mjv tables that don"t correspond to a right side of a semi-join and <ref-col> are their columns. Query Rewrite will not occur if a join from the materialized view cannot match the semi-join from the query.
Action: none
QSM-01050: roll-up check failed for materialized view, string
Cause: A column in the query cannot be computed from the materialized view.
Action: Consider creating a dimension to supply the missing information
QSM-01051: no support for rollup when a window function is present on the column
Cause: No query rewrite if a window function is present on a column that requires a roll-up to compute a measure.
Action: none
QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode
Cause: A join present in the materialized view requires validated primary/foreign key constraints in ENFORCED query rewrite integrity mode.
Action: Validate the constraint or change the integrity mode with ALTER SESSION SET QUERY_REWRITE_INTEGRITY = STALE_TOLERATED command.
QSM-01053: NORELY referential integrity constraint on table, string, in TRUSTED/STALE TOLERATED integrity mode
Cause: A join present in the materialized view requires RELY mode to be set on the primary/foreign key constraints.
Action: Set the RELY mode with ALTER TABLE <table> MODIFY CONSTRAINT <constraint> RELY command. Alternatively validate the constraint with ALTER TABLE <table> VALIDATE CONSTRAINT <constraint>.
QSM-01054: no join match between query and summary, string
Cause: There are no common joins between the query and the the materialized view
Action: none
QSM-01055: Query Rewrite failed to allocate the necessary materialized view join graph
Cause: Join graph allocation and initialization failed, possibly due to one or more undetermined operand(s).
Action: none
QSM-01056: no query rewrite for this DDL expression
Cause: Some SELECT statements which are part of a DDL expression may be eligible for rewrite. These include CREATE AS SELECT and CREATE OUTLINE statements. The given query expression is a DDL expression, which doesn"t fall in this category.
Action: none
QSM-01057: no query rewrite for this DML expression
Cause: Current DML is being done using an updatable view, so it is not eligible for rewrite.
Action: none
QSM-01058: MV, string, does not have column, string, for a joinback
Cause: A GROUP BY column in the query is not present in the GROUP BY clause of of the materialized view. This usually requires a join back to a third table.
Action: none
QSM-01059: HAVING clause in the query block is malformed
Cause: An illegal HAVING clause has been specified in the query.
Action: Correct the query syntax and run the query again.
QSM-01060: illegal subquery in the HAVING clause
Cause: When a HAVING clause has a subquery, then any references to the tables in the outer query should only reference the tables in the GROUP BY clause.
Action: Correct error in the syntax and rerun the query.
QSM-01061: illegal query expression
Cause: An illegal query was specified. Specifically one of the following criteria was not satisfied: (a) All (non-constant, non-aggregate) SELECT expressions in the query should be made up of group expressions. (b) All column references in the HAVING clause should come from the GROUP BY expressions. (c) If there is an ORDER BY clause, then all column references should come from the GROUP BY or SELECT clause, depending on whether the query selects DISTINCT.
Action: Correct error in the syntax and rerun the query.
QSM-01062: query has one or more manual partition(s)
Cause: Query rewrite is not possible if query has any manual partitions.
Action: none
QSM-01063: query has a dictionary table or view
Cause: Query rewrite is not allowed if query references any dictionary tables/views.
Action: none
QSM-01064: query has a fixed table or view
Cause: Query rewrite is not allowed if query references any fixed tables/views
Action: none
QSM-01065: materialized view, string, cannot compute measure, string, in the query
Cause: If the materialized view cannot compute a measure in the query using the measures in its definition, then query rewrite will not occur.
Action: none
QSM-01066: materialized view, string, does not have the column, string, from query
Cause: Query rewrite will not occur, if the materialized view cannot provide all the columns that the query has
Action: none
QSM-01067: materialized view, string, cannot support the query measure, string
Cause: An attempt was made to push a grouping function through an expression specified in the query to transform a measure. Query rewrite will not occur if this measure transformation failed.
Action: none
QSM-01068: no dimensions present
Cause: An attempt was made to load a dimension from the dataware house, but there were no dimensions present.
Action: none
QSM-01069: summary join graph for, string, does not have table, string
Cause: An attempt to locate an object that is part of a join failed.
Action: none
QSM-01070: equivalence class manager was not found
Cause: An equivalence class manager is required to compute the transitive closure for the columns in an equivalence class.
Action: none
QSM-01071: query rewrite not possible because a join in materialized view % with table % has eliminated some rows found in query
Cause: All lossy joins in the materialized view must be present in the query for query rewrite to occur.
Action: none
QSM-01072: materialized view, string, and query have different joins between tables, string
Cause: Anchors, if any, in the MV and query match. But the joins between these anchors in the MV and query are different.
Action: none
QSM-01073: query rewrite not possible because materialized view, string, has a join not found in query
Cause: Query rewrite may not be possible if the materialized view has some joins that query does not have
Action: none
QSM-01074: query rewrite not possible because materialized view, string, and query have different number of joins between tables, string
Cause: Query rewrite may not be possible if the query has some joins that the materialized view does not have between the same pair of tables.
Action: none
QSM-01075: materialized view, string, does not support aggregate function, string
Cause: The specified aggregate function is not found in the materialized view.
Action: none
QSM-01076: no materialized join view was found
Cause: To support an MJV rewrite, we require a materialized join view.
Action: none
QSM-01077: materialized view, string, is grouping at a higher level than query
Cause: If a query column, which is not present in the materialized view, can be obtained by a rollup within the materialized view, then it should group at a higher level than the materialized view.
Action: none
QSM-01078: materialized view, string, is marked invalid
Cause: The materialized view"s kglobsta field has KGLSINV bit set.
Action: none ??
QSM-01079: DML operation occurred on a table referenced by MV, string
Cause: If any dependent tables of a materialized view undergoes a DML operation, query rewrite may be restricted depending on the query rewrite integrity mode for the session. In this situation, query rewrite will take place only if the rewrite integrity mode is STALE_TOLERATED.
Action: Consider refreshing the materialized view chaning the rewrite integrity mode to STALE_TOLERATED.
QSM-01080: invalid dimension, string
Cause: This dimension table has authorization or compilation problems.
Action: none
QSM-01081: no primary key or row id found for table, string, in MV, string
Cause: In order to obtain a missing column, the materialized view needs to join back to the above table. But it lacks the primary key or rowid for the table.
Action: none
QSM-01082: Joining materialized view, string, with table, string, not possible
Cause: A column in the query is not found in the summary. To obtain the column, a join back of materialized view to the table by means of either the primary key, foreign key or rowid of the table is required. The specified materialized view does not have the primary key, foreign key or rowid of the table to perform the join operation.
Action: Consider building a dimension-table to provide the missing information.
QSM-01083: query text not available - possible inline view
Cause: During the query rewrite transformation, orignal query was possibly transformed into an inline view.
Action: none
QSM-01084: materialized view string has an anchor table string not found in query
Cause: A table in a materialized view is an anchor, (a) if it is not joined to any other table or (b) joined to other tables but each of its joins is either lossy or lossless with the above table being child-side table. If an anchor which is present in the materialized view is not found in the query, then query rewrite will not take place.
Action: none
QSM-01085: materialized view, string, has a lossy join between tables, string
Cause: There are no primary key, foreign key constraints between these tables. But query rewrite is still possible if the lossy join between the above tables also appear in the query
Action: none
QSM-01086: dimension(s) not present or not used in ENFORCED integrity mode
Cause: Query rewrite does not use dimensions in ENFORCED query rewrite integrity mode. If a suitable dimension is present, consider chaning the current integrity mode to either TRUSTED or STALE_ TOLERATED by using ALTER SESSION SET QUERY_REWRITE_INTEGRITY = command.
Action: none
QSM-01087: query grouping on a column that cannot be derived from materialized view, string
Cause: Query is grouping on undetermined columns.
Action: none
QSM-01089: an inline view in the query does not have a materialized view
Cause: General query rewrite is not possible if an inline view in the query does not have a matching materialized view in the meta data.
Action: none
QSM-01090: no query rewrite after view merging
Cause: Internal session parameter _QUERY_REWRITE_1 is set to FALSE
Action: Change session parameter with ALTER SESSION command.
QSM-01091: cost based optimizer found query rewrite is more expensive
Cause: When cost based optimizer is ON, cost of the rewritten cursor is compared to the cursor generated without query rewrite, and the cheaper one is chosen for execution.
Action: none
QSM-01092: mjv tries to rewrite a semi-join and primary key or rowid missing
Cause: Materialized join view tries to rewrite a semi-join (IN sub-query) and the primary keys or rowids of left tables of semi-joins are missing from MJV.
Action: none
QSM-01093: anti-join marker not found in materialized join view
Cause: Materialized join view has outer join while the query inner join. For rewrite to succeed MV must have an anti-join marker like the rowid or primary key of the right tables of outer join
Action: none
QSM-01094: outer-join filter not found in materialized join view
Cause: Materialized join view has outer join while the query inner join. For rewrite to succeed MV must have an anti-join marker like the rowid or primary key of the right tables of outer join
Action: none
QSM-01095: no suitable grouping_id found in MV with grouping sets
Cause: If materialized aggregate view contains grouping sets, then it also must contain the grouping_id() function. This function must contain all columns in the MV GROUP BY.
Action: none
QSM-01096: Materialized view with grouping sets contains duplicates
Cause: Materialized view with grouping sets contains duplicates and no rewrite is supported for it. For example, GROUP BY GROUPING SET ((a), (a)) is not supported for rewrite.
Action: none
QSM-01097: Materialized view with grouping sets has too long key
Cause: Materialized view with grouping sets has more that 64 different keys in its GROUP BY. No rewrite is supported then.
Action: none
QSM-01098: mv string clause more restrictive than query string clause
Cause: The materialized view contains a selection condition in the WHERE or HAVING clause that is more restrictive than the corresponding selection condition in the request query.
Action: Change the selection criteria in the request query to be at least as restrictive as the selection criteria in the materialized view, or drop and recreate the materialized view using less restrictive selection criteria.
QSM-01099: non-tolerated reference to stale portion of mv for table string
Cause: The materialized view is partially stale. It is stale with respect to one or more partitions in one or more of its detail tables. The request query references one or more such detail partitions.
Action: (1) Change the selection criteria of the request to restrict the query to only the fresh portion of the materialized view, or (2) ALTER {SYSTEM|SESSION} QUERY_REWRITE_INTEGRITY = STALE_TOLERATED or (3) refresh the materialized view.
QSM-01100: containment check failed for mv, string
Cause: The materialized view contains a selection condition in the WHERE or HAVING clause that is more restrictive than the corresponding selection condition in the request query.
Action: Change the selection criteria in the request query to be at least as restrictive as the selection criteria in the materialized view, or drop and recreate the materialized view using less restrictive selection criteria.
QSM-01101: rollup(s) took place on mv, string
Cause: If query"s GROUP BY has one of the higher levels of columns found in the materialized view, then the lower level columns in the materialized view will be rolled up to compute the desired results.
Action: none
QSM-01102: materialized view, string, requires join back to table, string, on column, string
Cause: A column in the query does not appear in the materialized view. Query rewrite will try to obtain this column from the base table, by doing a join back to that column with the MV.
Action: none
QSM-01103: there is a remote table, string, referenced in the query
Cause: Query rewrite does not support query with remote tables.
Action: none
QSM-01104: query is using flashback
Cause: Query rewrite does not support flashback.
Action: none
QSM-01105: no primary key or row id in MV, string, is found for table, string
Cause: In order to obtain a missing column, the materialized view needs to join back to the above table. But it lacks the primary key or rowid for the table.
Action: none
QSM-01106: materialized view, string, is stale with respect to some partition(s) in the base table(s)
Cause: Query is requesting some data from the MV that are stale with respect to some partitions in the base tables due to some updates.
Action: refresh the stale partitions and rerun the query
QSM-01107: Partition Containment Tracking (PCT) rewrite is not allowed
Cause: Query rewrite is disabled for PCT through a session parameter
Action: none
QSM-01108: maximum number of disjuncts exceeded in the query string
Cause: Query rewrite engine cannot process the query if the number of disjuncts (OR"s)in the WHERE clause exceeds the maximum allowed number. The number of disjuncts in the query and the maximum allowed disjuncts are given at the end of the message in the form of (no of disjuncts in query, maximum disjuncts allowed).
Action: none
QSM-01109: while rewriting with MV, string, table, string, migrated to