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 %1 cannot be changed to immediate because it has already been initialized

Error constant SQLE_IMMEDIATE_MV_REFRESH_NOT_ALLOWED
ODBC 2 State 42000
ODBC 3 State ERROR
Parameter 1 Name of the materialized view.
Severity 14
SQLCODE –1170
SQLSTATE 42WC3
Sybase error code 13343
Probable cause

You attempted to change the refresh type to immediate for a materialized view which is already in an initialized state. Truncate the view before changing the refresh type.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1