Tech Support > Microsoft Windows > Windows CRM > KB article search replies with "No Article records available in this view"
KB article search replies with "No Article records available in this view"
Posted by Admin.Matthew@gmail.com on October 18th, 2005


I have seen this problem mentioned other places in these forums but the
"fixes" didn't work on our end. At first we got errors when running a
search but that was fixed by running the command:

use <database>
go
exec sp_fulltext_database 'enable'
go

After that we did a "Start Full Population". We do searches that should
show up results but we don't get any. We then did a rebuild to the
database. That didn't help as well. So we submitted and published a new
article and then did a search for it but got the same result "No
Article records available in this view". The KB articles work fine
otherwise but with our growing number of articles the search feature is
crucial. Any assistance would be greatly appreciated.

Posted by Admin Matt on October 18th, 2005


We found out what is going on. The DocumentIndex table is has NULL
instead of the KB Article information in most of the cells. Is there a
way to easily update this table with the correct information? Thanks.

Posted by Admin Matt on October 24th, 2005


According to Microsoft there is no fix for this type of situation.
We'll have to reenter all the KB Articles that don't appear in
DocumentIndex since the only time DocumentIndex is updated is when you
save a new article for the very first time.

Posted by ART@CT on November 24th, 2005


I have just entered articles which I cannot retrieve. So reentering the data
would appear to not solve this situation!
--
Cheers
Art


"Admin Matt" wrote: