Database Error Messages

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

ORA-18402

Analytic view key (%0!s) with value (%1!s) for measure %2!s contains numeric data which cannot be used with COUNT DISTINCT operator.

Cause

There was non-integer numeric data or numeric data that is out of a valid range for a measure with the COUNT DISTINCT aggregation method


Action

Either correct the data in the fact table column so that all rows are integers and are in a valid range, or change the COUNT DISTINCT aggregation method.