January 4, 2002 at 5:21 am
Does anyone know anywhere I can read up on investigating/troubleshooting the exception.log file?
had a nice serverity 19 'language_exec:Process 13 generated an access violation.' error when a user ran a large query via a BI package.
Steven
January 4, 2002 at 3:28 pm
Do you mean the SQL Server Error Log? If so, the errors reported in it should be found in your Books Online.
Index tab >> errors-SQL Server
If you scroll down, the error numbers are listed.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
January 4, 2002 at 4:07 pm
Those are so crappy error descriptions. Not much better on technet, but you could try there.
Steve Jones
January 4, 2002 at 6:36 pm
I couldn't agree more. The error descriptions for ADO in general are likewise oh so fleshed out. We called Microsoft about one of those ADO error descriptions for an application and the tech person started listing about 15-16 things that could have caused it... none of which were really indicated by the error.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
January 7, 2002 at 1:44 am
I'll try Technet, and I looked in BOL prior to the orgional posting.
Brian,
Its both really, since the two do marry up. (the exception.log error file SQL puts into the logs directory when it has a problem) It sometimes contains additional info to the SQL error log, hence is one of the first places I look if I have a problem.
When the exception occurs about 1 mb of the query output was dumped into the Error log file.
This question is really for my piece of mind (and education), as the user just carried on and got the results he wanted.
The server in question is running SQL 7 SP2 and its a 13gb database, hence the returned recordset could have been a few rows.
Anyway back to technet
thanks for the info
Steven
Steven
January 7, 2002 at 9:45 am
Have you checked all the data for anomolies? Can you return the individual rows directly with a select?
Steve Jones
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply