After getting the cube to successfully deploy and process on Friday, I was baffled on Monday that the newly added dimension caused the cube processing to break. I then followed the first instinct, discarded all my changes to reverted back to the version on Friday, and had no luck. The error message (attached below) did not help as I was looking for some kind of SQL service error. After examining the windows server log and the SQL server log, I just couldn’t see anything wrong with it.
After swearing for some time, and with the help of going off and working on something else for a while. I came back to the solution and looked at the data source. Even though I know I have never changed the provider (the default setup gave me SQL native client), I decided to change it and give OLE DB a try.
This simple change allows my cube to process successfully again. While I don’t understand why the same settings that worked last week doesn’t work this week, I don’t have all the information to say with certainty that nothing has changed in the environment (firewall changes, server updates, etc.).
SSAS processing error :
<Batch xmlns = "http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns : xsd = "http://www.w3.org/2001/XMLSchema" xmlns : xsi =
"http://www.w3.org/2001/XMLSchema-instance" xmlns : ddl2 =
"http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns : ddl2_2 =
"http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns : ddl100_100 =
"http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns : ddl200 =
"http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns : ddl200_200 =
"http://schemas.microsoft.com/analysisservices/2010/engine/200/200">
<Object><DatabaseID> DWH Sales Facts</ DatabaseID>
<CubeID> DWH Sales Facts</ CubeID></ Object><Type> ProcessFull</ Type>
<WriteBackTableCreation> UseExisting</ WriteBackTableCreation></ Process>
</ Parallel></ Batch>
Processing Dimension ‘Date’ completed.
Errors and Warnings from Response
OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘DWH Sales Facts’, Name of ‘DWH Sales Facts’.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Currency’, Name of ‘Currency’ was being processed.
Errors in the OLAP storage engine: An error occurred while the ‘Currency Dim ID’ attribute of the ‘Currency’ dimension from the ‘DWH Sales Facts’ database was being processed.
Internal error: The operation terminated unsuccessfully.
Server: The operation has been cancelled.
Print | posted on Thursday, June 21, 2012 4:09 PM