analysis service DTS keeps failing . ERRORSOURCE = DSO

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 !

|||i just checked. it is set to run on the main process. that box is checked.|||

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.

analysis service DTS keeps failing . ERRORSOURCE = DSO

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 !

|||i just checked. it is set to run on the main process. that box is checked.|||

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.

An error occurred while trying to access the database information. The msdb database could not b

I'am doing functionality test on DTS packages and saving my DTS packages to meta data services instead of saving them as local packages. We would like to see what information would be provided by saving them this way, but when we try to open the meta data browser (the 3rd icon under DTS) we get the following error:

An error occurred while trying to access the database information. The msdb database could not be opened.

You might want to try asking this in the DTS group: http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

Amazing

Hi everyone,

I've got a dts 2000 which owns a Sql Task:

werweuroweuroiweruewr

DECLARE @.CONTADOR BIGINT

SET @.CONTADOR = 0

WHILE @.CONTADOR <= 100000

BEGIN

INSERT INTO TABLA1 (ID,NOMBRE) VALUES(@.CONTADOR,'PRUEBAS')

SET @.CONTADOR = @.CONTADOR + 1

END

'werweuroweuroiweruewr' obviously doesn't exists in my database, but it's ignored 110 times.

Then I see that TABLA1 own 100 rows. After that fails, of course.

Could you please so kind to give me any explanation for this behaviour. I'm totally stuck,

I haven't enought words (in english) in order to define this!

Why SQL executes 110 times that loop and then, oh my god, discover that 'weerrrr...' doesn't exists at all and stop!

If possible and there is explanation for that it could happen in SQL 2005?

Thanks in advance,

What is "werweuro..." supposed to represent? I'm confused.|||

Enric,

Where are you getting the error? This seems to be a DB/T-sql related issue.

I just ran that sample code in SSMS, I don't have Table1 of course, and the first error I received is:

Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'werweuroweuroiweruewr'.

Msg 208, Level 16, State 1, Line 13

Invalid object name 'TABLA1'.

So, I am not sure...

|||

Hi both,

That's simply garbage. It doesn't exits at all. I don't know why it insert rows.

Ok, guys, run this code in your Query Analyzer:

werewr
DECLARE @.CONTADOR BIGINT
SET @.CONTADOR = 0

WHILE @.CONTADOR <= 100000
BEGIN
INSERT INTO TABLA1 (ID,NOMBRE) VALUES(@.CONTADOR,'PRUEBAS')
SET @.CONTADOR = @.CONTADOR + 1

END

I'll tested it and at the end TABLA1 have 100000 rows (despite the error)

|||At the end of the day it only demonstrate that Sql Task from DTS have a different behaviour than a Query Analyzer session. I knew that but anuway, how to configure?