Processing a database via DTS, called from a SQL Server Agent Job, fail
with the following Error



DTSStep_DTSOlapProcess.Task_1, Error = -2147221411 (8004005D)

...

Msg 50000, Sev 16: ERRORE: problema nel processamento del cubo PM.
[SQLSTATE 42000]

(in English: Error: problem in cube processing)



Processing cube via Analysis Manager works right. Since last week the
processing works also with SQL Server Agent Job.



The processing fail on a full cube processing after all dimension full
processing.



Any suggestion?



I find some informations about error code 2147221411, but they are all
about server shutdown problems and this is not my case.



Thanks for help.


--
Posted via http://dbforums.com

rferraris <member14482 (AT) dbforums (DOT) com> wrote

Did you check securtiy?
Wich is the account that the SQL Agent loggs in?
Does it have the necessary priviligies?
Bentzi