Re: Problem with AS 2000 database

#1

I don't know the exact reason. I just guess meta data is broken partially.
Maybe Microsoft can answer this.

In many similar cases, copy and paste solved the problems.

1. Copy original database and paste it with new name.
2. Delete original database and recopy the new database.

Maybe just cube copy and paste is effective.

Ohjoo

"alejandro" <alejandro (AT) discussions (DOT) microsoft.com> wrote

Quote:

I've six AS databases. Two of them doesn't have problems, but the others
does.
The problem is when I process a cube. The next message displays:
"Cannot find cube <cube_name> in the connection"
I've tried the following alternatives with one of the databases:
-Delete the connection and create it again.
-Delete a cube and create it again.
-Delete the .odb file and copy a backup.
Non of them worked.
Finally, I deleted the database and create a new one.
This worked, but it isn't the best solution for me.
Does anyone know how to solve this problem?
Does anyone know what caused it?

Thanks

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

Re: Problem with AS 2000 database

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

Re: Problem with AS 2000 database - 12-17-2006 , 08:55 AM