Silent SSAS shutdown caused by writeback timeout

A number of customers using SSAS instances with writeback functionality reported frequent crashes that were not accompanied by any useful error message. The only hint found in msmdsrv.log close to time of crash was: (03.04.2016 13:30:21) Message: OLE DB-Fehler: OLE DB- oder ODBC-Fehler : Query timeout expired; HYT00. (Source: \\?\J:\Log\msmdsrv.log, Type: 3, Category: 289, Event…


SSAS 2012 in a hardened windows 2012 environment

All the specific details are not exactly clear. But if you harden your windows 2012 server in such a way that the Users and Everyone local Windows groups no longer have the User Right : Bypass traverse checking(SeChangeNotifyPrivilege) Then it can be that you might get one or both of the following problems: a) If you…

0

uninstall of clustered SSAS instance may disable “olap redirection service”

  “OLAP redirection service” is the part of SQL browser service that supports SSAS connectivity. If you stick to our recommendation to only use “virtual server name” for connecting to clustered SSAS instances (see previous post: http://blogs.msdn.com/b/as_emea/archive/2014/01/08/connecting-to-clustered-ssas-instances.aspx), then you won’t need the “olap redirection service”. However, we are aware that there are some situations where…


"Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014" has been released

Thanks to the efforts of our US support colleagues Karan Gulati and Jon Burchel we now have an updated version of the SSAS performance guide available.  The “Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014” document can be downloaded from MSDN via the following link: http://msdn.microsoft.com/en-us/library/dn749781.aspx As the name suggests it contains advice…


New SSAS failover clustering white paper released

I’m glad to announce that we released an SSAS failover clustering whitepaper that fills in a large white spot in our documentation. It discusses many SSAS clustering aspects including setup + configuration, deployment modes, connectivity, and administration. Many thanks to MVP Alan Hirt and Heidi Steen from the MS content team for all the efforts…


How to connect to clustered Analysis Services instances

While clustered SSAS instances have been around for a while, we noted that there is still some confusion about the recommended way for connecting to clustered instances and our supportability policy. Let’s start with the hopefully well known behavior for non-clustered SSAS instances. Stand-alone Instances All default SSAS instances will listen on port tcp 2383….


you may obtain a .dstore related file system error when processing TFS cube

Recently we have seen a number of issues where TFS cube processing failed with a file system error. The error is always referencing the decode store (.dstore) of the primary key attribute (FileSK) of the “File” dimension. The error message typically looks similar to this: Exception Message: File system error: The following file is corrupted:…


SQL Server 2012 SP1 CU3 release fixes frequent SP1 issues

We normally don’t comment much on Cumulative Update releases since the best source for this type of information is the blog of the SQL server release services team : http://blogs.msdn.com/b/sqlreleaseservices/ . However, adding to the SP1 issue that was described in previous blog by Guillaume Fourrat we observed two further SSAS related problems that affected several customers….


SQL 2012 SP1 : Recommended udpate.

Hi, Sorry for bringing up something not strictly related to our ‘cube world’, but more coverage can’t hurt here : If you have installed SQL Server 2012 Service Pack 1, or if you plan to, it is highly recommended to apply a specific subsequent update as quickly as possible. This is announced on the official…


1 hour timeout for data refreshes in Powerpivot for Sharepoint

In the previous blog post I explained that we have a 1 hour timeout in Powerpivot for Excel due to the inherited default SSAS instance properties. Now you might argue that this timeout should not pose a problem in the Powerpivot for Sharepoint environment. After all we are using a standalone SSAS instance in Sharepoint mode….