Neoview Messages Manual (R2.3)

Cause The refresh operation cannot complete because a failure occurred on a required
internal task.
Effect The operation fails.
Recovery REFRESH the materialized view again: first use the CANCEL option to clean up,
and then retry the REFRESH command. If the error persists, contact HP support.
SQL 20551
20551 The materialized view mv-name cannot be refreshed (not all of the
used materialized views are initialized).
mv-name
is a materialized view name.
Cause One or more of the materialized views used by mv-name have not been initialized.
Effect The operation fails.
Recovery Initialize all materialized views used by mv-name.
SQL 20552
20552 The current user does not have the refresh privilege for
materialized view mv-name.
mv-name
is a materialized view name.
Cause You do not have the correct privileges to perform the requested operation. You need
the insert privilege on the materialized view to refresh the materialized view. To initialize the
materialized view, you additionally need select and delete privileges.
Effect The operation fails.
Recovery Acquire the needed privileges and retry the refresh operation. If the needed
privileges are unavailable, ask the owner of the materialized view to perform the requested
operation.
SQL 20553
20553 Materialized view mv-name is unavailable. Specify the RECOMPUTE
option explicitly for refresh.
mv-name
is a materialized view name.
Cause If an unavailable materialized view is refreshed, the refresh RECOMPUTE option
must be specified.
Effect The operation fails.
Recovery Correct the syntax, and resubmit the command.
SQL 20555
20555 ON STATEMENT materialized view mv-name is already initialized.
mv-name
is a materialized view name.
Cause You tried to initialize a materialized view that is already initialized.
Effect The operation fails.
Recovery None. This is an informational message.
SQL 20556
20556 Materialized view mv-name cannot be refreshed standalone (the
used materialized view(s) and table(s) are not coordinated).
mv-name
is a materialized view name.
280 Utility Messages (20000 Through 23099)