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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
