Error While Refreshing A MS Datawarehousing Cube
We have a cube that we are populating the data from the source tables. To get the data to reflect we are calling the "Analysis services processing task" component. While the cube is being refreshed we are getting the following error.
Description: OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01. End Error Error: 2009-03-13 02:26:11.24 Code: 0xC11F000C Source: Process LedgerTransactions01 cube Analysis Services Execute DDL Task Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Item V', Name of 'dimItem' was being processed.
The cube is running in a SQL server environment and this issue is not happening always.
Answer
This post seems to suggest that one possible causes of this error is a lack of space on the server.
Related Questions
- → How to create decimal variable dynamically in SQL Server
- → How to ensure non-null duplicate values are not inserted in SQL Server 2005
- → SQL Server 2005 implementation of MySQL REPLACE INTO?
- → Deploying SQL Server Databases from Test to Live
- → Why doesn't VFP .NET OLEdb provider work in 64 bit Windows?
- → Client collation and SQL Server 2005
- → Why doesn't SQL Full Text Indexing return results for words containing #?
- → Have you ever encountered a query that SQL Server could not execute because it referenced too many tables?
- → SQL Server 2005 For XML Explicit - Need help formatting
- → Paging SQL Server 2005 Results
- → Error while refreshing a MS datawarehousing cube
- → Storing credentials in SSRS 2005
- → DELETE Statement hangs on SQL Server for no apparent reason