July 23, 2015 at 7:13 am
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?
July 23, 2015 at 7:54 am
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)
July 23, 2015 at 8:08 am
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.
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]
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply