Management FAQ How to fix dimension processing error 'mdprocessdim.cpp line 3429 function MDProcessPropertyJob'
| How to fix dimension processing error 'mdprocessdim.cpp line 3429 function MDProcessPropertyJob' |
| Written by Vidas Matelis | |||
| Friday, 09 May 2008 00:54 | |||
|
Q: While processing cube I am getting error message: Internal error: An unexpected error occurred (file 'mdprocessdim.cpp', line 3429, function 'MDProcessPropertyJob::OnLaunch'). How can I fix this? A: In most cases this indicate that your Analysis Services database somehow got corrupted. This can hapen when you change a dimensions structure and deploy changes using "Deploy changes only" option from the BIDS studio to the server, but not all related changes/affected objects were correctly deployed. To fix this you should: - Connect to SQL Server Analysis Services (SSAS) using SQL Server Management Studio and drop affected database and then deploy your Analysis services project from BIDS studio to the server. - Or in BIDS you can change project deployment options from "Deploy changes only" to "Deploy All" and then deploy your project.
|
Most read
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- MDX-How can I get Last (Previous) Year to Date (YTD) values?
- What TCP port SQL Server Analysis Services 2005 uses
- MDX-How do you format or round KPI expression value?
- MDX-How do you calculate monthly average of one year, optionally including empty months?
