 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / December 2004Not getting any results back
Full text seach is working on my Development machine. I created a similar full text search catelog on my test machine.But I am not getting any results back.I chekced the event log..Every time it runs there are four warnings which says The message '-2147480624' for application 'Microsoft Search' could not be formatted using library(ies): ''. The log entry contains the following replacement strings:'SQLServer SQL0001800009' DataType is Byte[] Array ReplacementString: The specified procedure could not be found. I have a image filed type for one of the columns. Can you please give me some idea what it is about? It sounds like somehow your SQL FTS installation has not succeeded on your test machine. Can you register these components again using the following script? cd "C:\Program Files\Common Files\System\MSSearch\Bin\"%windir%\system32\Regsvr32 lcdetect.dll%windir%\system32\Regsvr32 mssadmin.dll%windir%\system32\Regsvr32 mssmmcsi.dll%windir%\system32\Regsvr32 mssws.dll%windir%\system32\Regsvr32 offfilt.dll%windir%\system32\Regsvr32 %WINDIR%\System32\athprxy.dll%windir%\system32\Regsvr32 ftsqlpar.dll%windir%\system32\Regsvr32 msscntrs.dll%windir%\system32\Regsvr32 mssmsg.dll%windir%\system32\Regsvr32 mssmulpi.dll%windir%\system32\Regsvr32 mssph.dll%windir%\system32\Regsvr32 mssrch.dll%windir%\system32\Regsvr32 msstools.dll%windir%\system32\Regsvr32 objcreat.dll%windir%\system32\Regsvr32 propdefs.dll%windir%\system32\Regsvr32 srchadm.dll%windir%\system32\Regsvr32 srchidx.dll%windir%\system32\Regsvr32 tquery.dll%windir%\system32\Regsvr32 %WINDIR%\Cluster\gathercl.dll%windir%\system32\Regsvr32 nlhtml.dllcd "C:\Program Files\Common Files\System\MSSearch\common\"%windir%\system32\Regsvr32 mssitlb.dll%windir%\system32\Regsvr32 %windir%\System32\athprxy.dllSome of these commands will generate error messages which you can safely ignore. > Full text seach is working on my Development machine. > I created a similar full text search catelog on my test machine.But I am not [quoted text clipped - 12 lines] > > Can you please give me some idea what it is about? That didn't help.The only difference I see between my development server and test server are those extra warnings in the event log of my test server. Every time the catalog is run..These four warnings are logged The message '-2147480624' for application 'Microsoft Search' could not be formatted using library(ies): ''. The log entry contains the following replacement strings:'SQLServer SQL0001800009' The message '-2147480612' for application 'Microsoft Search' could not be formatted using library(ies): ''. The log entry contains the following replacement strings:'MSSQL75://SQLServer/50679dfc', 'SQLServer SQL0001800009', '8007007f', 'The specified procedure could not be found. ' The message '-2147480624' for application 'Microsoft Search' could not be formatted using library(ies): ''. The log entry contains the following replacement strings:'SQLServer SQL0001800009' The message '-2147480612' for application 'Microsoft Search' could not be formatted using library(ies): ''. The log entry contains the following replacement strings:'MSSQL75://SQLServer/4e7f558a', 'SQLServer SQL0001800009', '8007007f', 'The specified procedure could not be found. ' Thank you > It sounds like somehow your SQL FTS installation has not succeeded on your > test machine. [quoted text clipped - 38 lines] > > > > Can you please give me some idea what it is about? Bruce, Were you reviewing the Application Event log remotely, i.e., not on the server where SQL Server 2000 with the MSSearch service resides? As this has less to do with the below message error numbers (-2147480624 or -2147480612) as they are related reading application event messages from un-known services. Is your test or development server in a clustered environment? The key error here is "Error: 8007007f - The specified procedure could not be found." and the two following KB articles may be appropriate to this problem, but the error reference in KB article Q304282 - "80070002 - The system cannot find the file specified" is close, but not exactly the same error (8007007f ). Reviewing past postings in this newsgroup, I found one with your error and a past poster suggested this can be resolved via re-running the SearchStp.exe program from SP3 file. Another suggestion was to change the (fulltext) dependency to the SQL Agent - in a clean install - this stops all errors from occurring. Below are the KB articles: Q304282 PRB: Full Text Resource Fails to Come Online on a Cluster with "Event ID 1069 : SQL Cluster Resource 'Full Text' failed" Error Message http://support.microsoft.com/default.aspx?scid=kb;en-us;304282&sd=tech 812666 How to recover a failed full-text search resource on a clustered instance of SQL Server 2000 http://support.microsoft.com/default.aspx?kbid=812666 You also said that you have an IMAGE file type for one of the columns, what is the exact datatype of this column? Char(3) or Varchar(4) or Sysname? Thanks, John  SignatureSQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ > That didn't help.The only difference I see between my development server and > test server are those extra warnings in the event log of my test server. [quoted text clipped - 63 lines] > > > > > > Can you please give me some idea what it is about? Thank you John.Running SearchStp.exe program from SP3 file helped. I appriciate your help. Bruce > Bruce, > Were you reviewing the Application Event log remotely, i.e., not on the [quoted text clipped - 108 lines] > > > > > > > > Can you please give me some idea what it is about? You're welcome, Bruce! It does help the troubleshooting effort when the error number and in this case the error message text is included! So, thank you for including the key error message text as that is what is important in troubleshooting FTS issues! John SignatureSQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ > Thank you John.Running SearchStp.exe program from SP3 file helped. > I appriciate your help. [quoted text clipped - 112 lines] > > > > > > > > > > Can you please give me some idea what it is about? Thank you for your help, John. > You're welcome, Bruce! > It does help the troubleshooting effort when the error number and in this [quoted text clipped - 142 lines] > > > > > > > > > > > > Can you please give me some idea what it is about? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.