RH7 WebHelp Pro Index not working when viewed from RH Server 8

[pjv]

I've got a RH7 project that was published to RH Server 8 using the default Access database. When I view the project from the server, the Index, which is 444kb, dies. The 1st 20-30 keywords and subkeywords display in the index panel. When I try to search on a keyword, nothing happens. If I use the scroll bar to move down, a message "Loading Index..." displays but nothing happens -- waited over an hour but nothing moved. When I open the same project on my local drive, the Index works just fine.

I spoke to Adobe support and they said to try a sample project. Well, I did and an index of about 104-140kb worked fine on the server. However, as it got up to 140kb, I started to see the Loading Index... message but it flashed by quickly and I was still able to search by keyword.  Then I built the index up to 190kb and the same problem that occured in my larger project happened.

Is there a maximum Index size that is allowed when your project is published to the Access database?  There's no RH Server 8 documentation regarding maximum sizes for the Access database so I'm really annoyed. 

[pjv]

Sub-comment to my original posting. We're also having the problem with Apache Tomcat stopping and starting.  I've forwarded the 2 discussions regarding how to adjust the size to my tech support person. So this might be an issue with the Apache Tomcat and the fact that we're using the default Access database.  I'm attaching the Tomcat log from 12/08/09 if that helps.

[tuls_garg]

Hi Paula,

Did you try increasing java heap space and perm space?

Tulika.

[RoboColum_n_]

Although this is not documented it is widely accepted that running on an MS Access database is not great for a production environment. We too have suffered the "loading" index although it does seem to be intermittent. We will probably go over to using SQL Server instead before go live.

---

• Read the RoboColum(n) for a tips, tricks and musings on the Technical Communication Suite products.
• Follow the RoboColum(n) on Twitter

[tuls_garg]

Hi Colum,

If you do face "Loading index" issue again, do share your tomcat logs with me. May be we can figure out something from them.

Tulika.

[pjv]

Thanks. I did forward the other 2 postings regarding increasing the java heap space and perm space to my tech support guy. He's going to look into it.

However, I've got another concern that I'm seeing errors in the Tomcat log that of course I don't understand what they mean. Can you please take a look at the 2 logs that I've attached to this message and let me know if I need to be concerned. I sent one of them before but obviously no one looked at it.

[tuls_garg]

Hi Paula,

I did see the logs you attached earlier but they didn't reveal anything relevant. You should have attached stdout logs earlier as they contain more vital information. Anyways, I shall go through your stdout logs whenever I find some time and get back to you.

Tulika.