QSM-02020

Error: QSM-02020: container column not in SELECT list with NOT NULL constraint

Causa: The capability in question is not supported when the materialized view's container table has a column that does not correspond to an output expression in the select list, and that column has a NOT NULL constraint. This situation can result in problems during refresh since any new rows inserted into the materialized view will set that column to NULL.

Acción: Disable or remove the NOT NULL constraint.