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.
|
||
Top Rated
- How to install Adventure Works SQL DW and Analysis Services 2005 sample database and project
- Analysis Services 2005 XMLA script to add/drop existing partition aggregate
- When accessing calculation tab in BIDS I am getting error Unexpected error occurred
- How in MDX query can I get top 3 sales years based on order quantity?
- How to calculate YTD monthly average and compare it over several years for the same selected month
- Analysis Services 2005 error: Errors in the metadata manager. The attribute with ID of ., Name of . refer
- How in SSAS 2005 do you create what is used to be "Member Properties" in Analysis Services 2000
- What TCP port SQL Server Analysis Services 2005 uses
