Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Olap data aggregation error.

Posted on 2008-10-22
1
Medium Priority
?
576 Views
Last Modified: 2013-11-16
If i try to design aggregations in my olap cubes i get the following error:

The 'Query' required element is missing under Envelope/Body/Execute/Command/Alter/ObjectDefinition/Database/Dimensions/Dimension/ProactiveCaching/Source/IncrementalProcessingNotifications/IncrementalProcessingNotification at line 7216, column 60 (namespace 'http://schemas.microsoft.com/analysisservices/2003/engine').

To restart the process, resolve the problem, and then click Start.

I can't find the line 7216 because if i look at the code for a specific cube they don't go that high.  also, i have many cubes and get the same error when designing aggregations in each one.  I have tried on multiple systems attached to the same olap database.  I used both the live database and a project solution file.  We are using SQL 2005 Std edition so we don't have any proactive caching, and everything is MOLAP.  Any help would be greatly appreciated.

0
Comment
Question by:saxophobe60
1 Comment
 
LVL 22

Accepted Solution

by:
PedroCGD earned 2000 total points
ID: 22778796
Install SP2 and Cumulative package 9, and try again!
regards!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

581 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