Out of memory while querying causes wrong data to be returned

Running AS 2000, SP4.
A couple of times while querying a cube, one member has got the wrong data displayad (the value are to low).
No matter if I reload the query afterwards, restarting the query application etc, the same faulty value still gets displayed for that member.

After I restart analysis services the value is correct again. No other changes, exact the same query etc.
While analysing the event viewer I see that analysises services has run out of memory before this strange behaviour (MSSQLServerOLAPService - "The server is out of memory").

Could this out-of-memory error has caused the wrong value to be returned, and the somehow the value has got cached on the analysis server so it's not fixed until the server has restarted?
This is the only theory I have, and it's important to figure out the cause. Users are getting worried if they can't trust the data.

The server is dedicated to analysis services and has 3GB memory and /3GB switch enabled. Memory conservation treshold is 2700mb and Minimum allocated memory is set to 1536mb.
The query tool is an asp-application using ADOMD, but the same faulty value was returned while trying the query in MDX Sample App.

First of all try installing SP4 http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5

Second, if problem persists contact customer support and have them looking into your problem.

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

|||Sorry, misprint, I am already running sp 4.|||

There isn't much to recommed in this case.

Have your problem looked at by the customer support ( the doctors) :)

HTH

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

sql

out of control T-Log? NEED HELP PLEASE...

