In a windows 2000 .NET service, we continuously process fact tables
into cubes. Typically every 15 minutes the service picks up available
fact tables, builds cubes and deletes the fact tables.
The processing part is done using DSO. However, on some occasions, the
DSO loses connection to the Analysis Services, and the processing
fails. On logging the error that we get, we found that the error given
by Analysis Services is one of:

System.Runtime.InteropServices.COMException (0x80040075): Connection
to
the server is lost
at DSO._Partition.Process(ProcessTypes ProcessOption)

or

System.Runtime.InteropServices.COMException (0x80040033): Cannot
connect to the repository.

or

System.Runtime.InteropServices.COMException (0x80010108): The object
invoked has disconnected from its clients.
at DSO.ServerClass.get_MDStores()

or

System.Runtime.InteropServices.COMException (0x80010108): The object
invoked has disconnected from its clients.
at DSO.ServerClass.get_State()

We found a link describing something similar, and a
workaround:http://support.microsoft.com/default.aspx?kbid=823357
But the above problems happen even after we changed the memory
settings as were suggested.
At all times the OLAP service is in the running state and is not found
to be dead when the error occurs.

Can you suggest any more solutions to this problem of intermittent
connection loss?

Thanks

I am using SQL server 2000 with Service pack3 for both SQL server and
Analysis services.

If you haven't migrated your repository to SQL Server I would suggest that
as a first step.
By default, Analysis Services uses a MS Access database called msmdrep.mdb
as it's repository.
This is OK for small systems, but we strongly recommend migrating to SQL
Server for production use.
However, both forms require a good quality underlying networking
infrastructure, which could also be the case here.
You should be putting retry logic in your application so it can be
re-started appropriately.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Yash" <yashgt (AT) yahoo (DOT) com> wrote