Cube processing but not showing data

Hi all,
SQL 2005 SP3, AS 2000
I have a cube that is processing but is not showing any data when I browse
the data. The fact and dimension tables have data and there are no null measures
or fields in any of the tables involved. It will process without any problems.
Has anyone come across this before?
Thanks!
Brian
I have! and I hope the solution is the same
Can you confirm that you have installed the ASSP3? (may i suggest SP4 now?).
A lot of people install the SQLSP and assume that it will automatically
upgrade all other products SQL related, i.e. MSDE and AS, but this isn't the
case. There are seperate SP's available for each that can be found on the
same download page from Microsoft as the SQL SP download page.
Try to install the ASSP3 or SP4 and see if that sorts you out.
If you've already done that, then I will crawl back into my hole...
Immy
"Brian Madden" <bmadden@.gmail.com> wrote in message
news:920700632723957312741258@.msnews.microsoft.com ...
> Hi all,
> SQL 2005 SP3, AS 2000
> I have a cube that is processing but is not showing any data when I browse
> the data. The fact and dimension tables have data and there are no null
> measures or fields in any of the tables involved. It will process without
> any problems. Has anyone come across this before?
> Thanks!
> Brian
>

Cube processing but not showing data

Hi all,
SQL 2005 SP3, AS 2000
I have a cube that is processing but is not showing any data when I browse
the data. The fact and dimension tables have data and there are no null meas
ures
or fields in any of the tables involved. It will process without any problem
s.
Has anyone come across this before?
Thanks!
BrianI have! and I hope the solution is the same
Can you confirm that you have installed the ASSP3? (may i suggest SP4 now?).
A lot of people install the SQLSP and assume that it will automatically
upgrade all other products SQL related, i.e. MSDE and AS, but this isn't the
case. There are seperate SP's available for each that can be found on the
same download page from Microsoft as the SQL SP download page.
Try to install the ASSP3 or SP4 and see if that sorts you out.
If you've already done that, then I will crawl back into my hole...
Immy
"Brian Madden" <bmadden@.gmail.com> wrote in message
news:920700632723957312741258@.msnews.microsoft.com...
> Hi all,
> SQL 2005 SP3, AS 2000
> I have a cube that is processing but is not showing any data when I browse
> the data. The fact and dimension tables have data and there are no null
> measures or fields in any of the tables involved. It will process without
> any problems. Has anyone come across this before?
> Thanks!
> Brian
>

CSRSS.EXE and SP3

Hi,
I've had this same issue on two machines, one Win2k3 Server and a XP SP1
machine.
The problem is that after installing SP3 opening any SQL Gui tool (I think
it's only that as osql.exe don't cause this) including the SQL Service
Manager causes CSRSS.EXE to spike at 100% and basically render the machine
unusable. Closer inspection reveals that it's continually respawning
whichever application you opened.
I've seen this referenced [1] a while back but no real cause/solutions :S
Any help would greatly appreciated as it's quite urgent that I get a working
SQL server.
Thanks in advance,
Armand
[1]
http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2003-01/5353.htmlJust a quick update - osql.exe causes exactly the same effect.
"Armand du Plessis" wrote:
> Hi,
> I've had this same issue on two machines, one Win2k3 Server and a XP SP1
> machine.
> The problem is that after installing SP3 opening any SQL Gui tool (I think
> it's only that as osql.exe don't cause this) including the SQL Service
> Manager causes CSRSS.EXE to spike at 100% and basically render the machine
> unusable. Closer inspection reveals that it's continually respawning
> whichever application you opened.
> I've seen this referenced [1] a while back but no real cause/solutions :S
> Any help would greatly appreciated as it's quite urgent that I get a working
> SQL server.
> Thanks in advance,
> Armand
> [1]
> http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2003-01/5353.html

CSRSS.EXE and SP3

Hi,
I've had this same issue on two machines, one Win2k3 Server and a XP SP1
machine.
The problem is that after installing SP3 opening any SQL Gui tool (I think
it's only that as osql.exe don't cause this) including the SQL Service
Manager causes CSRSS.EXE to spike at 100% and basically render the machine
unusable. Closer inspection reveals that it's continually respawning
whichever application you opened.
I've seen this referenced [1] a while back but no real cause/solutions :S
Any help would greatly appreciated as it's quite urgent that I get a working
SQL server.
Thanks in advance,
Armand
[1]
http://www.derkeiler.com/Newsgroups/...3-01/5353.html
Just a quick update - osql.exe causes exactly the same effect.
"Armand du Plessis" wrote:

