Neoview Messages Manual (R2.2)

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 Illegal store by clause. The columns specified 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.
Effect The creation of the materialized view fails.
Recovery Add one or more non-null columns as group by columns and resubmit the create
materialized view statement.
SQL 12109
12109 To ensure optimal Refresh performance, the store by clause should
include the following group-by columns: col-names.
col-names
are the group by columns that should be included in the STORE BY clause.
Cause To improve the materialized view refresh performance, the specified columns should
have been included in the STORE BY clause.
225