Hello -
I have a problem with a T-Log file that just seems to keep growing no matter
what I do...
Here are the file sizes:
MDF 563,648 KB
LDF 3,244,544 KB !!!
I have done full backups on this database
I have done DBCC shrinkdatabase
I have done DBCC shrinkfile (<LDF filename>, TRUNCATEONLY) (where <LDF filen
ame> is the name of the logfile)
Nothing seems to affect the size of this file.
I even, in desperation, thought that perhaps there was an open transaction i
n the log file, so I ran DBCC OpenTran ('<DBNAME>') (where DBNAME is the na
me of the database) I got back no active open transactions.
There is just no way that I can see that this database (either MDF or LDF fi
le should be that big.
Does anyone have any advise ? Thanks in advance.
RandyvolFull backup doesn't empty the log backup. And shrink won't work either as
the haven't emptied the log file. Either do regular transaction log backups
or set the database to simple recovery model. As for shrinking of the log
files, there are a few useful links in below article:
http://www.karaszi.com/sqlserver/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
news:08ED6880-34CD-4A06-A18B-26DE8DA5AA27@.microsoft.com...
> Hello -
> I have a problem with a T-Log file that just seems to keep growing no
matter what I do...
> Here are the file sizes:
> MDF 563,648 KB
> LDF 3,244,544 KB !!!
> I have done full backups on this database
> I have done DBCC shrinkdatabase
> I have done DBCC shrinkfile (<LDF filename>, TRUNCATEONLY) (where <LDF
filename> is the name of the logfile)
> Nothing seems to affect the size of this file.
> I even, in desperation, thought that perhaps there was an open transaction
in the log file, so I ran DBCC OpenTran ('<DBNAME>') (where DBNAME is the
name of the database) I got back no active open transactions.
> There is just no way that I can see that this database (either MDF or LDF
file should be that big.
> Does anyone have any advise ? Thanks in advance.
> Randyvol|||first thing you can do is search for answers to this question. this questio
n is probably the most asked question in this newsgroup.
short and sweet answer is that you need to do transaction log backups.
randyvol wrote:

> Hello -
> I have a problem with a T-Log file that just seems to keep growing no matt
er what I do...
> Here are the file sizes:
> MDF 563,648 KB
> LDF 3,244,544 KB !!!
> I have done full backups on this database
> I have done DBCC shrinkdatabase
> I have done DBCC shrinkfile (<LDF filename>, TRUNCATEONLY) (where <LDF fil
ename> is the name of the logfile)
> Nothing seems to affect the size of this file.
> I even, in desperation, thought that perhaps there was an open transaction
in the log file, so I ran DBCC OpenTran ('<DBNAME>') (where DBNAME is the
name of the database) I got back no active open transactions.
> There is just no way that I can see that this database (either MDF or LDF
file should be that big.
> Does anyone have any advise ? Thanks in advance.
> Randyvol|||Sorry -
I neglected to state that I have also done T-log backups... at least I think
I have. Maybe you can tell me...
Here's the script for the particular DB in question...
<snip>
BACKUP LOG WHALEYAPPS TO
DISK = 'D:\EMSQLT_BKPS\WHALEYAPPS_LOG.trn'
WITH INIT, STATS = 25
<end snip>
-- Tibor Karaszi wrote: --
Full backup doesn't empty the log backup. And shrink won't work either as
the haven't emptied the log file. Either do regular transaction log backups
or set the database to simple recovery model. As for shrinking of the log
files, there are a few useful links in below article:
http://www.karaszi.com/sqlserver/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
news:08ED6880-34CD-4A06-A18B-26DE8DA5AA27@.microsoft.com...
> Hello -
matter what I do...
> MDF 563,648 KB
> LDF 3,244,544 KB !!!
> I have done DBCC shrinkdatabase
> I have done DBCC shrinkfile (<LDF filename>, TRUNCATEONLY) (where <LDF
filename> is the name of the logfile)
in the log file, so I ran DBCC OpenTran ('<DBNAME>') (where DBNAME is the
name of the database) I got back no active open transactions.
file should be that big.|||Yes, that is a log backup. Check out the links I have on the web page.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"randyvol" <anonymous@.discussions.microsoft.com> wrote in message
news:5769B966-0388-4C2E-A336-ADBF015123D2@.microsoft.com...
> Sorry -
> I neglected to state that I have also done T-log backups... at least I
think I have. Maybe you can tell me...
> Here's the script for the particular DB in question...
> <snip>
> BACKUP LOG WHALEYAPPS TO
> DISK = 'D:\EMSQLT_BKPS\WHALEYAPPS_LOG.trn'
> WITH INIT, STATS = 25
> <end snip>
>
> -- Tibor Karaszi wrote: --
> Full backup doesn't empty the log backup. And shrink won't work
either as
> the haven't emptied the log file. Either do regular transaction log
backups
> or set the database to simple recovery model. As for shrinking of the
log
> files, there are a few useful links in below article:
> http://www.karaszi.com/sqlserver/info_dont_shrink.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
> news:08ED6880-34CD-4A06-A18B-26DE8DA5AA27@.microsoft.com...
no
> matter what I do...
<LDF
> filename> is the name of the logfile)
transaction
> in the log file, so I ran DBCC OpenTran ('<DBNAME>') (where DBNAME
is the
> name of the database) I got back no active open transactions.
or LDF
> file should be that big.
>
>|||Hi Randy,
I am reviewing you post and since we have not heard from you for some time
in the newsgroup, I wonder if you still have some question about it besides
our community member and MVP's information. For any more question, please
post your message here and we are glad to help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

OT: Need Project Tracking software

Hi, sorry for the OT question but the readers opinions will matter more
to me.
I team lead a small development team of .net and sql programmers.
There is another team in our group like ours. We are tracking our
project requests and statuses in Excel as it is shared with people
ourside our teams who also need update abilities.
We're looking for a good project tracking software for teams like ours.
It can be web based preferrably.
PLEASE PLEASE do not tell me to have us write it ourselves. :-) We
can but need to focus on our dev projects.
can you readers suggest some of the 3rd party project tracking and
request applications that you use today that you would recommend?
Thanks!
> can you readers suggest some of the 3rd party project tracking and
> request applications that you use today that you would recommend?
>
www.spudcity.com/traxtime/traxtime.htm
small app, dead easy to use.
JAmie|||We use TRAC which is an integrated source control, bug tracker and
project management tool. It is free and open source.
http://projects.edgewall.com/trac
--Brian
Antonio wrote:
> Hi, sorry for the OT question but the readers opinions will matter more
> to me.
> I team lead a small development team of .net and sql programmers.
> There is another team in our group like ours. We are tracking our
> project requests and statuses in Excel as it is shared with people
> ourside our teams who also need update abilities.
> We're looking for a good project tracking software for teams like ours.
> It can be web based preferrably.
> PLEASE PLEASE do not tell me to have us write it ourselves. :-) We
> can but need to focus on our dev projects.
> can you readers suggest some of the 3rd party project tracking and
> request applications that you use today that you would recommend?
> Thanks!
>|||Of course no SW can help you if there are team members who won't use it.
Even a simple text file is great to track the progress of a project, if you
successfully persuade others to use it.
ML
http://milambda.blogspot.com/