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 (A-C)

 

Cannot update materialized view because option '%1' has an inappropriate setting

Error constant SQLE_CANNOT_UPDATE_MATVIEW
ODBC 2 State 42000
ODBC 3 State ERROR
Parameter 1 Name of the option with the incorrect setting.
Severity 14
SQLCODE –1052
SQLSTATE 42WB7
Sybase error code 13461
Probable cause

You attempted to update/refresh a materialized view but one of the database options is currently set to a value that is not permitted while updating a materialized view, or, the option's setting does not match the value when the view was created.