Access Violation occurred writing address

Hi folks,
It seems for the last few days my SQL Server has been producing memory dumps
(with errors) about three times a day.
The main error seems to be the following :-
Computer type is AT/AT COMPATIBLE.
Current time is 22:11:16 09/20/05.
1 Intel x86 level 15, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 75%
Total Physical = 991 MB
Available Physical = 240 MB
Total Page File = 2926 MB
Available Page File = 2269 MB
Total Virtual = 2047 MB
Available Virtual = 980 MB
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0029.txt
*
************************************************** ***************************
**
*
* BEGIN STACK DUMP:
* 09/20/05 22:11:16 spid 0
*
* Exception Address = 004093CA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000807
This error with differing memory address happens twice a day at various
times of the day, I had hoped it was linked to server usage however this
doesnt seem the case.
This SQL Server is used as the backend of an Online Web Browser game, and
typically its most active in the evenings however it seems to produce these
errors at any time of the day.
Although if it errors in the morning it wont do it in the evening ... but
then if it errors in the evening it doesnt do it in the morning.
Its almost like SQL is playing up for attention but its not speaking a
language I know.
Does anyone have any Ideas, any help greatly appreciated.
Thanks
Hi
We had this for a while on one of our servers.
We rebuilt all the indexes on all the databases and the problem went away.
Regards-
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel Paull" <DanielPaull@.discussions.microsoft.com> wrote in message
news:7B5217FF-4635-47DC-8F0C-4208A21E99C4@.microsoft.com...
> Hi folks,
> It seems for the last few days my SQL Server has been producing memory
> dumps
> (with errors) about three times a day.
> The main error seems to be the following :-
> Computer type is AT/AT COMPATIBLE.
> Current time is 22:11:16 09/20/05.
> 1 Intel x86 level 15, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 75%
> Total Physical = 991 MB
> Available Physical = 240 MB
> Total Page File = 2926 MB
> Available Page File = 2269 MB
> Total Virtual = 2047 MB
> Available Virtual = 980 MB
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0029.txt
> *
> ************************************************** ***************************
> **
> *
> * BEGIN STACK DUMP:
> * 09/20/05 22:11:16 spid 0
> *
> * Exception Address = 004093CA
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000807
> This error with differing memory address happens twice a day at various
> times of the day, I had hoped it was linked to server usage however this
> doesnt seem the case.
> This SQL Server is used as the backend of an Online Web Browser game, and
> typically its most active in the evenings however it seems to produce
> these
> errors at any time of the day.
> Although if it errors in the morning it wont do it in the evening ... but
> then if it errors in the evening it doesnt do it in the morning.
> Its almost like SQL is playing up for attention but its not speaking a
> language I know.
> Does anyone have any Ideas, any help greatly appreciated.
> Thanks
|||Hi thanks for the reply,
Did you use DBCC DBREINDEX or physically drop and recreate the indexes ?

Access Violation occurred writing address

