SSAS-Info.com - Microsoft SQL Server Analysis Services (SSAS) 2005/2008 resource hub
SSAS FAQ 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'
User Rating: / 1
PoorBest 
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.