Home > Archive > MS SQL Server OLAP > March 2006 > Processing dimension failed / data source error









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Processing dimension failed / data source error
wacNTN

2006-03-28, 9:30 am

We are using Project Server 2003 and have a problem with the cube rebuilding.

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.

Any help would be greatly appreciated!

Walter
--
WAC
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com