Hi folks,
It seems for the last few days my SQL Server has been producing memory dumps
(with errors) about three times a day.
The main error seems to be the following :-
Computer type is AT/AT COMPATIBLE.
Current time is 22:11:16 09/20/05.
1 Intel x86 level 15, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 75%
Total Physical = 991 MB
Available Physical = 240 MB
Total Page File = 2926 MB
Available Page File = 2269 MB
Total Virtual = 2047 MB
Available Virtual = 980 MB
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0029.txt
*
****************************************
************************************
*
**
*
* BEGIN STACK DUMP:
* 09/20/05 22:11:16 spid 0
*
* Exception Address = 004093CA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000807
This error with differing memory address happens twice a day at various
times of the day, I had hoped it was linked to server usage however this
doesnt seem the case.
This SQL Server is used as the backend of an Online Web Browser game, and
typically its most active in the evenings however it seems to produce these
errors at any time of the day.
Although if it errors in the morning it wont do it in the evening ... but
then if it errors in the evening it doesnt do it in the morning.
Its almost like SQL is playing up for attention but its not speaking a
language I know.
Does anyone have any Ideas, any help greatly appreciated.
ThanksHi
We had this for a while on one of our servers.
We rebuilt all the indexes on all the databases and the problem went away.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel Paull" <DanielPaull@.discussions.microsoft.com> wrote in message
news:7B5217FF-4635-47DC-8F0C-4208A21E99C4@.microsoft.com...
> Hi folks,
> It seems for the last few days my SQL Server has been producing memory
> dumps
> (with errors) about three times a day.
> The main error seems to be the following :-
> Computer type is AT/AT COMPATIBLE.
> Current time is 22:11:16 09/20/05.
> 1 Intel x86 level 15, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 75%
> Total Physical = 991 MB
> Available Physical = 240 MB
> Total Page File = 2926 MB
> Available Page File = 2269 MB
> Total Virtual = 2047 MB
> Available Virtual = 980 MB
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0029.txt
> *
> ****************************************
**********************************
***
> **
> *
> * BEGIN STACK DUMP:
> * 09/20/05 22:11:16 spid 0
> *
> * Exception Address = 004093CA
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000807
> This error with differing memory address happens twice a day at various
> times of the day, I had hoped it was linked to server usage however this
> doesnt seem the case.
> This SQL Server is used as the backend of an Online Web Browser game, and
> typically its most active in the evenings however it seems to produce
> these
> errors at any time of the day.
> Although if it errors in the morning it wont do it in the evening ... but
> then if it errors in the evening it doesnt do it in the morning.
> Its almost like SQL is playing up for attention but its not speaking a
> language I know.
> Does anyone have any Ideas, any help greatly appreciated.
> Thanks|||Hi thanks for the reply,
Did you use DBCC DBREINDEX or physically drop and recreate the indexes ?

Access Violation occurred writing address

Hi folks,
It seems for the last few days my SQL Server has been producing memory dumps
(with errors) about three times a day.
The main error seems to be the following :-
Computer type is AT/AT COMPATIBLE.
Current time is 22:11:16 09/20/05.
1 Intel x86 level 15, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 75%
Total Physical = 991 MB
Available Physical = 240 MB
Total Page File = 2926 MB
Available Page File = 2269 MB
Total Virtual = 2047 MB
Available Virtual = 980 MB
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0029.txt
*
*****************************************************************************
**
*
* BEGIN STACK DUMP:
* 09/20/05 22:11:16 spid 0
*
* Exception Address = 004093CA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000807
This error with differing memory address happens twice a day at various
times of the day, I had hoped it was linked to server usage however this
doesnt seem the case.
This SQL Server is used as the backend of an Online Web Browser game, and
typically its most active in the evenings however it seems to produce these
errors at any time of the day.
Although if it errors in the morning it wont do it in the evening ... but
then if it errors in the evening it doesnt do it in the morning.
Its almost like SQL is playing up for attention but its not speaking a
language I know.
Does anyone have any Ideas, any help greatly appreciated.
ThanksHi
We had this for a while on one of our servers.
We rebuilt all the indexes on all the databases and the problem went away.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel Paull" <DanielPaull@.discussions.microsoft.com> wrote in message
news:7B5217FF-4635-47DC-8F0C-4208A21E99C4@.microsoft.com...
> Hi folks,
> It seems for the last few days my SQL Server has been producing memory
> dumps
> (with errors) about three times a day.
> The main error seems to be the following :-
> Computer type is AT/AT COMPATIBLE.
> Current time is 22:11:16 09/20/05.
> 1 Intel x86 level 15, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 75%
> Total Physical = 991 MB
> Available Physical = 240 MB
> Total Page File = 2926 MB
> Available Page File = 2269 MB
> Total Virtual = 2047 MB
> Available Virtual = 980 MB
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0029.txt
> *
> *****************************************************************************
> **
> *
> * BEGIN STACK DUMP:
> * 09/20/05 22:11:16 spid 0
> *
> * Exception Address = 004093CA
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000807
> This error with differing memory address happens twice a day at various
> times of the day, I had hoped it was linked to server usage however this
> doesnt seem the case.
> This SQL Server is used as the backend of an Online Web Browser game, and
> typically its most active in the evenings however it seems to produce
> these
> errors at any time of the day.
> Although if it errors in the morning it wont do it in the evening ... but
> then if it errors in the evening it doesnt do it in the morning.
> Its almost like SQL is playing up for attention but its not speaking a
> language I know.
> Does anyone have any Ideas, any help greatly appreciated.
> Thanks|||Hi thanks for the reply,
Did you use DBCC DBREINDEX or physically drop and recreate the indexes ?

