I have a query that works in 5.11, the query basically FTSEARCHes for the query string and they places the results in a folder. When the same query is run in 6.5 I get the error:
“Maximum allowable documents exceeded for temp full text index.”
I am using: Call coll.FTSearch(qkey,0)
Can anyone help?
Thanks in advance and Happy holidays!!!
Subject: Maximum allowable exceeded for temp full text index?
You get this error with the ftsearch on line of code?
I wanted to give you a side note too – you are going to be limit to how many documents you can assign to a folder. In R5 I was not able to add any more documents after 93,000 to 95,0000 documents. (It seems to be vary from time to time.) So you may have a limit.
The other thing I wanted to warn is that having your search results put into a folder is only good if there is only one person using the db. If you are going to have more than one person, then you need to try to use another medium then a folder.
HTH – Cheers
Subject: RE: Maximum allowable exceeded for temp full text index?
Yes I get the error on that line of code.
Thank you for the side note though.
I can tell you what I have done is have the query agent build private folders for each individual who access the query piece, that enables more than one person to use the query at the same time without stepping on end results. Which also may be the result of the error in the 6.5 client.
Much thanks for your response.
Subject: Are you sure the db has a full text index on the new Server? And that it has been re-created since upgrading?
Subject: RE: Are you sure the db has a full text index on the new Server? And that it has been re-created since upgrading?
And we have a winner!!! I had just moved the database to the 6 server for testing and didn’t index the database (blonde moment).
Thank you very much!!!
Subject: As a blonde myself, I resemble that remark!