Database Error Messages

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

QSM-01123

self-join algorithm could not resolve multiple instances

Cause

The generalized self-join algorithm could not resolve the mutliple instances, likely due to mismatch in joins or measures


Action

Consider using aliases in the query to match with the aliases in the materialized view