This article describes the resolution for the issue that is faced while processing the OLAP cube in SQL Analysis Services. While processing the dimension in the cube sometimes the dimension gets hanged or it throws the error “– 2147221411: Process operation failed”.
Problem Summary
When you try to process the shared dimension of a OLAP cube in SQL Server 2000 Analysis server, It takes time for the dimension to get processed but after a long span of time also if the dimension does not get processed or it shows the error “– 2147221411: Process operation failed”.
Resolution
Following Steps needs to be followed to resolve the issue:
- Stop the service “MSSQLServerOLAPService”
- Go to the drive where related data folder is present.
- The path for the data folder can be find by right click the OLAP database and look into the properties.
- By default the path is “..\Program Files\OLAP Services\Data\”
- Delete\Rename the related cube folder and .odb file.
- Restart the service “MSSQLServerOLAPService”
- Reprocess the dimension again, along with the other entire dimension.
Related Posts
- Step by Step : SQL Server 2005 Analysis Services (SSAS) Project
- SQL Server 2005 Components
- SQL Server 2000 Maintenance Jobs Failed with Error 22029
- Error: SQL0161N Insert or Update operation does not conform to the view definition
- Troubleshooting SSRS Error “The report server is not responding”
Tags: error 2147221411, Error while Processing OLAP, Hanging Dimension, SQL Server Analysis Services, SSAC
