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.

American date problem

Hi there,
I have just installed my MS SQL Server 2000 Box on a Windows 2003 server. I
have this database that came shipped with from my print management suppliers
that allow me track all printing activity. however one of the tables has a
field of a field type "datetime" which is recording all transaction dates in
american format. I have check my regional setting on the Windows 2003 box but
all is set to "Irish format". How can get my SQL box record dates in UK/Irish
date format rather than American format. Is there a setting that I'm missing.
Many thanks,
Liam
Datetime values are stored in a format that is independent of
language/regional settings. The client application is responsible for
formatting.
"Liam Mac" <LiamMac@.discussions.microsoft.com> wrote in message
news:4BA679E3-55FC-46D1-8D32-99E7BCF82ACA@.microsoft.com...
> Hi there,
> I have just installed my MS SQL Server 2000 Box on a Windows 2003 server.
I
> have this database that came shipped with from my print management
suppliers
> that allow me track all printing activity. however one of the tables has
a
> field of a field type "datetime" which is recording all transaction dates
in
> american format. I have check my regional setting on the Windows 2003 box
but
> all is set to "Irish format". How can get my SQL box record dates in
UK/Irish
> date format rather than American format. Is there a setting that I'm
missing.
> Many thanks,
> Liam
>
|||Dates are not stored in any format -- they are stored as two numeric values.
So what you are seeing is how the client tool is showing the dates to you.
http://www.aspfaq.com/
(Reverse address to reply.)
"Liam Mac" <LiamMac@.discussions.microsoft.com> wrote in message
news:4BA679E3-55FC-46D1-8D32-99E7BCF82ACA@.microsoft.com...
> Hi there,
> I have just installed my MS SQL Server 2000 Box on a Windows 2003 server.
I
> have this database that came shipped with from my print management
suppliers
> that allow me track all printing activity. however one of the tables has
a
> field of a field type "datetime" which is recording all transaction dates
in
> american format. I have check my regional setting on the Windows 2003 box
but
> all is set to "Irish format". How can get my SQL box record dates in
UK/Irish
> date format rather than American format. Is there a setting that I'm
missing.
> Many thanks,
> Liam
>

American date problem

Hi there,
I have just installed my MS SQL Server 2000 Box on a Windows 2003 server. I
have this database that came shipped with from my print management suppliers
that allow me track all printing activity. however one of the tables has a
field of a field type "datetime" which is recording all transaction dates in
american format. I have check my regional setting on the Windows 2003 box but
all is set to "Irish format". How can get my SQL box record dates in UK/Irish
date format rather than American format. Is there a setting that I'm missing.
Many thanks,
LiamDatetime values are stored in a format that is independent of
language/regional settings. The client application is responsible for
formatting.
"Liam Mac" <LiamMac@.discussions.microsoft.com> wrote in message
news:4BA679E3-55FC-46D1-8D32-99E7BCF82ACA@.microsoft.com...
> Hi there,
> I have just installed my MS SQL Server 2000 Box on a Windows 2003 server.
I
> have this database that came shipped with from my print management
suppliers
> that allow me track all printing activity. however one of the tables has
a
> field of a field type "datetime" which is recording all transaction dates
in
> american format. I have check my regional setting on the Windows 2003 box
but
> all is set to "Irish format". How can get my SQL box record dates in
UK/Irish
> date format rather than American format. Is there a setting that I'm
missing.
> Many thanks,
> Liam
>|||Dates are not stored in any format -- they are stored as two numeric values.
So what you are seeing is how the client tool is showing the dates to you.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Liam Mac" <LiamMac@.discussions.microsoft.com> wrote in message
news:4BA679E3-55FC-46D1-8D32-99E7BCF82ACA@.microsoft.com...
> Hi there,
> I have just installed my MS SQL Server 2000 Box on a Windows 2003 server.
I
> have this database that came shipped with from my print management
suppliers
> that allow me track all printing activity. however one of the tables has
a
> field of a field type "datetime" which is recording all transaction dates
in
> american format. I have check my regional setting on the Windows 2003 box
but
> all is set to "Irish format". How can get my SQL box record dates in
UK/Irish
> date format rather than American format. Is there a setting that I'm
missing.
> Many thanks,
> Liam
>

