|
Home > Archive > MS SQL Server OLAP > November 2005 > connection lost error when I process 2 cubes (AS2000)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
connection lost error when I process 2 cubes (AS2000)
|
|
|
| Hi,
when I process 2 cubes at the same time, I receive a connection lost error
at the end of the process of 1 of the 2 cubes.
I talk about cubes, not partitions.
I have a dedicated OLAP Server, and a dedicated SQL Server (data warehouse).
the AS repository is stored in the MSDB database.
some other times, the error is about an error against the log database, the
system cannot reinit the table.
any idea?
thanks.
Jerome.
| |
| Ramunas Balukonis 2005-11-29, 3:23 am |
| Hi,
your memory may exceed your defined memory. Try loading performance counter
Analysis Server: Proc (Memory Size Bytes) to diagnoze this. In my enviroment
this counter shows ~ 2.7 GB (3 GB - cache memory - dimensions memory) and
after 2.7 GB I receive connection lost error also. Try to process cubes
separetally and look at this counter.
Ramunas Balukonis
"Jéjé" < willgart@BBBhotmailA
AA.com> wrote in message
news:uo9FKAK9FHA.636@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> when I process 2 cubes at the same time, I receive a connection lost error
> at the end of the process of 1 of the 2 cubes.
> I talk about cubes, not partitions.
>
> I have a dedicated OLAP Server, and a dedicated SQL Server (data
warehouse).
> the AS repository is stored in the MSDB database.
>
> some other times, the error is about an error against the log database,
the
> system cannot reinit the table.
>
> any idea?
>
> thanks.
>
> Jerome.
>
>
|
|
|
|
|