We are aware of an issue that occurs when the SQL Server 2016 server where the ICA Analysis Services database is hosted is upgraded to Cumulative Update 7 with a security update patch or to Cumulative Update 8. After the upgrade the cube processing step of the nightly job either takes longer time to complete for small environments or never completes and simply hangs for large environments causing the processing to never complete.
ICA 6.5.2.X, SQL Server 2016
The issue is caused by a security update released by Microsoft to patch the CU7 version of SQL Server 2016 as per the following article:
Our team is working directly with Microsoft on this issue and Microsoft currently has an open case looking into a solution. While the issue is being investigated by Microsoft, the recommendation for any existing customer is not to upgrade to CU7 or CU8 and instead keep the SQL server at the CU6 version, which doesn’t have any open security issues. Here is a link to the CU6 information page: https://support.microsoft.com/en-us/help/4488536/cumulative-update-6-for-sql-server-2016-sp2
For those customers that have already upgraded their environments there is a workaround that will enabled the cube processing step to complete but will extend the time it takes to process that step. The workaround is to modify the cube processing step to process in a sequential fashion instead of parallel by following these steps:
Start SQL Server Management Studio.
Log in to connect to the Risk Fabric relational database.
Expand SQL Server Agent, and then expand Jobs.
Double-click Risk Fabric Processing.
Select the Steps page.
Select the Risk Fabric Cube Processing step, and then click Edit.
On the Command section edit the script and remove the <Parallel> tag from the second line of the script and the </Parallel> tag from the second to last line of the script.
Once the changes above are completed select OK.
Once back in the Steps page click OK.
We can assure you that we are working diligently to find a long term solution with the Microsoft team and as soon as we have one, we will notify you
Subscribing will provide email updates when this Article is updated. Login is required.