OLAP error: the maximum number of dimension key processing errors has been exceeded.

Posted on 2005-04-28
Last Modified: 2008-01-09
Dear experts,
I got this error when processing an olap partition:
"the maximum number of dimension key processing errors has been exceeded".
Strangely in another partition the same error don't cancel the process.
I can get over it by manually processing dimensions before cubes,
but is there a way to bypass this error when processing automaticly?
Thanks in advance.
Question by:prismabi
    LVL 11

    Accepted Solution

    Is this processing done after structure changes ? If so run a Full Process not just a incremental or refresh.
    You can specify the maximum number of errors to tolerate but the errors are telling you you need to update your dimensions usually

    Author Comment

    Just the data need to be updated. I have to try Full process,
    but it's a long process, and meanwhile users cannot use the cubes at all.

    Author Comment

    I'll try another time. Meanwhile i'll do the process manually.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now