April 15, 2009 at 11:28 pm
Hi all Pals!!!!
I am facing a weird error at one of our customer sites. I spent many hours but didn't find any sort of hint or resolution to the issue. For now only as a temporary resolution we are just rebooting the machine.
Its really appreciated if any can out me in a right direction.... 🙁
The event logs provides me only this error:
Exception happened when running extended stored procedure 'sp_OACreate' in the library 'odsole70.dll'. SQL Server is terminating process 71. Exception type: Win32 exception; Exception code: 0xe06d7363.
and the sql logs gives me a different error like this:
CryptoAPI function 'CryptAcquirecontext' failed
This issue caused almost 7hrs of downtime 🙁 ... can anyone help me ASAP
April 16, 2009 at 6:35 am
Hi Vinu,
The error you are getting is a compiler error and is described in (http://support.microsoft.com/kb/185294) - but that doesn't really tell you what actually caused it.
As an exception was caught you should have a number of SQLDumpr* txt, mdmp and log files in the Log directory. (I am assumuing sql 2005 from what I remember sql 2000 had two sets, the mdmp and the .txt files)
You have two options, the first is to contact Microsoft support and get them to have a look at the dump files and work out what it is, or (and/or) you can try posting some of the info here.
What we will need is to take a look at the SQLDump00xx.txt file - specifically the input buffer and the stack trace - this might point to an obvious candidate, if it doesn't then the SQLDump000X.mdmp should be a user dump which will have a stack trace and *might* show what the problem is.
Ed
April 16, 2009 at 6:57 am
hi edwardelliott ,
thnx for you response... let me check on this and wil update
April 16, 2009 at 7:13 am
'sp_OA***' procs have always been on a bumpy road.:sick:
With sql2005/8, if you can, convert all extended sprocs to CLR modules.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 11, 2009 at 1:43 am
This recurred again after a month now.....
it gives out same errors and event error logs are also not helping much...
any suggestions? 🙁
June 11, 2009 at 1:46 am
i found these errors:
'General cryptographic failure.'
June 11, 2009 at 1:52 am
did your sqlserver memory consumption grow contantly during this month ?
If yes, you may be suffering a leak and may need to plan reboots on a regular basis, unless you can convert to CLR usage.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 11, 2009 at 1:56 am
its not having any scheduled reboot and can u give me any idea how to conver to CLR...
June 11, 2009 at 2:31 am
We don't use any xprocs, so I didn't have to convert them.
We only used sp_oacreate with smtp mail. These have all been switched to dbmail in sql2005.
Maybe this link is worth a try: http://www.filehungry.com/english/product/windows_software/programming/database_tools/sql_clr
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply