SQL Server 2016 SP2 Issue with Analysis Services

Question

SQL Server 2016 SP2 Issue with Analysis Services

RonKyle

SSC-Dedicated

Points: 31557
More actions
June 6, 2018 at 7:31 am

#354755

All, please be aware that installing SQL Server 2016 SP2 may cause a problem with Analysis Services functions, most notably cube processing. We are in the process of seeing if the issue can be resolved with CU1.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246970 More actions · Answer 1

RonKyle - Wednesday, June 6, 2018 7:31 AM
All, please be aware that installing SQL Server 2016 SP2 may cause a problem with Analysis Services functions, most notably cube processing. We are in the process of seeing if the issue can be resolved with CU1.

I just had to fix this on 2017, by installing CU7.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

RonKyle SSC-Dedicated Points: 31557 More actions · Answer 2

Thanks. That's helpful. That means that MS is aware of the issue and addressing it via a CU.

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 3

RonKyle - Wednesday, June 6, 2018 7:31 AM
All, please be aware that installing SQL Server 2016 SP2 may cause a problem with Analysis Services functions, most notably cube processing. We are in the process of seeing if the issue can be resolved with CU1.

I have it installed on SQL Server, we are noticing weird Lazywrites/issue not sure if it is because of this. Can you please elaborate a little bit on what issue you are noticing.

RonKyle SSC-Dedicated Points: 31557 More actions · Answer 4

I have it installed on SQL Server, we are noticing weird Lazywrites/issue not sure if it is because of this. Can you please elaborate a little bit on what issue you are noticing.

Can't help you there and doubt that is related to my issue, though am not saying that it's unrelated to the SP. I was having trouble with anything directly related to analysis services that was done via automation. So, for example, I could process the cube manually, but it would not process via the SSIS task. The cube would not backup and copy. I saw nothing not related to SSAS that was an issue. But my use of SQL Server is primarily for BI and the databases that support BI solutions.

RonKyle SSC-Dedicated Points: 31557 More actions · Answer 5

Applying CU1 to SP2 resolved the issues we were having. If you use SSAS and apply SP2, you should plan to apply CU1 as well.

Phil Parkin SSC Guru Points: 246970 More actions · Answer 6

curious_sqldba - Wednesday, June 6, 2018 10:27 AM
RonKyle - Wednesday, June 6, 2018 7:31 AM
All, please be aware that installing SQL Server 2016 SP2 may cause a problem with Analysis Services functions, most notably cube processing. We are in the process of seeing if the issue can be resolved with CU1.
I have it installed on SQL Server, we are noticing weird Lazywrites/issue not sure if it is because of this. Can you please elaborate a little bit on what issue you are noticing.

Here is the exact error I was getting in 2017:

As Ron says, it happened when processing a cube from within SSIS.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel