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

SQL 12075
12075 A materialized view metadata table cannot be directly updated.
Cause You attempted to directly update a materialized view metadata table.
Effect The operation failed.
Recovery None.
SQL 12081
12081 Audit type not allowed for materialized view refresh type.
Cause The specified audit type is not allowed for the specified refresh type.
Effect The creation of the materialized view fails.
Recovery Correct the syntax and resubmit.
SQL 12087
12087 Operation failed since table log is not empty.
Cause This operation can be performed only when the table log is empty.
Effect The operation fails.
Recovery Refresh all the materialized views that use this table and try again.
SQL 12092
12092 Group by columns cannot exceed 255 characters.
Cause The total size of all the materialized view Group By columns exceeds 255 characters.
Effect The creation of the materialized view fails.
Recovery Rewrite the Create Materialized View statement so that the total size of all the
Group BY columns does not exceed 255 characters, and resubmit the Create Materialized View
statement.
SQL 12106
12106 The index was created with NO POPULATE clause. It will be populated
during first refresh.
Cause A newly created index will not be populated until the materialized view is initialized.
Effect The is an informational message. The index cannot be used until the materialized view
is refreshed.
Recovery None.
SQL 12107
12107 The STORE BY clause is illegal. The specified columns are
aggregated columns or do not exist.
Cause The materialized view STORE BY clause includes references to the materialized view
columns that are either aggregate or nonexistent columns.
Effect The creation of the materialized view fails.
Recovery Fix the STORE BY clause to exclude the aggregate or nonexistent columns and
resubmit statement.
SQL 12108
12108 The materialized view was defined without a STORE BY clause.
Cause The materialized view definition does not include a STORE BY clause and all the
GROUP BY columns are nullable columns.
243