oicgi memory access error (OpenInsight)
At 18 APR 2000 07:23:15AM Roger Bell wrote:
NT4.0sp6, OI3.7.2 with OI3.7.3 pre-release, Arev 3.12 on NetWare 5.0sp3
I have a routine that runs as the result of a query that has the option of returnng the rows as a CSV file. As long as I restrict the numbers of rows to less than a couple of hundred - no problem.
If I allow all rows found to be returned, the oicgi.exe fails with memory error oxc0000005. However the process initiated by the cgi keeps running and completes with the CVS file being generated correctly.
The oicgi failure is reported by the browser as bad headers. Subsequent calls can be made to the server without apparent ill effects. However, I restart the OI session because I can't tell for sure if anything is wrong.
The call to the cgi is made as server/oicgi.exe/inet_ecn_query2.
Inet_ecn_query2 simply processes the query and if the CSV option is set, generates a local file on the server which is returned to the browser for downloading. The file being generated has 31 columns and can contains upto 5000 rows. The failure does not appear to occur at a single point during the processing.
This operation isn't much different in which I generate and html file to be returned to the browser if the returned page would exceed 64k. I do restrict that to 100 rows and a note to tell the user to redefine the query.
At 18 APR 2000 09:58PM Stephen S. Revelation wrote:
Roger,
That could be a limitation of the browser. Have you tried IE and Netscape? Have you tried from a Win9x workstation? The current OICGI.EXE (OI v.3.73) has a limit of 64k (roughly, 3.72's was 32k), yet limitations in the browser may supercede this under some scenarios.
-Stephen
At 19 APR 2000 12:21PM Roger Bell wrote:
After re-reading my note, I realized that I left out some info.
The access is from Win9x stations via browsers. And yes, it fails for both IE and Netscape.
Why would the browser have an impact on OICGI.EXE? Especially the memory error that being produced. OICGI is still waiting for my routine to collect the results of the query, at least I think so, when it fails. The called routine keeps running to completion even after the "Dr. Watson" dialog showing the OICGI error is displayed and cleared.
I do use send_event to request that OICGI wait additional time before terminating but varying the time doesn't seem to help.
I'm aware of the ~64K limit and pass back an html file if the page being generated would exceed the limit. I don't seem to have a problem with that issue. The problem only appears when I attempt to generate a large (many rows) CSV file to be passed back to the user.
At 19 APR 2000 04:40PM WinWin/Revelation Support wrote:
This sounds like the same issue described by Cam Here
OI 3.73 pre-release fixed some of the oicgi problems, but left an issue where the inet_gateway window fills up if it's timer event never gets a chance to fire. The solution is to have the INET_SECURITY procedure clear out the gateway window when it starts to fill up.
Bob
At 24 APR 2000 06:43AM Roger Bell wrote:
Did that - results were the same. Just to make sure we're on the same wavelength:
oicgi version 3.7.3.1
I used in INET_SECURITY,
get_property('INET_GATEWAY.LB_LOG','LIST')
if len gt 20k then set_property('INET_GATEWAY.LB_LOG','LIST','')
which cleared the 'window'.
also tried at len of 10k
Was that correct?