Alternative to IIF ? Case ?

Hi,
Need to display a value in a text box based upon perhaps one of four
values a parameter could have. This example is great for two values, = iif(UCASE(Parameters!SUPPID.Value) ="HHH", "Defense & Space", "Defense")
Is there an alternative , case... anything if we need to test for over
parameter values i.e. HHH1, or HHH2.
Many thanks, Steve.Try Switch:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctSwitch.asp
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"saustin99" <saustin99@.discussions.microsoft.com> wrote in message
news:77DEB13A-6813-415E-A4A2-58190F3A7CF4@.microsoft.com...
> Hi,
> Need to display a value in a text box based upon perhaps one of four
> values a parameter could have. This example is great for two values, => iif(UCASE(Parameters!SUPPID.Value) ="HHH", "Defense & Space", "Defense")
> Is there an alternative , case... anything if we need to test for over
> parameter values i.e. HHH1, or HHH2.
> Many thanks, Steve.|||Report parameters have a Value and a Label property. You could use the Label
property for this purpose.
Regarding alternatives for IIF please check the following MSDN links:
* =Choose(...)
http://msdn.microsoft.com/library/en-us/vblr7/html/vafctchoose.asp
* =Switch(...)
http://msdn.microsoft.com/library/en-us/vblr7/html/vafctswitch.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"saustin99" <saustin99@.discussions.microsoft.com> wrote in message
news:77DEB13A-6813-415E-A4A2-58190F3A7CF4@.microsoft.com...
> Hi,
> Need to display a value in a text box based upon perhaps one of four
> values a parameter could have. This example is great for two values, => iif(UCASE(Parameters!SUPPID.Value) ="HHH", "Defense & Space", "Defense")
> Is there an alternative , case... anything if we need to test for over
> parameter values i.e. HHH1, or HHH2.
> Many thanks, Steve.|||Thank you Robert !
"Robert Bruckner [MSFT]" wrote:
> Report parameters have a Value and a Label property. You could use the Label
> property for this purpose.
> Regarding alternatives for IIF please check the following MSDN links:
> * =Choose(...)
> http://msdn.microsoft.com/library/en-us/vblr7/html/vafctchoose.asp
> * =Switch(...)
> http://msdn.microsoft.com/library/en-us/vblr7/html/vafctswitch.asp
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "saustin99" <saustin99@.discussions.microsoft.com> wrote in message
> news:77DEB13A-6813-415E-A4A2-58190F3A7CF4@.microsoft.com...
> > Hi,
> > Need to display a value in a text box based upon perhaps one of four
> > values a parameter could have. This example is great for two values, => > iif(UCASE(Parameters!SUPPID.Value) ="HHH", "Defense & Space", "Defense")
> >
> > Is there an alternative , case... anything if we need to test for over
> > parameter values i.e. HHH1, or HHH2.
> >
> > Many thanks, Steve.
>
>|||Switch rocks !!! Thanks Jeff. Happy New year.
"Jeff A. Stucker" wrote:
> Try Switch:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctSwitch.asp
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "saustin99" <saustin99@.discussions.microsoft.com> wrote in message
> news:77DEB13A-6813-415E-A4A2-58190F3A7CF4@.microsoft.com...
> > Hi,
> > Need to display a value in a text box based upon perhaps one of four
> > values a parameter could have. This example is great for two values, => > iif(UCASE(Parameters!SUPPID.Value) ="HHH", "Defense & Space", "Defense")
> >
> > Is there an alternative , case... anything if we need to test for over
> > parameter values i.e. HHH1, or HHH2.
> >
> > Many thanks, Steve.
>
>