Oracle Error ORA-37188: unexpected null result while querying string

Oracle Error Message

ORA-37188: unexpected null result while querying string

Reason for the Error

While querying the input fact table, the sparsity advisor unexpectedly got no results, possibly due to changes being made during operation.

Solution

Retry the operation ensuring that the data is not changed while the sparsity advisor is running / Errors from 37200 – 37399 are reserved for events