Error(-2147221423): Unable to open server object...

[Walter Miller]

Hi. Please see error below we're getting when executing
a package. This has worked in the past. The only
changes have been the addition of some cubes and shared
dimensions to the datamart. Oh, and a the latest MS
Security Patch applied: SP4.

Some things to note:
1. AS2K (Win2K Server) with the cubes/dimensions is on a
separate box than SQL2K (Win2K Server) from where package
resides.
2. We have mirrored AS2K and SQL2K servers that are not
having this problem.

Thanks,

Walter Miller
mill...@wellsfargo.com [3 to e to respond]

Error = 1 (00000001), Description = 8/3/2003 7:08:05
AM 12841 Committing transaction in
Database 'ACDataMart'
Error = 1 (00000001), Description = 8/3/2003 7:08:10
AM 12841 Analysis Server Error: Connection
to the server is lost; Time:8/3/2003 7:08:10 AM
Error = 1 (00000001), Description = 8/3/2003 7:08:10
AM 12841 Error(-2147221411): Process
operation failed; Time:8/3/2003 7:08:10 AM
Error = 1 (00000001), Description = 8/3/2003 7:08:10
AM 12841 Error(-2147221423): Unable to open
server object (Internal (Database 'ACDataMart' could not
be opened on the server)); Time:8/3/2003 7:08:10 AM
Error = 1 (00000001), Description = 8/3/2003 7:08:10
AM 12841 Rolling back transaction in
Database 'ACDataMart'
Error = 1 (00000001), Description = 8/3/2003 7:08:10
AM 12841 Analysis Server Error: Connection
to the server is lost; Time:8/3/2003 7:08:10 AM

-----End Task Log-----

Step 'DTSStep_DTSOlapProcess.Task_2' was not executed

[lavinb...@gmail.com]

I am getting the same error.

Please advise how this can be fixed and why its happened.

Error(-2147221423): Unable to open server object (Internal (Database 'OLAP' could not be opened on the server)).

For me, to re run the incremental process fixed the issue temporarily.

Thanks,
Lavin