i have an analysis services dts job on an old sql server 2000 box. i have never used analysis services before, and am a bit stuck. the job used to run and succeed all the time, but now it fails most of the time. this is the error that goes with the failure. someone suggested that its because more than 1 cube processing jobs were running at the same time, but i dont know how i would sort that out as they have to be run at the times they are scheduled for.
ERROR:
Executed as user: REDMOND\osqlli01. ...
tart: DTSStep_DTSExecuteSQLTask_4
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnStart: DTSStep_DTSOlapProcess.Task_1
DTSRun OnError: DTSStep_DTSOlapProcess.Task_1, Error = -2146828197 (800A005B)
Error string: Object variable or With block variable not set
Error source: DSO Help file:
Help context: 1000091
Error Detail Records: Error: 0 (0);
Provider Error: 0 (0)
Error string: Object variable or With block variable not set
Error source: DSO Help file:
Help context: 1000091
DTSRun OnFinish: DTSStep_DTSOlapProcess.Task_1
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_10
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_10
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_7
DTSRun OnError: DTSStep_DTSExecuteSQLTask_7, Error = -2147220421 (8004043B... Process Exit Code 2. The step failed.
Maybe you have to turn on the 'execute on main thread' option !
You can find it on the workflow properties in your DTS-Package !
Winston,
Were you able to find a solution or the cause to this problem? This error has started to occur when I try to process a cube on Analysis Services 2000.
Thanks,
Jake
|||In the past, I got the same kind of error !
My error occured because my 'Navision-odbc-driver' did NOT support multithreading ! In other words, executing tasks simultaneously caused my error !
To solve that error: On every workflow, I turned on the 'execute on main thread' option !
Kind regards,
Geert G.
