Our resource information has not been updating in any of the Resource Center
views. Also, when we execute a cube rebuild, the screen in Manage
Enterprise... only shows the cube update was initiated. It never reports
that it completed.

So, the DBA and I looked at the database and forced a full rebuild of the
three cubes. No change.

Then, we did a reprocess of all the dimensions. This is when we got the
error on the dimension "Resorce list". The exact error is:

Processing dimension "resource list" failed. No changes have been made to
the database. Data source error: Cannot save object inside Decision Support
Objects (DSO) transaction.

No resources added on 3/17 or after are showing up in our resource center
views. We don't know of anything that happened to cause this but something
obviously did.

Any one have any ideas?

Thanks,

Walter
--
WAC

Re: Cube processing of dimension"resource list" failed by Mike

Mike
Wed Mar 29 14:18:05 CST 2006

Hi Walter,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP


wacNTN wrote:
> Our resource information has not been updating in any of the Resource
> Center views. Also, when we execute a cube rebuild, the screen in
> Manage Enterprise... only shows the cube update was initiated. It
> never reports that it completed.
>
> So, the DBA and I looked at the database and forced a full rebuild of
> the three cubes. No change.
>
> Then, we did a reprocess of all the dimensions. This is when we got
> the error on the dimension "Resorce list". The exact error is:
>
> Processing dimension "resource list" failed. No changes have been
> made to the database. Data source error: Cannot save object inside
> Decision Support Objects (DSO) transaction.
>
> No resources added on 3/17 or after are showing up in our resource
> center views. We don't know of anything that happened to cause this
> but something obviously did.
>
> Any one have any ideas?
>
> Thanks,
>
> Walter