Sep 29, 2010 - Microsoft released SQL Server 2008 SP2
Sep 29, 2010 - Microsoft released SQL Server 2008 Service Pack 2 (SP2).
List of bugs that are fixed in SQL Server 2008 SP2 - read here...
Download SQL Server 2008 Service Pack 2 ...
SQL Server 2008 SP2 contains fixes that were included in CU1 through CU8 and additional fixes listed in the article.
All documented SSAS related fixes in SQL Server 2008 SP2 are listed below:
|
SQL Bug Number |
KB Article Number |
Description |
| (SP2) 249682 | 2216454 | FIX: Error message when you run the ProcessAdd command after you make changes to the partition on a server that is running SQL Server 2008: "Internal Error: An unexpected exception occurred" |
| (SP2) 258076 | 2216456 | FIX: SQL Server 2008 Service Pack 2 enhancements to the “Operation has been cancelled” error message text in Analysis Services |
| (SP2) 317800 | 2216472 | A SQL Server 2005 Analysis Services drillthrough statement result is empty |
| (CU1) 290866 | 961146 | FIX: You cannot connect to an instance of SQL Server 2005 Analysis Services through HTTP when you configure Internet Explorer to use a .pac file |
| (CU1) 290871 | 961920 | FIX: A syntax error occurs when you try to use the lift chart to validate a mining model that uses an Oracle data source in SQL Server 2005 Analysis Services |
| (CU1) 290892 | 967148 | FIX: An incorrect result is returned in SQL Server 2008 Analysis Services when you run multiple UPDATE CUBE statements in one transaction or update multiple measures in a single UPDATE CUBE statement in one transaction |
| (CU1) 290879 | 968152 | FIX: Error message when you synchronize a database in Microsoft SQL Server 2008 Analysis Services: "Message: Errors in the metadata manager. An error occurred when loading the Analysis cube" |
| (CU1) 290882 | 968159 | FIX: Error message when you run series of the CREATE SESSION CUBE statement and the DROP SESSION CUBE statement in Microsoft SQL Server 2008 Analysis Services: "An unexpected exception occurred" |
| (CU2) 304028 | 968290 | FIX: A mining model of the Microsoft Decision Tree algorithm generates incorrect nodes when you set the MINIMUM_SUPPORT parameter to "9" in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services |
| (CU2) 304734 | 968900 | FIX: Measures, measure groups, and dimensions that are not part of a perspective are exposed incorrectly when you create a grouping on the perspective in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services |
| (CU2) 303142 | 969235 | FIX: Error message when you run an MDX query in SQL Server 2008 Analysis Service: "The Extract function was called with hierarchy '' that does not exist in the set |
| (CU2) 304044 | 969588 | FIX: Some cell values are doubled when you run an MDX query against a database that has the AllowedSet permission set for a dimension in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services |
| (CU2) 304133 | 970184 | FIX: You receive a "File system error" error message that mentions a temporary file when you process a cube in SQL Server 2008 Analysis Services |
| (CU2) 306626 | 970461 | FIX: An MDX query that contains the Aggregate function incorrectly returns a NULL value for a calculated measure in SQL Server 2008 Analysis Services |
| (CU3) 307698 | 970538 | FIX: Error message when you process the index for a partition in a cube in Microsoft SQL Server 2008 Analysis Services: "Internal error: An unexpected error occurred (file 'pffilestorefilegroup.cpp', line 1483, function 'PFFileStoreGroup::ReadPage')" |
| (CU3) 321810 | 970551 | FIX: Error message when you run an MDX query that requests a dimension property on a parent-child hierarchy in Microsoft SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services |
| (CU3) 321836 | 970966 | FIX: An MDX query that uses the NON EMPTY clause and the DrillDownLevel function returns null values in SQL Server 2005 Analysis Services or SQL Server 2008 Analysis Services |
| (CU3) 311907 | 971772 | FIX: Error message when you process a partition in a measure group in SQL Server 2008 Analysis Services: "Errors in the high-level relational engine. The binding for the '<ColumnName>' column is not a ColumnBinding type" |
| (CU3) 324564 | 972763 | FIX: The queries run very slowly when you run MDX queries in an application that uses the ADOMD.NET data provider through HTTP to connect to SQL Server 2008 Analysis Services |
| (CU3) 322329 | 972777 | FIX: The SQL Server 2008 Analysis Services service crashes when you run an ALTER command on a database while an UPDATE CUBE statement is running on the database |
| (CU3) 326522 | 972984 | FIX: You receive an incorrect result when you query a parent/child hierarchy that contains a single member on a level in Microsoft SQL Server 2008 Analysis Services |
| (CU3) 328433 | 973200 | FIX: No results are returned when you run an MDX query that references a calculated member in SQL Server 2008 |
| (CU4) 326105 | 972939 | FIX: A validation error is returned when you use the MSOLAP10 provider to connect to a SQL Server 2008 R2 Analysis Services server and set the value of the SubQueries property to 2 in the connection string |
| (CU4) 332017 | 973588 | FIX: You receive various error messages when you open a SQL Server Reporting Services report whose data source uses the HTTP protocol to connect to SQL Server 2008 Analysis Services |
| (CU4) 351197 | 975272 | FIX: An access violation occurs when you run a MDX query that involves a calculated member that uses the SUM({set of measures}) function where the set contains measures from different measure groups in SQL Server 2008 |
| (CU5) 365504 | 975748 | FIX: You cannot process an object when you change or delete another unrelated object at the same time in the same database in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services |
| (CU5) 365509 | 975783 | FIX: You receive an incorrect result when you run an MDX query against a dimension that has a parent/child relationship after you install a cumulative update in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services |
| (CU5) 361363 | 976391 | FIX: A MDX query that involves multiple calculated measures may return an incorrect result in SQL Server 2008 Analysis Services |
| (CU6) 385162 | 977309 | FIX: A SSAS 2005 or SSAS 2008 server crashes when you run a Multidimensional Expressions query that uses the CDBL function in a calculated member |
| (CU6) 379712 | 978070 | FIX: The Measures.<X>.Dim folder is created unexpectedly when you use a non-admin user account to browse a cube in SQL Server 2008 Analysis Services |
| (CU6) 89737 | 978904 | FIX: An MDX query returns an incorrect result when it uses multiple nested calculations and custom rollups in SQL Server 2008 Analysis Services |
| (CU7) 385152 | 976412 | FIX: An MDX query resets to a blank query when you click the Data tab in Business Intelligence Development Studio 2005 Report Designer |
| (CU7) 409180 | 979777 | FIX: You experience some problems when you perform a grouping members operation on an Excel pivot table whose data source is an SSAS 2005 cube |
| (CU7) 389638 | 978894 | FIX: Error message when you use Query Builder to modify an existing query of an SSRS 2008 report: "The Query designer cannot load due to a problem with the selected cube <cube name>" |
| (CU7) 406756 | 980252 | FIX: An MDX query that references a calculated measure and a dimension that uses custom rollup formulas returns an incorrect value in SSAS 2008 |
| (CU7) 414565 | 980925 | The result of a MDX query to query a calculated member on a attribute hierarchy lose the formatting you define on the calculated member in SQL Server 2008 Analysis Services |
| (CU7) 414687 | 980930 | FIX: A perspective unexpectedly displays dimensions and measures that were not specified when you view the perspective in Report Builder versions 1.0 or 2.0 in SQL Server 2008 |
| (CU8) 421044 | 979778 | FIX: You receive an error message when you run a query that uses a parent/child dimension in SSAS 2008 |
| (CU8) 426636 | 981838 | FIX: An MDX query returns an incorrect result when you run the query by using a clean cache in SSAS 2008 |
| (CU8) 427277 | 981899 | FIX: An exception occurs when you filter or run an MDX query on a database that contains a dynamic set |
| (CU8) 443051 | 982321 | FIX: Error message when you process an index of a partition in SSAS 2008 |
| (CU8) 444225 | 982418 | FIX: "An unexpected error occurred" error message when you use the OPENROWSET function to access an SSAS 2008 database |
| (CU8) 446259 | 983286 | FIX: "A connection cannot be made" error message in SSAS 2008 when you try to connect to a database |