OLE/DB Error: The object was not found.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

OLE/DB Error: The object was not found.

Author

Topic

redbrad0
Posting Yak Master

176 Posts

Posted - 2005-05-19 : 15:50:02

All scripts run fine, but once in awhile I get a email about the following error message...

Category: Microsoft OLE DB Provider for ODBC Drivers
Number: (0x80040E14)
Description: [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: The object was not found. ]
File: /default.asp
Line: 525

Sometimes it is on different line numbers, but the object's (SP
's) are in the database and I can not figure out what would be causing this error when it works most of the time, but just not all of the time. Anyone have any ideas?

Quality NT Web Hosting & Design

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-05-19 : 15:56:29

Could you post the source of this error?

Tara

redbrad0
Posting Yak Master

176 Posts

Posted - 2005-05-19 : 17:41:49

It is ASP code and line 525 is in red


tempSQLString = BuildSearchQuery(dbUserTaskRSSKeywords, tempArticlesToReturn, tempJobFilters)
set rs = my_Conn.Execute (tempSQLString)

The BuildSearchQuery is a pretty long function but the output looks like below but is built on the fly... not sure the best way to format the below query so i will just paste it...

SELECT TOP 10 Data.Data_ID, Data.Data_FeedID, Data.Data_Title, Data.Data_Link, Data.Data_Desc, Data.Data_DateCreated, WEIGHT.RANK AS RSSFeedRanking FROM dbo.RSS_Feeds_Data Data INNER JOIN CONTAINSTABLE(dbo.RSS_Feeds_Data, *, 'ISABOUT ("pop up booths" weight (1.0), "pop up" NEAR "booths" weight (0.9), "pop" NEAR "up booths" weight (0.9), "tradeshow exhibits" weight (1.0), "tradeshow" NEAR "exhibits" weight (0.9), "exhibit booths" weight (1.0), "exhibit" NEAR "booths" weight (0.9), "trade show" weight (1.0), "trade" NEAR "show" weight (0.9), "tradeshow" weight (1.0), "pop booths" weight (1.0), "pop" NEAR "booths" weight (0.9), "tradeshow exhibits" weight (1.0), "tradeshow" NEAR "exhibits" weight (0.9), "exhibit booths" weight (1.0), "exhibit" NEAR "booths" weight (0.9), "trade show" weight (1.0), "trade" NEAR "show" weight (0.9), "tradeshow" weight (1.0), "pop" weight (0.0), "booths" weight (0.0), "tradeshow" weight (0.0), "exhibits" weight (0.0), "exhibit" weight (0.0), "booths" weight (0.0), "trade" weight (0.0), "show" weight (0.0))') WEIGHT ON Data.Data_ID = WEIGHT.[KEY] ORDER BY RSSFeedRanking DESC

Quality NT Web Hosting & Design

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-05-19 : 17:43:30

I'm not familiar with full-text, so can't help you out with the query. Hopefully someone else can though.

Tara

redbrad0
Posting Yak Master

176 Posts

Posted - 2005-05-19 : 18:14:29

Its just so odd because it works maybe 95% of the time... then the other 5% I get an error.

Quality NT Web Hosting & Design

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-05-19 : 20:43:29

Does it seem to happen at a particular time (for example, when you are rebuilding the full-text indexes). Also, is there any error in the SQL Server error logs during this time?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

redbrad0
Posting Yak Master

176 Posts

Posted - 2005-05-24 : 09:34:03

Sorry for taking so long to respond... I went to the Event viewer and couldnt not find anything and in SQL Server I went to Management --> SQL Server Logs and everything is showing 5/18/05 and no dates past that. Could I of turned of SQL Server Logs?

I did find this MS Support URL which is talking about BizTalk Configuration and says ...

quote:

Cause
This problem can occur if your Microsoft SQL Server computer has been configured with a binary sort order and you query for an object using the correct name, but you do not use the proper case.

resolution
If your SQL Server computer is configured with a binary sort order, you must query the BizTalk Management Objects by using the exact case.

It just seems very odd because the query runs 90% of the time just fine.

Quality NT Web Hosting & Design

redbrad0
Posting Yak Master

176 Posts

Posted - 2005-05-25 : 15:46:09

I deleted and rebuilt my entire Full Text Catalog and then quit getting this error message. A few days later (just now) I started getting this error message again. Anyone have any ideas?

Quality NT Web Hosting & Design

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources