Fatal error 7102

  • We got Fatal error 7102 today. The only reference we find for this error is on the microsoft site at the following link:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246775.

    The query that caused this error uses NOLOCK but doesn't use a cursor and in any case the above reference indicates it was fixed in SP 2.

    I know we are running SP 3 on our clustered SQL Servers and I thought the SP's were cumulative. Or could the bug have resurfaced in SP 3?

    Robert Marda

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • Did you check the logs both SQL and Event Viewer in NT/2000 to see if any more details are available. I have gotten odd fatal errors in the past (mostly with tempdb) that really were nothing and I cannot remember if they generate stack dumps. And yes Microsoft may have inadvertently revisioned an old file in, happen in an early release of a SP for visual studio where the revisioned a file wrong but they removed and replaced the SP within days of being made aware the problem was back. If you find no answer and it happens again contact Microsoft.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • The event viewer log doesn't help much. And we had already viewed the SQL Server logs, they don't help either.

    Robert Marda

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • That's what I thought, problem is I find nothing else about it when I search the web. The only way to know for sure is rerun the items that were involved at the time to see if can duplicate. If you can then run Profiler against the server will running those items and see if anything odd happens. I have seen serveral SQL 7 metadata issues and this could just be another. Or if you have the code it failed on and want to post I can take a look and see if I can reproduce here at the house on a test copy of SQL server.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply