Neoview Messages Manual (Volume 1) (R2.4)

SQL 20550
20550 Unable to compile statement : string.
string
is the statement that failed to compile.
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 your HP service provider.
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.
290 Utility Messages (20000 Through 23099)