Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Help -- Cube Processing is Failing

Author  Topic  ksw Starting Member 24 Posts Posted - 2002-08-06 : 17:48:36 I have a cube that is continually failing after we make updates to one of the dimension tables. Once a week, we delete, add, & update records in the dimension table. Daily, we add records to the table. We are not making any structual changes so we are just doing Incremental updates on the dimensions. We were doing a Full Process on the cube, but the error still occurs if I just attempt the Refresh Data option for processing. The cube processed fine for months with this routine, and then one day it just started failing after the weekly update. We would have to restore the dimension table back to before the update and then everything would work fine. It would still run fine on a daily basis after the daily additions were made. Sometimes the error I get is Step Error Source: Demand Product 2002 Step Error Description:Connection to the server is lost Step Error code: 80040075 Step Error Help File: Step Error Help Context ID:1000440 But most of the time it's this one Step Error Source: Demand Product 2002 Step Error Description:Internal error [Object does not exist] 'VP' Step Error code: 80040053 Step Error Help File: Step Error Help Context ID:1000440 I have searched Microsoft's website for this error and cannot find any information on it. The closest I've found is : Processing error [Object does not exist] 'object name' not Internal error. Has anyone seen something like this before or have any ideas on how to fix it? This has happened every week for the past 5 weeks. Then to make things even more confusing, yesterday, I ran our weekly update process to the dimension and got the cubes to process, but then today, after the daily update, the cube failed. This was the part that had never caused problems. I'm at a loss and any insight would be greatly appreciated. We're running SQL Server 2000 SP2 & Analysis Services SP2 --KSW