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,
<<NetDyn.log>>
-----------------------------------------------------------------
Anil Kumar Khadloya,
Senior Software Engineer,
IT Solutions (India) Private Limited,
Mail me @ [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
NetDyn.log