Access to snapshot tempfiles is denied

I take a snapshot of a report an it views fine the first time but I get the
following error on subsequent viewings:
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\RSTempFiles\RSFile_6b4351c3-0cfb-4c51-bda1-ac280f1d7eea" is denied.
where the name of the file changes when i re-snapshot it. I've checked the
permissions on the RSTempFiles folder and both the System and ASPNET have
Full Control over it.
Any ideas why this is still happening?
TIA,
Dan Fell.Has anyone solved this issue? I am having the same exact problem with users
who are browsers.
"Dan Fell" wrote:
> I take a snapshot of a report an it views fine the first time but I get the
> following error on subsequent viewings:
> An internal error occurred on the report server. See the error log for more
> details. (rsInternalError) Get Online Help
> Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\RSTempFiles\RSFile_6b4351c3-0cfb-4c51-bda1-ac280f1d7eea" is denied.
> where the name of the file changes when i re-snapshot it. I've checked the
> permissions on the RSTempFiles folder and both the System and ASPNET have
> Full Control over it.
> Any ideas why this is still happening?
> TIA,
> Dan Fell.|||I am having the same exact problem too with snapshots but it doesn't
happen with all the reports. I am assuming that it's a new issue with
reporting services SP2, because snapshots always worked for me prior to
upgrading to SP2. Any help is greatly appreciated. Thanks.
T Robichaux wrote:
> Has anyone solved this issue? I am having the same exact problem with users
> who are browsers.
> "Dan Fell" wrote:
> >
> > I take a snapshot of a report an it views fine the first time but I get the
> > following error on subsequent viewings:
> >
> > An internal error occurred on the report server. See the error log for more
> > details. (rsInternalError) Get Online Help
> > Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\RSTempFiles\RSFile_6b4351c3-0cfb-4c51-bda1-ac280f1d7eea" is denied.
> >
> > where the name of the file changes when i re-snapshot it. I've checked the
> > permissions on the RSTempFiles folder and both the System and ASPNET have
> > Full Control over it.
> >
> > Any ideas why this is still happening?
> >
> > TIA,
> >
> > Dan Fell.|||I had the same Problem: Only one of many reports with the same settings
as the others (render with temporary copy for 30 min) creates always a
file in the RSTempFiles Folder.
I checked the Readme Files and found that since SP1 (section 4.4.4 New
Configuration Settings in sp2Readme_EN.htm) there are settings for
FileSharing.
I added the settings to the configuration
...
<Add Key="WebServiceUseFileShareStorage" Value="false" />
...
<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
<FileShareStorageLocation>
<Path> XXXXX </Path>
</FileShareStorageLocation>
but it still creates the temporary file. You can see that the settings
are regarded when you change the Path. Then the tempfile is placed there
and the errormessage shows the access denied for this path. Either the
setting for the useFileShare = false is ignored or there is some other
setting (in the report?) which "overwrites" the setting.
WORKAROUND:
I gave read permission to everyone on the folder
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles
and it works.
System:
SQL Server 2000, Reporting Services SP2 on as w2k Server, Windows 2003
AD, Integrated Security for SQLServer and IIS, mixed language (englisch,
german) for OS and Applications.
I hope the workaround helps and I still wait for a better solution or
explanation for this file creation.
Best regards,
Markus Mahlitz
Vasu Bojja schrieb:
> I am having the same exact problem too with snapshots but it doesn't
> happen with all the reports. I am assuming that it's a new issue with
> reporting services SP2, because snapshots always worked for me prior to
> upgrading to SP2. Any help is greatly appreciated. Thanks.
>
> T Robichaux wrote:
>> Has anyone solved this issue? I am having the same exact problem with users
>> who are browsers.
>> "Dan Fell" wrote:
>> I take a snapshot of a report an it views fine the first time but I get the
>> following error on subsequent viewings:
>> An internal error occurred on the report server. See the error log for more
>> details. (rsInternalError) Get Online Help
>> Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\RSTempFiles\RSFile_6b4351c3-0cfb-4c51-bda1-ac280f1d7eea" is denied.
>> where the name of the file changes when i re-snapshot it. I've checked the
>> permissions on the RSTempFiles folder and both the System and ASPNET have
>> Full Control over it.
>> Any ideas why this is still happening?
>> TIA,
>> Dan Fell.
>