Cube processing of dimension"resource list" failed

[wacNTN]

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

 

[Mike Glen]

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