Consider the following scenario:
- You have a computer that has Microsoft SQL Server 2016 Analysis Services (SSAS 2016) installed.
- There are many users who belong to different roles in SSAS 2016.
- The partitions have a Relational Online Analytical Processing (ROLAP) writeback function.
- Every user establishes a create session.
- Users read data from the ROLAP partition by using a SELECT statement.
- Users write new values in the ROLAP partition so that the UPDATE CUBE function is run in their own session.
- After the UPDATE CUBE function is run several times, the ClearCache command is run to clear the SSAS caches.
In this scenario, after several iterations of reading, writing, and updating the ROLAP partition by users, an internal exception access violation occurs, and the SSAS server stops responding. Additionally, you have to restart SSAS 2016.
The fix for this problem is included in the following updates for SQL Server:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.