"Bruce" <Bruce@discussions.microsoft.com> wrote in message
news:8AD6A7C9-DEC0-48A4-9DD8-ECB1BBBA00F9@microsoft.com...
> Thank you John.Running SearchStp.exe program from SP3 file helped.
> I appriciate your help.
> Bruce
>
> "John Kane" wrote:
>
> > 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
> > --
> > SQL Full Text Search Blog
> > http://spaces.msn.com/members/jtkane/
> >
> >
> >
> > "Bruce" <Bruce@discussions.microsoft.com> wrote in message
> > news:0A110A0A-0DF4-4BF4-8D56-EE9A6EEEC337@microsoft.com...
> > > 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
> > >
> > >
> > >
> > > "Hilary Cotter" wrote:
> > >
> > > > 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.
> > > >
> > > > "Bruce" <Bruce@discussions.microsoft.com> wrote in message
> > > > news:41CD0089-E98F-4907-8F6D-B6A3E6349DA0@microsoft.com...
> > > > > 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?
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >

"John Kane" wrote:

> 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
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
>
> "Bruce" <Bruce@discussions.microsoft.com> wrote in message
> news:8AD6A7C9-DEC0-48A4-9DD8-ECB1BBBA00F9@microsoft.com...
> > Thank you John.Running SearchStp.exe program from SP3 file helped.
> > I appriciate your help.
> > Bruce
> >
> > "John Kane" wrote:
> >
> > > 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
> > > --
> > > SQL Full Text Search Blog
> > > http://spaces.msn.com/members/jtkane/
> > >
> > >
> > >
> > > "Bruce" <Bruce@discussions.microsoft.com> wrote in message
> > > news:0A110A0A-0DF4-4BF4-8D56-EE9A6EEEC337@microsoft.com...
> > > > 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
> > > >
> > > >
> > > >
> > > > "Hilary Cotter" wrote:
> > > >
> > > > > 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.
> > > > >
> > > > > "Bruce" <Bruce@discussions.microsoft.com> wrote in message
> > > > > news:41CD0089-E98F-4907-8F6D-B6A3E6349DA0@microsoft.com...
> > > > > > 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?
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>