Skip to Content
author's profile photo Former Member
Former Member

Error encountered while processing secured dimension

Hi,

We encountered this error when trying to process this secured dimension. Please refer to screenshot below:

[http://img200.imageshack.us/img200/1277/err1.jpg|http://img200.imageshack.us/img200/1277/err1.jpg]

Kindly advise on how to troubleshoot this.

Thanks!

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 01, 2009 at 03:18 PM

    Hio, Unfortunately I am unable to open the site you noted when you created this question. Can you please advise what the exact wording of the error message is, and what version of the software you are using. Perhaps that will be enough information to help provide a possible solution to your question. Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      In your screen shout, the error seems to be pointing to the length of the costcenter value 2010.

      There may be following cause

      1. 1 - The length of the member value is grater then what is allowd in the fact table

      2. 2 - There may be spaces along with the data

      3. 3 - there may be a data curruption in the fact table.

      possiable Remady

      You will first need to find out the root cause

      if it's

      #1 Then make sure the length of each member is within the limit of the ID field. (Check the Dimension Property to see the length of each field) Id is 20 chr long.

      #2 Make sure there is no space along with the member id's

      #3 - Try to process the cube from SQL AS This will give you the same or more detail message if your cube is offline.

      if you have a rouge data in fact tale it will fail, and then you need to start removeing the elemenets that it dose not have.

      You can also try to delete the data out of fact table and then process the dimension. (I would only do this if you are on Dev system and you have a way of geting the data back!!)

      Hope this helps

      Sam

  • Posted on Sep 04, 2009 at 12:17 AM

    Hi Guik,

    I too face the same problem When processing a dimensionl, it hangs at the "Create admin cache file step."

    It will hang the system for 1 hr, and fails. with showing the Error "String or binary data would be truncated" or "- Exception has been thrown by the target of an invocation."

    Solution : problem was caused by having a memberid, being the same as its dimension name.

    For example: This would occur if the name of the dimension is Entity, and there is a memberid of Entity.

    Hope this helps

    Regards

    SN....

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 04, 2009 at 04:03 AM

    Hi,

    Based on the error message from the first screenshot,

    "*** Inserted secured dimension row(s) count into temp table: 1"

    Can anyone tell me where is the temp table located? Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.