Verity not indexing all records from query

[CFDaddio]

Hello, I'm running into an issue that I haven't encountered before.

I'm running a query against database, and then using CFINDEX to index the
results of the query. The problem is that the query is returning, say, 9
records. But when I do a basic search against the collection, I'm only getting
3 records. So, of the 9 records being returned from the database, Verity only
seems to be hanging onto 3 of them.

Here's the query code:

<cfquery name="getNewsForIndex" datasource="#datasourceLIVE#">
SELECT id, category_type, headlines, partial_story, full_story, date_live
FROM news_admin
</cfquery>

Here's the CFINDEX statement:

<cfindex collection="myCollection" action="update" type="custom"
query="getNewsForIndex" key="id" title="headlines"
body="headlines,partial_story,full_story" custom1="news"
custom2="category_type">

Does anyone have any idea why this might be happening? I've used this method
on several occasions before and never run into this issue.

Thanks.

Matt

[fgwenger]

What configuration and versions are you using? We are using Win2003, IIS and
CFMX7 Ent and I give CFINDEX a query with about 90000 records and it always
stops at 65520; every time and on a couple of different servers. It doesn't
give any kind of error, so we ran it like this for a few weeks before we
noticed it. My understanding was that CFMX7 Ent had a limit of 125K
documents, but this is almost exactly 64K. We don't have a solution as of yet.