Hi all,

Found an interesting one. I built a standard time
dimension off of a table using keys to order etc. The
dimension processed fine the first time. Subsequent
attempts to process are generating the following error:

Analysis Server Error: Connection to the server is lost;
Time:12/2/2003 9:28:40 AM

All of my other dimensions process fine. I've tried
deleting and re-creating the Time dimension, but still get
the same error. Any ideas would be welcome.

Thanks,

Mark

Hi,

Could you check your application event log and look if processing this
dimension didn't crash the server (restart). You can look for that in the
eventlog and look in the timeframe it crashed for event's 117 of Analysis
server.

If this is the case please copy in the dbghelp.dll from the SQL2000sp3 in
the Microsoft Analysis Server\bin directory this will generate a mini dump
next time it crashes. Please send me a copy of this dump if above applies.
The dump will be placed in the DATA directory as sqldmpr0001.mdmp

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."

This one should be easy....

Looks like your dimension has a few members...

The "connection lost" message comes up very often meaning "server out of
memory". Try to restart your OLAP server and process the dim again. The
reason it should process first time after service restart is there is
nothing in memory at that time. Once processed the dimension sits in memory,
and second processing attemt has less memory available.

HTH
Szymon Slupik, CDN S.A.
Krakow, Poland