473,554 Members | 3,008 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Patch for KB948110 causing random "Could not find database table ID"errors

Running MSDE 2000 SP2 on Windows XP SP3.

I have a T-SQL script that is relatively simple (adding constraints,
inserting rows, etc.) and short (maybe 300 lines, heavily commented).
It's an upgrade script I wrote weeks ago, and has worked fine
everywhere.

After the patch from last Wednesday. "Security Update for SQL Server
2000 Service Pack 4 (KB948110)", I have gotten the following error on
two different machines, using a copy of the script from our source
control that is known to be many weeks old, and to have worked:

Server: Msg 615, Level 21, State 1, Line 1
Could not find database table ID 8, name 'MyDatabase'.

The script gets this error about 75% of the time - and sometimes it
runs fine. When it fails, I cannot locate the exact line of code - it
seems to be random. I've never seen this error message before, and
Google Groups has no hits for "Could not find database table ID".
Google Web has about 15 hits, all of which seem unrelated.

Googling for "KB948110" has led to a handful of people having various
problems with this patch, but not mine. I did notice someone complain
that the patch had been applied to SQL Server 2000 SP3 database when
it should not have. This made me realize that this SP4 patch had been
applied to my MSDE 2000 SP2 database, which I assume it should not
have.

Uninstalling the patch fixed the problem. Interestingly, re-
installing the patch did not bring back the error message.

Some interesting links:

http://support.microsoft.com/default...b;en-us;224071
http://simultaneouspancakes.com/Less...nd-sharepoint/
http://blogs.technet.com/sbs/archive...3-servers.aspx

Anyone else seeing this? Anyone know if Microsoft aware of it?
Thanks.
Jul 12 '08 #1
3 6004
Larry Leonard (La***@definiti vesolutions.com ) writes:
Googling for "KB948110" has led to a handful of people having various
problems with this patch, but not mine. I did notice someone complain
that the patch had been applied to SQL Server 2000 SP3 database when
it should not have. This made me realize that this SP4 patch had been
applied to my MSDE 2000 SP2 database, which I assume it should not
have.
It sounds scary that the hotfix installed despite that you were only on SP2.
Then again, the download pages says "Security Update for SQL Server 2000
Service Pack 4 and MSDE 2000" without any service pack indication for
MSDE. Yet, then again, I don't get less scared if this really means that
the hotfix would install itself on MSDE 2000 RTM if it got the chance.
Uninstalling the patch fixed the problem. Interestingly, re-
installing the patch did not bring back the error message.
You didn't consider installing SP4 while you were at it? :-)

I don't know exactly what is in this hotfix, but SP3 (and SP4 of course)
includes the fix for the Slammer worm, which is far bigger threat than
the issues addressed by this hotfix. And that vulnerability was not in
the engine itself, so may still not have that protection. (Unless you
have previously installed the hotfix for SP2 for Slammer.)

As for the error message, the condition is gone, so it's not easy to
repeat and examine, so I guess that all you can do is to chalk up one
more for the green man in the machine. :-)

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jul 12 '08 #2
It sounds scary that the hotfix installed despite that you were only on SP2.
Then again, the download pages says "Security Update for SQL Server 2000
Service Pack 4 and MSDE 2000" without any service pack indication for
MSDE.
Well, I finally discovered it has nothing to do with the MS patch – I
“ghosted” an image from April that fails the exact same way.
You didn't consider installing SP4 while you were at it? :-)
If I could move up to SP4, you think I'd still be using 2000 at
all? :-)
As for the error message, the condition is gone, so it's not easy to
repeat and examine, so I guess that all you can do is to chalk up one
more for the green man in the machine. :-)
It's easy to repeat now: it’s happening on five machines, each with
their own MSDE database. I finally tracked it down to the USE
command: these two lines, believe it or not, give me the “Could not
find database table ID #, name 'x'” error:

USE MyDatabase
DECLARE @X INT

Fortunately, I can re-write my short script to use the
database.dbo.ta ble syntax.

This ( http://www.eggheadcafe.com/software/...base-name.aspx
) is exactly what I’m experiencing, but all our collations are set to
the default of LATIN1_GENERAL_ CP1_CI_AS, so I don’t think it’s a
collation problem.

I wonder if something’s gang agley in the master database? When I say
“SELECT name FROM sysdatabases”, I see all my databases, so why
doesn’t USE see them? How hard is it to rebuild master?
Jul 18 '08 #3
Larry Leonard (La************ ***@gmail.com) writes:
>It sounds scary that the hotfix installed despite that you were only on
SP2. Then again, the download pages says "Security Update for SQL
Server 2000 Service Pack 4 and MSDE 2000" without any service pack
indication for MSDE.

