MSSQLWIKI

Karthick P.K on SQL Server

SQL Server generated Access Violation dumps while accessing oracle linked servers.

Posted by Karthick P.K on August 8, 2012

 

When you run queries against Oracle linked servers from SQL Server you see errors like one below and access violation dumps are generated (SQLDump00XX.mdmp files in SQL Server error log folder).

{

External dump process returned no errors.
Using ‘dbghelp.dll’ version ‘4.0.5’
SqlDumpExceptionHandler: Process 510 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
*  Exception Address = 000000007752485C Module(ntdll+000000000002285C)

*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION

*   Access Violation occurred reading address 0000041EA9AE2EF0

* Input Buffer 510 bytes -

}

 

To analyze the dump download and Install Windows Debugger from This  link

1. Open Windbg

2. Choose File menu –> select Open crash dump –>Select the Dump file
(SQLDump000#.mdmp)

3. on command window type    
.sympath srv*c:\Websymbols*http://msdl.microsoft.com/download/symbols;

4. Type .reload /f and hit enter. This will force debugger to immediately
load all the symbols.

5. Type .ecxr

6. Type  kL    and look at the stack

 

{

ntdll!RtlpFreeUserBlock
ntdll!RtlFreeHeap

}

If you see above frames in the top of the stack and if you are using Oracle Provider for OLE DB – Version: 11.2.0.1 and later.

There is a known issue with Oracle Provider for OLE DB – Version: 11.2.0.1 and later   when  — STYLE COMMENTS are used in linked server queries ,SP’s Etc .

Resolution

1. Remove the – -style comments
OR
2) use /* */ for the comments instead of –

 

If you liked this post, do like us on FaceBook at https://www.facebook.com/mssqlwiki and join our FaceBook group https://www.facebook.com/mssqlwiki#!/groups/454762937884205/

 

Regards

Karthick P.K

About these ads

4 Responses to “SQL Server generated Access Violation dumps while accessing oracle linked servers.”

  1. Cool. Do you have the link to the oracle site (if that is documented on their site at all) talking about this issue?

  2. […] SQL Server generated Access Violation dumps while accessing oracle linked servers. […]

  3. […] SQL Server generated Access Violation dumps while accessing oracle linked servers. […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 2,144 other followers

%d bloggers like this: