Archive for the ‘ SQL 2012 ’ Category
I ran into this bug when I restarted the SQL Server 2012 Tabular service. I only saw 4 of my databases. The application error log was not very helpful A ton of “An error occurred when loading the Model.” messages. The other message I saw was “The database cryptographic key could not be loaded”
This seems to be an issue with SSAS not closing the file properly. What I did to fix was to look at the details of the error and see what files caused the error. I had a ton of these errors but I was able to track the problem back to the first MSOLAP type error where I saw error “An error occurred when loading the [Table Name]” where table name was a table in one of my cubes.
I stopped SSIS service and then deleted E:\MSAS11.DETAB12\OLAP\Data\cust_hist.0.db folder and E:\MSAS11.DETAB12\OLAP\Data\cust_hist.0.xml file. I restarted SSIS and then restored from backup.
I did find a link to a fix http://support.microsoft.com/kb/2724881 but it was already installed. Another post http://www.sqlservercentral.com/Forums/Topic880079-147-1.aspx#bm880318 said it was because of changes to the services account but that does not seem to be the problem as I never have and service account is a admin.
Wondering if anyone else has found a fix for this…
I’m still getting used to it the days of many dimensions with cubes is going to migrate into tabular. I will be the first to admit its hard to let my SQL, Oracle.. data warehouses go. But using tabular you can process data and handle bad data using DAX. It lets your users use data. Its all free with Excel 2010. Download PowerPivot and see what you can do with you old data marts, data warehouses, SQL Databases Oracle Databases, Access, etc. You can use them all together and let your power users create dynamic PowerPivot sheets on their own. Using SharePoint 2010 you can look at usage and import into tabular if it the data needs to be updated on schedule. Multidimensional still has a purpose but with Tabular you can put it into memory and have the fastest results. Any small data marts I do as Tabular and huge one use Multidimensional and then tabular.
Wow, let all business units make their own cubes using PowerPivot and SSAS Tabular many worlds hopefully same data? No Microsoft did a great job, Our star schema cubes are good. We can pull data using Normal Excel Pivot Table and MDX from the cube itself We can also allow users access to the Multidimensional cube, datamart or relational database.
What we get with Tabular is the ability to empower the users to use data models as soon as OLTP changes are made. Using PowerPivot users can now work in excel and use SSAS, Oracle, SQL Server, MS Access, MYSQL… to pull in data into PowerPivot. They can create facts and measures using relational data models in PowerPivot.
Using Sharepoint 2010 users can share their PowerPivot Excel spreadsheet to other users. I can then convert the PowerPivot Spreadsheet to SQL 2012 Tabular and partition the data so each datasource is processed daily, hourly..
The great thing is I can now partition dimensions and facts.
I will follow up with real time dimension and fact processing