I got an error while processing my cube

Question

I got an error while processing my cube

ted.motter

SSC Veteran

Points: 251
More actions
July 23, 2015 at 7:13 am

#302616

Hello,
I've got an problem, but I don't know how to fix it.
When I procces my cube I got an error.
It's a little bit strange because I processed my cube twice already with no errors and now when I want to procces it for the third time it goes in error.
When I procces, I get the following error:
<Error ErrorCode="3239313412" Description="Errors in the metadata manager. Either the dimension with the ID of 'Dim_PolisObjDekking' does not exist in the database with the ID of 'VAS', or the user does not have permissions to access the object." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" /></Messages></root></results></return>. The step failed.
Can someone help me with this error?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

sgmunson SSC Guru Points: 110651 More actions · Answer 1

ted.motter (7/23/2015)
Hello,
I've got an problem, but I don't know how to fix it.
When I procces my cube I got an error.
It's a little bit strange because I processed my cube twice already with no errors and now when I want to procces it for the third time it goes in error.
When I procces, I get the following error:
<Error ErrorCode="3239313412" Description="Errors in the metadata manager. Either the dimension with the ID of 'Dim_PolisObjDekking' does not exist in the database with the ID of 'VAS', or the user does not have permissions to access the object." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" /></Messages></root></results></return>. The step failed.
Can someone help me with this error?

Check to be sure that duplicate values don't exist in the table feeding that dimension...

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 2

ted.motter (7/23/2015)
Hello,
I've got an problem, but I don't know how to fix it.
When I procces my cube I got an error.
It's a little bit strange because I processed my cube twice already with no errors and now when I want to procces it for the third time it goes in error.
When I procces, I get the following error:
<Error ErrorCode="3239313412" Description="Errors in the metadata manager. Either the dimension with the ID of 'Dim_PolisObjDekking' does not exist in the database with the ID of 'VAS', or the user does not have permissions to access the object." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" /></Messages></root></results></return>. The step failed.
Can someone help me with this error?

This normally happens when there's a key in the fact table that points to a dimension that is missing that key. This error can also occur what cubes get processed before a dimension that it connects to.

So, check if there's any key in the fact table pointing to Dim_PolisObjDekking where the key does not exist.

Also, check that OLAP objects get processed in the correct order, dims before cubes.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]