Timeout on NT transferring data (AREV Specific)
At 15 JUN 1999 08:42:48PM Martin Kloosterman/Alec Lamberton, PSD wrote:
After investigation, it seems that if some queries are run on a NT machine ( in a SAW window or in a routine), the AREV session may terminate.
The problem occurrs when doing 'select into' a table involving 'group by'. It is possible it may occur on any query where data is not returned to AREV.
If the time taken is greater than about 10 min then the session will close with the error;
- 'RTP57' line 1. B114 Maximum number of variables exceded.
Irrespective of the AREV session dying on NT, the SQL table is created succesfully. The same query has been found to cause the session to die (if taking 11 min) or be OK (if taking 7 min). Thus amount of data is not an issue.
This problem has been tested on several (microsoft) NT servers with the same results. It has also been tested on windows 3.11 and windows 95 where there is no problem.
So from this the problem seems to lie either with the NT simulated DOS environment and/or a timout setting in NT.
Any help to resolve this problem would be greatly appreciated (if timeout where do I find the setting?)
At 20 JUN 1999 09:59AM Steve Smith wrote:
There are timeout parameters set from the NT registry
for the workstation connection, both on the server and
on the workstation. Disable these.
Also - is it the PC's power save feature cutting in?
Try the forcedos /d command (in the workstation help)
to see if this helps any.
Steve