Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (T-Z)

 

The materialized view cannot be changed to immediate because it does not have a unique index on non-aggregate non-nullable columns

Error constant SQLE_UPDATABLE_MATVIEW_NON_AGGR_INDEX
ODBC 2 State 42000
ODBC 3 State ERROR
Severity 16
SQLCODE –1218
SQLSTATE 42WC7
Sybase error code 13299
Probable cause

You attempted to change the refresh type to immediate for a materialized view which does not have a unique index on non-aggregate non-nullable columns. Create a unique index on the materialized view before changing the refresh type.