Hummingbird has a UI where you can go in and unprotect and delete the tables if needed and then the rebuild should be able to build the entire index over from scratch. The URL is typically http://<server>:8666/ssadmin Alan BlakeKnowlysis
--- On Thu, 4/1/10, Warren Baltimore <[email protected]> wrote: From: Warren Baltimore <[email protected]> Subject: KMX problems To: [email protected] Date: Thursday, April 1, 2010, 3:47 PM ** Folks, I am blindly trying to fix a problem with my Knowledge base. First off... KB is running on a Windows 2000 server. It is KMX 5.4 (I think). Running on Hummingbird 5.4. It's normally very quiet and I don't need to do anything, but.... I followed the instructions to update the indexes (Killed KMS Indexing Service and IIS). Ran the Update scripts Brought everything back and....My helpdesk complained that it was even worse! They were right. The thing was fried. So, I ran kms_Rebuild.bat. This seemed to clean things up BUT none of the published KB's are available! I went back and took a look, and whenever the Published index attempts to build, it comes back with an error: C:\Program Files\ar system\apps\kms\bin\Indexing>execsql c:\progra~1\arsyst~1\ap ps\kms\bin\indexing\up.txt validate index published validate table; execsql: execute failed SQLSTATE: 80913, Native error: 0, error text [Hummingbird][SearchServer]Table is protected *** C:\Program Files\ar system\apps\kms\bin\Indexing>pause Press any key to continue . . .Now, I've tried everything I can think of but no luck. I have even tried adding "unprotect table Published;" to the Update_Published.bat script without any luck. The other update scripts run fine. Just not the published.... -- Warren R. Baltimore II Remedy Developer 410-533-5367 _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
