Symptom
- SAP SQL Anywhere asserts if a REFRESH MATERIALIZED VIEW statement is interrupted and the server rolls its operations back.
- Only happens if the statement contains the ISOLATION LEVEL clause with other than SHARE MODE, EXCLUSIVE MODE or SNAPSHOT.
- Immediate materialized views are not affected.
Read more...
Environment
- SAP SQL Anywhere 16.0
- SAP SQL Anywhere 17.0
Product
SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0
Keywords
refresh materialized view, sql anywhere, assertion, 201503, 201501, 200608 , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.