Oracle8i Error Messages Release 2 (8.1.6) A76999-01 |
|
QSM-00501 unable to initialize Summary Advisor environment
Cause: The Summary Advisor external procedure initialization process failed.
Action: Contact Oracle Customer Support.
QSM-00502 OCI error
Cause: An OCI callback routine reported an error
Action: Contact Oracle Customer Support.
QSM-00503 out of memory
Cause: Summary Advisor failed to allocate the necessary memory.
Action: Contact Oracle Customer Support.
QSM-00504 internal error
Cause: An internal error occurred.
Action: Contact Oracle Customer Support.
QSM-00505 syntax error
Cause: A syntax error occurred.
Action: Correct syntax error if possible or contact Oracle Customer 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 whether:
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 summaries
Cause: The system metadata does not contain statistics on one or more summaries. The Advisor needs cardinalities of all summaries in the data warehouse.
Action: Run ANALYZE on the tables and summaries 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 whether:
QSM-00512 invalid summaries specified in the retention-list
Cause: The summaries specified in the retention-list are not valid.
Action: Check:
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 (that is, WORK$_IDEAL_MVIEW) may not be created whereas the other table is created. The most likely cause of this is the initialization parameters needed to invoke mview-rewrite are not enabled. Check your documentation for all the initialization 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.
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|