22
Summary Advisor Messages (QSM)

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:

• The fact-filter is correctly specified

• The appropriate constraints exist

• 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 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:

• The fact-filter is correctly specified

• The appropriate constraints exist

• 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

• Whether the summary-names are valid

• The user has privileges to access the summary-names

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.

---