Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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