Re: cube processing weird error - please help

#1

Might someone have changed the SQL Agent account or removed it from the OLAP
Administrators group?
Can you run the DTS package interactively from an account that you know
belongs to the OLAP Adminstrators group, e.g. Adminstrator??

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Mark Andrews" <NOSPAMmandrews (AT) rptsoftware (DOT) com> wrote

Quote:

Here's my situation:

I have a DTS task with one analysis service processing task that does a
full
process
on our olap catalog. Worked fine for the last 6 months.

I then did some work on development to build more cubes and change cubes
and
deleted
the production catalog and restored the development catalog to replace it
(same name etc...)

I am now getting an error when the job runs that that runs the DTS task
about one of the virtual
cubes having no visible measures (it does have all hidden regular measures
and all visible calculated measures).

However I can run the DTS task myself from Enterprise manager fine with no
errors.

Anyone have a clue as to what this might be?

Thanks in advance,
Mark

#2

That would be a good guess, however the account which runs SQL Agent was
still in the
OLAP Administrators group and I can run it from my account manually with no
problems.

I made one regular measure visible in the one virtual cube and everything
worked fine?????

I have 5 virtual cubes in which I made all regular measures NOT visible and
for some weird
reason running this DTS job using SQL Agent has this behavior. I'm giving
up for now if anyone
might know what this is please email me directly.

Thanks,
Mark

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Quote:

Might someone have changed the SQL Agent account or removed it from the
OLAP
Administrators group?
Can you run the DTS package interactively from an account that you know
belongs to the OLAP Adminstrators group, e.g. Adminstrator??

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no
rights.

"Mark Andrews" <NOSPAMmandrews (AT) rptsoftware (DOT) com> wrote in message
news:eNRJ21%23ZDHA.2352 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Here's my situation:

I have a DTS task with one analysis service processing task that does a
full
process
on our olap catalog. Worked fine for the last 6 months.

I then did some work on development to build more cubes and change cubes
and
deleted
the production catalog and restored the development catalog to replace
it
(same name etc...)

I am now getting an error when the job runs that that runs the DTS task
about one of the virtual
cubes having no visible measures (it does have all hidden regular
measures
and all visible calculated measures).

However I can run the DTS task myself from Enterprise manager fine with
no
errors.

Anyone have a clue as to what this might be?

Thanks in advance,
Mark

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: cube processing weird error - please help

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: cube processing weird error - please help - 08-22-2003 , 04:45 PM

Re: cube processing weird error - please help - 08-25-2003 , 12:44 PM