Queries Truncated possibly due to License Issue

[tagrobicki]

The symptom we are getting is that all query results are being truncated to 10
records after some period of time. The server starts out fine, but then when
more than a few people start to use it, we see this happening (we have a test
page that compares count(*) with the recordcount of a select *). This used to
be a CF7 Enterprise Devnet server, but we uninstalled that version (including
all the manual cleanup steps outlined in a KB article), and then installed a
CF7 standard license. This happens with the standard install and also after
apply all the hotfixes, so it doesn't seem to be related to that. It is as if
some part of the DevNet licensing mechanism is lingering. Everything else seems
to work ok (no watermarks on charts or reports), it says the license is ok, a
subnet scan says the server is licensed, nothing in the logs.

[SafariTECH]

Nothing license related controls your query returns.

Check for cached queries, maxrow settings on queries, licensing for the DB
product you are using (that's where the restriction may be if license related)
and the general code making and displaying your query results.

[tagrobicki]

We are not using cached queries, maxrow, and we are not having any issues with
DB licensing. The same CF application worked fine with CFMX 6.1 Standard which
used to run on this server. We upgraded the machine to CF7 Enterprise DEVNET to
try out some of its advanced features, and then upgraded to CFMX 7 standard
(after removing the CF7 Enterprise cleanly). The application will work fine
until at some point is starts returning back a maximum of 10 records for all
queries. The queries we are using to test for this are:

select * from employees

and

select count(*) as x from employees

We then compare the value of x with the recordcount. They do not match. It
sounds like you are saying there are no restrictions associated with licensing
and queries. Perhaps we are dealing with a JDBC driver bug. We do lots of CF
development (since 1996) and I've never seen anything like this.

[tagrobicki]

Just a bit of added information regarding the record limit. The problem never
occurred with CF6.1 Standard on the same server, same db, etc. I can clear the
record limit problem by restarting the Windows Service "ColdFusion MX 7
Application Server". I've created a test page that when it detects the record
truncation is happening in CF calls a 'C' program that does the exact same
database read. That program never encounters record limits. The limit appears
to be 10 records. It does appear to be triggered by the number of users, and
eventually database reads seem to recover after the system has been idle for a
while.