Hi all,
Our production server had a raid failure, which we fixed overnight.
This is where the problem started, at least i think.
Now all of a sudden(after the server was restarted) i am getting following error, when one of the stored procedure gets executed
(I have more then 200 Stored Procedure and they are all working fine)
It does not throw error everytime it gets executed, but randomly it will fail.
"SqlDumpExceptionHandler: Process 233 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process"
This error also creats a dump file in MSSQLLog and logs into SQL Error Log.
I also did DBCC CHECKDB suggested by many people on Internet and everything seems fine, in terms of data corruption.
CHECKDB found 0 allocation errors and 0 consistency errors in database 'XXXX'.
I even tried dropping and recreating the stored procedure, but same result and no luck.
My question is why all of a sudden or server re-start would trigger this errors?
By the way I am using VB.Net 2003 and SQL Server 2000. My only fear is that our SQL server does not have latest service pack.
Any ideas or suggestion will be highly appreciated.
I am getting the following stack error in my SQL Server logs. I understand that there is a Microsoft Hotfix available for this and would like to know where will I find the HOTFIX for this because I didn't find it on Microsoft Website. We are currently on SQL 2000 SP 4 (Windows Server 2003 SP1).
Thanks !
***************************************************************************** Computer type is AT/AT COMPATIBLE. Bios Version is IBM - 1000 Current time is 09:02:25 11/16/07. 4 Intel x86 level 6, 2992 Mhz processor(s). Windows NT 5.2 Build 3790 CSD Service Pack 1.
Memory MemoryLoad = 56% Total Physical = 4095 MB Available Physical = 1800 MB Total Page File = 8026 MB Available Page File = 6052 MB Total Virtual = 2047 MB Available Virtual = 203 MB
I have a stored procedure that I use for call a aspx page from within SQL. The stored procedure itself runs finewith no errors but I keep getting errors in the event viewer everytimeit runs (with .vbs, .NET, .vb6 client) outside Enterprise manager or SQL Query Analyzer.....This is error:Error: 0, Severity: 19, State: 0SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.I think that this is the same problem seen inhttp://www.sqlmonster.com/Uwe/Forum...in-Event-ViewerI've test with XP sp2, W2003 server, SQL 2000 sp3a......on the same machine.ANY SUGGESTIONS??????Thanks--Message posted via http://www.sqlmonster.com
I have a big problem on one of our servers here. We have a server (2 processors) with sql7 sp2 (NT4.0 sp6) and 1Gb mem.
With help of client access (V3R2) we retreive data from a AS400 database. This works well on a lot of out servers (20).
On this one server we get an "exception access violation" :
SqlDumpExceptionHandler: Process 12 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.Msg 7399, Level 16, State 1, Server AA0001, Procedure TmpVwAC, Line 3OLE DB provider 'MSDASQL' reported an error. The provider reported an unexpected catastrophic failure.
It runs well many times and suddenly this error occurs.
after one database with 'suspect' and run the sp_resetstatus to remove the suspect, other errors showed after restart SQL2k MSDE sp3. ------------------------------------ 12/10/03 10:10:09 spid 79 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x00403AF0
language_exec: Process 79 generated an access violation. SQL Server is terminating this process.. 2003-12-10 10:10:45.70 spid79 Using 'dbghelp.dll' version '4.0.5' *Dump thread - spid = 79, PSS = 0x1fd2f238, EC = 0x1fd2f560 *Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump1043.txt
We are using SQL Server 6.5, Service Pack 4. We have been facing the Error "EXCEPTION_ACCESS_VIOLATION" when we are running a store procedure which has got joins betweeen temporary tables and views whose source is in another database. The full error message is :-
EXCEPTION_ACCESS_VIOLATION raised, attempting to create symptom dump
** BEGIN STACK TRACE ** 0X00406E71 in SQLSERVER.EXE, CDTCState::~CDTCState() + 0x0101 followed by around 15 similar messages of above line.
Has anyone has faced similar problems and have any workarounds or solutions for similar problems ???
jack_low writes "window 2000 server SQL server 2000 service pack 2
I have an error message in sql server 2000 and it has cause the sql server stop responding and i need to reboot the server whenever it happen . See below
* BEGIN STACK DUMP: * 06/15/06 10:25:56 spid 156 * * Exception Address = 00403431 (lck_lock(class LockRequest const &,class Lock Res const &,class LockInfo *) + 0000008D Line 0+00000000) * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address 20202028 * Input Buffer 370 bytes - * SELECT * FROM INVMAS WHERE SGLOT1 = 'Z' and SGLOT2 = 'PO' and SGLOT3 = ' * 6' and SGLOT4 = '05' and SGLOT5 = '9351' and SGLOT6 = '' and SG = '1 * ' and CHOP = 'SZ0697' and SGWTH = '67'
hello!i am trying to import a text file using dts into a table created by thepackage. everything checks out until it is run. the table is createdbut then i get an error:"need to run the object to perform the operation. Provider generatedcode execution exception EXCEPTION_ACCESS_VIOLATION"any ideas?this is a development box. maybe the server cant handle it?thanks in advance!Tom
To all: I have installed a new Compaq 7000 with NT4.0 sp3 and Sql Server 6.5 sp4 into production about two weeks ago. Everything went fine until yesterday. Around noon I received 2 Exception_Access_Violation about a second apart with two differend spids. About 20 mins later I got the Out of connections message and sql server stopped reponding. I Could not stop sql server and had to reboot the server. I have configured the connections at 600 and generally we average a little over 400. Everything seems to be running fine now but I would like to get some information from all the great minds out there!
What exectly is Exception_Access_Violation? Can I figure out what caused it or can I debug it? Do you think that the EAV caused the out of connections error? Any help, insight would help greatly!
We are receiving an intermitent error "SqlDumpExceptionHandler: Process 120 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. [SQLSTATE HY000] (Error 0). The step failed." From our Sql mail. We are running Windows 2000 Advanced Server and SQL Server 2000 sp3. Has anyone seen this and do you have a solution or suggestions?
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
We have SQL Server 2000 with SP3 installed on Windows 2000 Advance Server. Server has 8 GB RAM and 4 CPU. Few days back we have installed multiple named instance on this server .Now we have assign each CPU to individual instance and min server memory to 1024 and max server memory is kept open.
After this we are facing an issue with default instance for exception_access_violation as below ... Memory MemoryLoad = 83% Total Physical = 7679 MB Available Physical = 1252 MB Total Page File = 15480 MB Available Page File = 7756 MB Total Virtual = 2047 MB Available Virtual = 344 MB
Could anyone help about the following case? many many thanks in advance
1. This problem will be happended for different but similar storeprocedures in transient manner. However, when we try to repeat the problem by running the procedure again, it work fines
2. However, the problem has happended again unexpectedly
3. The problem occurs in different server have similar environment (Window 2003 server and SQL Server 2000 SP4).
My team is getting this message when altering a DTS Package, using SQL 2000 DTS Designer. We have downloaded all the SQL updates (Backward Compatibility, and the one specifically for DTS Save problems. Have tried this in SQL2005 as well. Have uninstalled both of these programs, and reinstalled on local machines. No avail. Here is what happens:
1) Editing an existing DTS Package, such as a Text Change, or simple connection change 2) Saving the file creates the exact message below:
Package Error Error Source: Microsoft Data Transformation Services (DTS) Package Error Description: Code execution exception: EXCEPTION_ACCESS_VIOLATION
3) Then you have to choose OK in the windows Popup Box. 4) The DTS is brought back to the original screen, or completely exited out of Designer. 5) From that point, the Package can no longer be opened for editing, unless you open a previous version (which means changes aren't saved.
We have also tried to SAVE AS another filename. This doesn't work either.
Our team has close to 75 DTS Packages, some simple, some more complex. We are corrupting these left and right. This problem happens no matter what is created in the DTS Package.
This is running into our business operations, and we are unable to find out a resolution...HELP
Recently, I noticed a monthly-run stored procedure (sp_insertAnnualRenewalLetterPrintedStatus) has been causing the aformentioned error, and it ended up creating all these .dmp files... This stored proc was created 10 months ago, and the error only started happenin' for the last 3-4 months! Also, for approx. every one out of 10 times the stored proc ran OK!
Enclosed here is a sample content at the beginning of these .dmp files... Anyone can shed some light? THANKS IN ADVANCE
SImon ================================================== =================== BugCheck Dump ================================================== ===================
This file is generated by Microsoft SQL Server 1792.961 upon detection of fatal unexpected error. Please return this file, the query or program that produced the bugcheck, the database and the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE. Bios Version is Dell Remote Assistant Card v2.0 detected. Phoenix ROM BIOS PLUS Version 1.10 A01 Current local time is Wed Feb 06 15:48:46 2002 2 Intel x86 level 6, 531 Mhz processor(s). Windows NT 4.0 Build 1381 CSD Service Pack 6.
Stack Dump being sent to e:SQLdatalogSQL00024.dmp ************************************************** ***************************** * * BEGIN STACK DUMP: * 02/06/02 15:48:46 spid 28 * * Exception Address = 0064EBF2 (COpenLockBytesSSWrapper::OpenLockBytes + 40) * Exception Code = c0000005 E * Access Violation occurred reading address 00000004 * Input Buffer 126 bytes - * s p _ i n s e r t A n n u a l R e n e w a l L e t t e r P r i n t e d S * t a t u s ' 2 5 / 0 1 / 2 0 0 2 ' , 6 6 , 0
Hi, we have backups taken regularly on tape device. When I restore the back up on the same server,it is working. But if I try to resotre the same backup on a new server it is giving problems I have the same configuration of the new and old server. It is giving error 10005 DB process dead and after that the database is marked grey and in bracket (loading) and a lot of other errors like Begin Stack Trace, sympton dump created,end stack trace ,etc( A very Long List of errors) and a new dump is created in log directory It is also telling "EXCEPTION_ACCESS_VIOLATION" i am having the same problem on all the servers we have. Help me regarding this. DP
While Excecuting select Query in my client place ,the following error is coming.
SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
When i got same database , i try restore in my pc and run the same...query its excecuting properly..with out giving any error..i tried lot of things ..nothing is working out..i am not able to find the root cause itself..why the exception is coming..
I attaching the Error log with this post.
Note: Check For the Keyword 'EXCEPTION_ACCESS_VIOLATION' in the Error Log File.
Any body can help me out in sorting this issue...then :beer: other wise i will be:eek:
Hi, I'm not sure if this is the right forum, so please point me in the right direction if it isn't.
I'm getting an EXCEPTION_ACCESS_VIOLATION and a minidump in the SQL server logs when using the OLE DB Provider for SQL Server.
The error occurs when I run an SSIS package non-interactively (using Package.Execute). The odd thing is that the package works fine when I run it from within Visual Studio. Also, this same bit of code was working fine a couple of weeks ago (it's part of my unit tests, it just started failing when I added a new, unrelated SSIS package to the project). The error occurs during the validation phase.
Here's the first part of the stack dump, which just shows that the provider is executing a very simple statement (SELECT * FROM [table-name]):
Code Snippet
* BEGIN STACK DUMP: * 05/14/07 10:42:34 spid 56 * * * Exception Address = 01CBBF90 Module(sqlservr+00CBBF90) * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION * Access Violation occurred writing address 0000001C * Input Buffer 108 bytes - * ÿÿ & ç> ff ff 02 00 00 00 00 01 26 04 00 00 00 e7 3e 00 09 04 * 2> s e l e c t 00 01 32 3e 00 73 00 65 00 6c 00 65 00 63 00 74 00 20 * * f r o m [ d 00 2a 00 20 00 66 00 72 00 6f 00 6d 00 20 00 5b 00 64 * b o ] . [ P x p T 00 62 00 6f 00 5d 00 2e 00 5b 00 50 00 78 00 70 00 54 * a r g e t ] & 00 61 00 72 00 67 00 65 00 74 00 5d 00 00 01 26 04 04 * & & 02 80 03 00 00 01 26 04 04 04 80 04 00 00 01 26 04 00 *
I presume this is something for the SQL Server team; how should I go about getting this resolved?
I have SQL 2K with SP4. Oracle client is installed on the Server. I have created linked server to Oracle. I am abld to connect to Oracle Server through DTS but when I query an oracle linked server SQl Server crashes with "EXCEPTION_ACCESS_VIOLATION" error.
Info on the Server:
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
I have the SQL dump if you need that. Please help.
Hi i am connecting to a DB2 database on a AS400 machine from SQL server 2005. I have setup a linked server to connect to the DB2 database.
Most of the time the query ( select * from OPENQUERY(lnkd_svrname,'select abc from svr_name.lib_name.tablename') ) works fine but at times it comes up with the following error.
I am running SQL server 2000 Std. Edition on a WIN 2000 machine.
Any help would be appreciated . *****ERROR***** From the Exception.Log file
This file is generated by Microsoft SQL Server version 9.00.1399.06 upon detection of fatal unexpected error. Please return this file, the query or program that produced the bugcheck, the database and the error log, and any other pertinent information with a Service Request.
Team I keep getting this error every so often in the SQL Server(2005.90.3054.00). 2005/SP2/Hot Fixes. Windows Server 2003 SP2. I have researched the web, every one seems to have the same question and nobody seems to have an answer. This somehow does not show up in the Profiler. The apps work normally too. It is a huge eye sore in the LOGs. ================= BugCheck Dump =================
This file is generated by Microsoft SQL Server version 9.00.3054.00 upon detection of fatal unexpected error. Please return this file, the query or program that produced the bugcheck, the database and the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE. Bios Version is COMPAQ - 2 Current time is 15:52:36 09/27/07. 8 Intel x86 level 15, 2694 Mhz processor (s). Windows NT 5.2 Build 3790 CSD Service Pack 2.
Thanks for your help in advance. Paresh Motiwala EDS, Boston, USA The other half of the error message is in the second message of the same thread below.
How are you. i hope you all are having fun. well i have an issue on one of the production box. Version of the box: Microsoft SQL Server 2000 - 8.00.2187 (Intel X86) Mar 9 2006 11:38:51 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
As per SQL serve logs which i received couple of times. step 1) Using 'dbghelp.dll' version '4.0.5' *Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0173.txt 2) SqlDumpExceptionHandler: Process 3920 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 3) Stack Signature for the dump is 0xC578316D
when i searched in google and msdn i could not found the exact solution. if you guys have the knowledge and also got experianced about this issue. kindly please help me in this regards and one more thing i just want to inform you all this is our production server. I think you would understantd how criticality is this.
I really appreciate for your feedback. thank you so much,
Raghu
for the 2nd step it is haing a very huge message. so here i have pasted some part of the message. i think this is more then enough for you all.
I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit): Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.
Extract from log:
<Func Name='LaunchFunction'> Function=Do_sqlPerfmon2 <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_sqlPerfmon2 PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 <Func Name='Do_sqlPerfmon2'> <EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'> PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI) MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,) MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close) MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2 <Func Name='LaunchFunction'> Function=Do_sqlPerfmon2 <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_sqlPerfmon2 PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 <Func Name='Do_sqlPerfmon2'> <EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'> PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 Gathering darwin properties for failure handling. Error Code: 2 MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).
I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.
I have an File System Task that copies a file from one directory ot another. When I hard code the target directory (c:dirfile.txt) it works fine. When I change it to a virtual directory (\serverdirfile.txt) I get a security error:
[File System Task] Error: An error occurred with the following error message: "Access to the path '\gracehbtest oS2TMM_Live_Title_000002.xml' is denied.".
I cannot execute a package by using Execute Package task. I supplied sa credentials to connection manager, and it shows the list of Packages on SQL Server but when running the task it says
Error 0xC0202009 while preparing to load the package. An OLE DB error has occurred. Error code: 0x%1!8.8X!.
I am running dts in Sql Server 2005 management studio from Management, Legacy and data Transformation Services.
Once the dts has run, I get this error message "Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error accessing Windows Event Log."
We have reports deployed in the Report Server. While connecting from client, we are getting the error "An internal error occurred on the report server. See the error log for more details. rsInternal Error)"
Then we went to Report Server, Reporting Service and SQL Server service are all are running fine.
Important thing is some time the reports are working fine, sometimes i am receiving this error. Please help.
We predict whether the services are automatically restarted or transaction logs exceeding the limit or any other parameters to set to avaoid this error?
I'm trying to use an XML Task to do a simple XSLT operation, but it fails with this error message:
[XML Task] Error: An error occurred with the following error message: "There are multiple root elements. Line 5, position 2.".
The source XML file validates fine and I've successfully used it as the XML Source in a data flow task to load some SQL Server tables. It has very few line breaks, so the first 5 lines are pretty long: almost 4000 characters, including 34 start-tags, 19 end-tags, and 2 empty element tags. Here's the very beginning of it:
<?xml version="1.0" encoding="UTF-8"?> <ESDU releaselevel="2006-02" createdate="26 May 2006"><package id="1" title="_standard" shorttitle="_standard" filename="pk_stan" supplementdate="01/05/2005" supplementlevel="1"><abstract><![CDATA[This package contains the standard ESDU Series.]]></abstract>
There is only 1 ESDU root element and only 1 package element.
Of course, the XSLT stylesheet is also an XML document in its own right. I specify it directly in the XML Task:
I have the error above, but no error log. I can preview the sub report - but this main report fails after working this morning. This is for internal company reports and I rebuilt this one after converting from access. I have looked where the error logs should be, but there are no error logs. I rebuilt the query as I needed to change this, but this did not help. Is there someone who could point me in the correct direction.
