The materialized view cannot be changed to immediate because its select list contains a SUM function over a nullable expression and it doesn't contain COUNT function over the same expression

Error constant SQLE_UPDATABLE_MATVIEW_COUNT_NULL_EXPR
ODBC 2 state ERROR
ODBC 3 state ERROR
Severity 15
SQLCODE -1327
SQLSTATE 42WCE
Sybase error code 13229
 Probable cause