Hi,
To start with, I work on NetDynamics 3.11, Oracle 7.3.3.4.1
forming
the back end
I've got a report page in which the user has to select the
records,
from a list box, for which report has to be generated. After selecting
the
records and on click of the button, a new page is thrown with the
description about all the selected items ( a HTML table ) . This works
fine
as long as the selected items doesn't exceed 700. When the user selects
more than 700 records I get the following error
Content-type: text/html Could not receive a response from the
NetDynamics
Application Server.
Please contact the system administrator of this site for assistance.
To visit the NetDynamics Web site or participate in the online customer
forum, click here.
Initially I thought it might be because of the lengthy WHERE clause in
the
SELECT query. Hence I included an option where in the user can either
select
all the records ( 1156 records ) or less than 500 so that in the first
case
wherein user selects all the records I don't include any WHERE criteria
in
the SELECT query. But still I get the same error. If I execute the query
in
SQL prompt it executes in less than 5 seconds. When I check the log
file I
find the following message.
06/19/99 16:44.37 (114 78000029 929790877862) [javaCP] (H)
CSpZephyr.receiveMessage: 'WEB_EVENT'
06/19/99 16:49.38 (120 7800002a 929791178274) [ndCGI] (E) Select failed
in
socket call for read.
06/19/99 16:51.56 (114 7800002a 929791316403) [javaCP] (E)
CSpUtil.putIndexedElement: Too many indexed values (more than 1000 ?!?)
The last line "[javaCP] (E) CSpUtil.putIndexedElement: Too many indexed
values (more than 1000 ?!?)" repeats for about 150 times in the
NetDyn.log
file.
I'm also attaching the NetDyn.log file with this mail.
Any help will be appreciated.
Thanks in advance,
Regards,
A.Velmurugan.
NetDyn.log