Well, I finally discovered it has nothing to do with the MS patch – I
"ghosted" an image from April that fails the exact same way.
If I understand this right, you get this error on MSDE 2000 SP2, without
the security fix as well?
This ( http://www.eggheadcafe.com/software/...base-name.aspx
) is exactly what I'm experiencing, but all our collations are set to
the default of LATIN1_GENERAL_ CP1_CI_AS, so I don't think it's a
collation problem.
I cannot see any connection between your error and that link. When I think
of it, the error message is:

Server: Msg 615, Level 21, State 1, Line 1
Could not find database table ID 8, name 'MyDatabase'.

Database table 8 is sysfiles1. Let's see, is the database set to auto-close?
If it is, SQL Server would have to open it, and to find all files, in
needs to look in one of sysfiles and sysfiles1, to find any secondary
files.

Notice that the severity of the level is 21, which is a very high level.
Books Online says:

Severity Level 21: SQL Server Fatal Error in Database (dbid) Processes

These messages indicate that you have encountered a problem that
affects all processes in the current database; however, it is unlikely
that the database itself has been damaged.

So this is an error that "should not occur". I would suspect a bug that
thrashes an internal memory or somesuch.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jul 18 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
6712
by: Don Isgitt | last post by:
Environment: Server running Redhat 3.2.3-20 on quad Xeon 2.4 Postgresql 7.4 compiled from source (gcc 3.2.3) Application written in Perl (5.8.0) using Tk, DBI and DBD Client accessing DB using ODBC (7.03.02) from Win XP box Sample of errors follows: 2004-04-26 10:15:38 LOG: 00000: connection authorized: user=djisgitt database=gds2
4
2313
by: jim | last post by:
I'm trying to import a 625MB, tab-delimited .txt file into Access, but I keep receiving the following error after several minutes of what seem to be noble attempts by Access to render the data: The Microsoft Jet database engine could not find the object ". make sure the object exists and that you spell its name and path name correctly. ...
4
6928
by: lawrence k | last post by:
I've a jpeg image that is 514k, which doesn't strike me as very large. Yet I'm running out of error when I try to resize it: Fatal error: Allowed memory size of 20971520 bytes exhausted (tried to allocate 12288 bytes) in /home/httpd/vhosts/monkeyclaus.org/httpdocs/media/audio/pdsIncludes/resizeImageToSquare.php on line 82 How can I...
2
4198
by: dave | last post by:
Hi, I have searched for the answer for this error message without success. I have seen the question many times though:) I create an ASP.NET project (VS 2005, C#), and use a very simple .mdf file (which I can provide if necessary). I use 'Add new Item' and pick 'DataSet'. I believe this creates a TypedDataSet, CORRECT? I take all the...
3
1688
by: Twanne | last post by:
Hi, I've got a table called Aerosol and a table called LinkTabel. Now I do an update to a table from an excell sheet, this table is called ExportAerosol. So far so good, the import works perfect. Now when I want to transfer the data from the ExportAerosol table to the Aerosol table I have to make a unique key. I do this by adding a...
0
4183
by: rangi500 | last post by:
Hello, We've recently started getting errors like this: Last error: ERROR: could not write to hash-join temporary file: No space left on device But there is plenty of space on the all the drives. Does anyone know what might be causing this?
11
4997
by: fniles | last post by:
One of our application uses VB6 and Access97 database. Another application uses VB.NET 2005. This morning for about 15 seconds when the application tries to read either a query or a table from the database, in in both VB6 and VB.NET applications, I got the error "The Microsoft Jet database engine cannot find the input table or query...
0
1673
by: Chuckk Hubbard | last post by:
The docs say to try to discover the URI on my own if this happens. Could I get a hand doing that? This isn't just something I want to solve on my machine, e.g. by changing my network setup or what not; this is a program I hope to distribute and I hope my users can avoid having to deal with this, because I suspect they won't. Thankye. ...
0
2366
by: Chuckk Hubbard | last post by:
OK, I think I have it. The Manual says to start a Name Server "using the ns command", and I figured out that means using the pyro-ns script. On Mon, Nov 10, 2008 at 10:49 AM, Chuckk Hubbard <badmuthahubbard@gmail.comwrote: --
0
7596
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7519
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8039
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7887
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5431
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5152
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
2015
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1130
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
838
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.