I have some XMLA which runs fine in SSMS, but fails when called as a step in an agent job. Here is the XMLA:
ÃÂ ÃÂ <Process xmlns="http://schemas.microsoft.com/analysisservices/2003/engine
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ <Object>
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ <DatabaseID>MyCube</DatabaseID>
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ </Object>
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ <Type>ProcessFull</Type>
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ <WriteBackTableCreation>UseExisting</WriteBackTableCreation>
ÃÂ ÃÂ ÃÂ </Process>
And here is the error from SQL Agent:
An exception (0xe0434f4d) occurred in the ANALYSISCOMMAND subsystem.ÃÂ The step failed.
I am running this on SQL 2005 SP3 Developer Edition. I have even tried uninstalling and reinstalling the instance. The PC also has SQL 2008 instances installed (I'm not sure it that is relevant or not). I can get the SQL Agent job working fine on SQL 2008 and another SQL 2005 box.
Can anyone help?
View Complete Post