I am using AMO to process our cubes in SSAS2005. I've been running a trace
while deleting a partition and have a question.

Three different rows:

1. Command Begin: 2 - Delete
2. Notification: 7 - Object Deleted
3. Command End: 2 - Delete


Rows one and two don't have any error associated with them. Row three has an
error of 1. I can't figure out why or what that means. The partition is
successfully dropped. What does the error of 1 on Command End mean?

Manually deleting through Managment Studio throws this same error.

What's also weird is that we have two databases called "Daily" and "Hourly".
The database name on command begin and end is the "Daily", while the
database name on the Notification is "Hourly". This is only for deleting
through Managment Studio. Why do the commands have different database names
than the notification?




"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote

Anyone?

MS?


"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote

The Error column is a status code -- if it is a negative 32-bit number then
it means something went wrong. The result code 0 typically indicates success
but in reality all positive numbers are success codes.

In this case I'm guessing that the end of the statement is not finding the
metadata object (because it got deleted) and reporting the status code of
S_FALSE (as in COM).

So essentially what I am saying is: don't be concerned about an Error code
that is >= 0.

HTH,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote

Gotcha, very good to know.



"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> wrote