April 11, 2006 at 8:19 am
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.
April 14, 2006 at 8:00 am
This was removed by the editor as SPAM
April 27, 2006 at 2:19 am
I have the same problem, and can't fix it.
April 27, 2006 at 4:35 am
solved. had to go to workflow properties for each object and set to execute on main thread. works fine now. thanks all
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply