I'm used to match the error message to the processing step that caused the
error in AS 2000.

In AS 2005, I have a processing window (called deployment progress), where
everything supposedely "completed successfully", but at the bottom of the
pane, the status says "Deployment Failed" in red.
In the "Error List" window, I have a first warning saying "Errors in the
OLAP storage engine: The attribute key cannot be found: Table T1, Column: C1,
Value: V1."
I checked in Table T1, and the value V1 does exist in column C1.

I can see several queries in the processing window, but I cannot find a way
to match the error message to a query in the processing window.

How do I find out which query is being executed as the error occured?
Again in AS 2000 this would be trivial.

Switch over to the SQL Management studio and try and start processing from
there. Process object by object.

It is very possible processing of one of your partitions failed.
Most probably the problem is in the fact table of the partition fails
processing. The fact table contains the key that is not existent in the
dimension table.

Edward Melomed
--
This posting is provided "AS IS" with no warranties, and confers no rights


"Pat" <pat (AT) online (DOT) nospam> wrote