> Hi,
> I've had this same issue on two machines, one Win2k3 Server and a XP SP1
> machine.
> The problem is that after installing SP3 opening any SQL Gui tool (I think
> it's only that as osql.exe don't cause this) including the SQL Service
> Manager causes CSRSS.EXE to spike at 100% and basically render the machine
> unusable. Closer inspection reveals that it's continually respawning
> whichever application you opened.
> I've seen this referenced [1] a while back but no real cause/solutions :S
> Any help would greatly appreciated as it's quite urgent that I get a working
> SQL server.
> Thanks in advance,
> Armand
> [1]
> http://www.derkeiler.com/Newsgroups/...3-01/5353.html

CSRSS.EXE and SP3

Hi,
I've had this same issue on two machines, one Win2k3 Server and a XP SP1
machine.
The problem is that after installing SP3 opening any SQL Gui tool (I think
it's only that as osql.exe don't cause this) including the SQL Service
Manager causes CSRSS.EXE to spike at 100% and basically render the machine
unusable. Closer inspection reveals that it's continually respawning
whichever application you opened.
I've seen this referenced [1] a while back but no real cause/solutions :
S
Any help would greatly appreciated as it's quite urgent that I get a working
SQL server.
Thanks in advance,
Armand
[1]
53.html" target="_blank">http://www.derkeiler.com/Newsgroups...
53.htmlJust a quick update - osql.exe causes exactly the same effect.
"Armand du Plessis" wrote:

> Hi,
> I've had this same issue on two machines, one Win2k3 Server and a XP SP1
> machine.
> The problem is that after installing SP3 opening any SQL Gui tool (I think
> it's only that as osql.exe don't cause this) including the SQL Service
> Manager causes CSRSS.EXE to spike at 100% and basically render the machine
> unusable. Closer inspection reveals that it's continually respawning
> whichever application you opened.
> I've seen this referenced [1] a while back but no real cause/solutions
:S
> Any help would greatly appreciated as it's quite urgent that I get a worki
ng
> SQL server.
> Thanks in advance,
> Armand
> [1]
> l" target="_blank">http://www.derkeiler.com/Newsgroups...53.htm
l

CSDVersion key for Service Pack

I was looking up the changes in SP3 and SP3a, and basically the ways to
identify the service pack is installed on the system. In one of the
references I found that the CSDVersion key under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\CurrentVersion
has changed.
I wanted to know whether the CSDVersion key changes with every service pack
release.
From what I have heard, that is not a reliable measure.
"Harshal" <Harshal@.discussions.microsoft.com> wrote in message
news:AAE3B70A-AEDE-4350-B872-D44697DD759F@.microsoft.com...
> I was looking up the changes in SP3 and SP3a, and basically the ways to
> identify the service pack is installed on the system. In one of the
> references I found that the CSDVersion key under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\CurrentVersion
> has changed.
> I wanted to know whether the CSDVersion key changes with every service
> pack
> release.

CSDVersion key for Service Pack

I was looking up the changes in SP3 and SP3a, and basically the ways to
identify the service pack is installed on the system. In one of the
references I found that the CSDVersion key under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
has changed.
I wanted to know whether the CSDVersion key changes with every service pack
release.From what I have heard, that is not a reliable measure.
"Harshal" <Harshal@.discussions.microsoft.com> wrote in message
news:AAE3B70A-AEDE-4350-B872-D44697DD759F@.microsoft.com...
> I was looking up the changes in SP3 and SP3a, and basically the ways to
> identify the service pack is installed on the system. In one of the
> references I found that the CSDVersion key under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
> has changed.
> I wanted to know whether the CSDVersion key changes with every service
> pack
> release.

CSDVersion key for Service Pack

I was looking up the changes in SP3 and SP3a, and basically the ways to
identify the service pack is installed on the system. In one of the
references I found that the CSDVersion key under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\CurrentVersion
has changed.
I wanted to know whether the CSDVersion key changes with every service pack
release.From what I have heard, that is not a reliable measure.
"Harshal" <Harshal@.discussions.microsoft.com> wrote in message
news:AAE3B70A-AEDE-4350-B872-D44697DD759F@.microsoft.com...
> I was looking up the changes in SP3 and SP3a, and basically the ways to
> identify the service pack is installed on the system. In one of the
> references I found that the CSDVersion key under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\CurrentVersi
on
> has changed.
> I wanted to know whether the CSDVersion key changes with every service
> pack
> release.