[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== String Line Errors (AREV Specific) ====
=== At 06 JAN 1999 06:31:38PM Art Solomon wrote: ===
{{tag>"AREV Specific"}}
First, a tip of the hat to the sysops that keep this running!
Now...
We've got 100 users running an AREV 2.12 app that are constantly getting "String Line Errors". Environment is NW3.12 patched to D (ptd) level. Workstations are Win95b (qfecheck ver. 4.00.1111 b)running Intranetware client 2.2. Client Hardware is all over the place, from four year old home built K-90's & 486's (about 50%), noname P166-233's, a couple of new Acer Power NetPC's, and a couple of new Compaq PII DeskPro EN's. We also have a dedicated indexer running Win95's command prompt (BOOTGUI=0)
I've got all the settings recommended here (frame type, emm386 /auto, not shadowing ROM, no power saving, True Committ on, don't cache writes, etc., etc). None of this has helped.
I checked low DOS box memory on various machines using a DOS PROMPT pif set as follows: all auto except EMS, set to 4096. It ranges from 518k to 595k. It seems like the machines with the least low DOS memory have the most trouble with string line errors, while the ones up around 585k on up don't have problems.
The AREV app we're running contains well over 500,000 parent records. The app and data take about 2GB of disk space. It has been in use since 1992.
1. Am I correct in assuming that this lack of low memory could be the source of problems? If so, would memory mgt software such as QEMM or another package improve the situation? Or is there a better solution?
2. I was told that AREV has a "string space" (sorry about the misnomer) maximum of 64k. Is it possible for AREV to try display more data that it's limit? There are times when a user has multiple screens displayed, each with much data.
3. I don't know much about AREV, but with some other non-linear-hash databases, you have to rebuild them. This has never happened to my knowledge. The primary indexes only get rebuilt when we see obvious errors on the indexer, i.e. rarely. Should they get rebuilt more often? Is there a maintenance routine we should be doing on a scheduled basis?
Thanks in advance...
----
=== At 07 JAN 1999 04:38AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Ltd[/url] wrote: ===
OK Art several quesions, but to summarise
1) The error message you report is a little unclear but it'll either be a string space format error or something like that. VERY likely to be caused by low string space. Ensure everything that can be is loaded high, see the difference in string space by loading with (/X /M4096) and without (/O) expanded memory support. Type WHO at TCL to see the string space available. Aim for ] 250K.
2)AREV uses a finite amount of string space - reported as above. More you load the less string space you have.
3)Linear hash is self optimising so requires little maintenance. You should consider running LH_VERIFY, VERIFYLH or whatever on a monthly basis until you're happy, then run quarterly.
amcauley@sprezzatura.com
[url=http://www.sprezzatura.com" ]Sprezzatura Ltd[/url]
[i]World Leaders in all things RevSoft[/i]
[img]http://www.sprezzatura.com/zz.gif[/img]
----
=== At 07 JAN 1999 03:03PM Steve Smith wrote: ===
Art,
-The limit to any variable is 64 kB
-the string space is typically 250 kB without expanded memory active -string space is 300 kB+ with Expanded memory active
-you should have 585 kB of memory free below 640 kB to run AREV
-always run AREV with the /XM4096 switch.
Under Win 95, it is the shortcut memory which is supplied to the application. You should get around 600 kB if you use HIMEM.SYS and EMM386.EXE in config.sys, then DOS=HIGH,UMB.
If you use the DOS based Novell VLM.EXE then explore the use of the /X parameter to load this high.
IPXODI /AD can be used if there is no RPRINTER.EXE on the workstation.
If you post your config.sys and autoexec.bat and mem /c readouts from the troubled workstations here (or via email) I will look at whether you can squeeze more memory out of your configuration.
Steve
stsm@ozemail.com.au
----
=== At 07 JAN 1999 03:03PM Steve Smith wrote: ===
Art,
-The limit to any variable is 64 kB
-the string space is typically 250 kB without expanded memory active -string space is 300 kB+ with Expanded memory active
-you should have 585 kB of memory free below 640 kB to run AREV
-always run AREV with the /XM4096 switch.
Under Win 95, it is the shortcut memory which is supplied to the application. You should get around 600 kB if you use HIMEM.SYS and EMM386.EXE in config.sys, then DOS=HIGH,UMB.
If you use the DOS based Novell VLM.EXE then explore the use of the /X parameter to load this high.
IPXODI /AD can be used if there is no RPRINTER.EXE on the workstation.
If you post your config.sys and autoexec.bat and mem /c readouts from the troubled workstations here (or via email) I will look at whether you can squeeze more memory out of your configuration.
Steve
stsm@ozemail.com.au
----
=== At 07 JAN 1999 05:41PM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url] wrote: ===
If you're loading VLM's or NETX under Win95, you might want to set LoadTop=1 in your MSDOS.SYS file.
akaplan@sprezzatura.com
[url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url]
[img]http://www.sprezzatura.com/zz.jpg[/img]
----
=== At 08 JAN 1999 11:22AM Art Solomon wrote: ===
Thanks to Andrew McCauly, Aaron Kaplan and Steve Smith.
Config.sys on all machines:
files=125 (suspenders and a belt)
buffers=60 or 30 (I've tried both, I know the buffers take low memory, but not much)
device=c:\windows\himem.sys
device=c:\windodws\emm386.exe /auto (or nothing)
dos=high,umb (on some. Weather or not I use it, dos box loads dos high)
Autoexec.bat:
@c:\progra~1\norton~1\navdx.exe /startup
MEM readout from machine that doesn't have problems often:
(Winver 4.00.1212 b) all loaded low
MSDOS 33840
HIMEM 1168
EMM386 9856
IFSHLP 2864
setver 832
VMM32 not loaded (?)
WIN 3680
COMMAND 7408
-------------
FREE 580,352
MS-DOS resident high, no free UMB's
Machine with constant problems Winver 4.00.1111b, all loaded low:
MSDOS 79296 (2x+ as much loaded!)
HIMEM 1168
EMM386 9856
DBLBUFF 2448
IFSHLP 2864
SETVER 832
WIN 3696
vmm32 22800 (why lower case?)
COMMAND 7552
DOSKEY 4688
-------------
FREE 519,904K
MS-DOS resident high, no free UMB's
WHO from problem machine:
Avail. Memory 211,740 (uh-oh)
Descriptors Used 2,751
EM Used 314,368
EM Allocated 4,194,304
Expanded Memory Active
16k EM Window CC00 (816K)
64K Overflow Buffer 1 D800 (864k)
64K Overflow Buffer 2 2BA3 (175K)
I rebuilt a newer machine yesterday. When I had MS Client for NW on it, DOS Box low memory was 605k. Then loaded INC Client32 2.2 & low memory dropped to 519k. MSDOS loaded low reading from mem went from about 32k to 79k. In other words, I'm already using all UMB's. LoadTop in MSDOS.SYS would still be feasible, right?
Also, INC32 Adv Settings changed are: Cache Writes off, True Commit on, Delay Writes off, NW Protocol BIND NDS. We're using Enhanced mode (32 bit and 16 bit) NDIS driver in the card settings, so I don't think we're using either (but whaddo I know).
Thanks again for the input,
Art Solomon
----
=== At 08 JAN 1999 11:31AM Art Solomon wrote: ===
The error message I'm getting is:
'RPT57A' Line 532. B28 Not enough string space - Out of Memory
----
=== At 08 JAN 1999 08:05PM ed wrote: ===
Just for info purposes. I have not had problems with thefollowing configuration except when doing some Btree index lookups that use the format WITH DATE GE "1/1/97" AND WITH DATE LE "1/1/98". When I change
the format to WITH DATE BETWEEN "1/1/97" AND "1/1/98" solves the problem. I can only assume the two different statements perform the select differently.
I am running a homebuilt pc using win95a with novel client32 v2.2. I am running standard tcp/ip &ipx protocol stacks.
I am connecting to a novel 3.12 server. Here is the info from the who
window
Release Version = 2.1
User name =
Account name = SYSPROG
Restriction level =
Active Language Set = DEFAULT
CPU Type = 80386
Math processor = 80387
Available memory = 328828
Descriptors used = 1583
Expanded Memory = Inactive
NETWORK INFORMATION
Vendor/Type = ADVANCED NETWARE 2.0 Drv. 2.1
Maximum users = 4
As you can see I have over 328K of low memory and I am not using expanded memory. hope this helps
----
=== At 09 JAN 1999 10:53AM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url] wrote: ===
You should read the [url=http://www.revelation.com/WEBSITE/knowledge.nsf/a8d98a7758d871298525651c004e6987/3c57c588ce21daf9852563920051f70b?OpenDocument]Advanced Revelation FAQ[/url] and maybe download the [url=http://www.revelation.com/WEBSITE/knowledge.nsf/a8d98a7758d871298525651c004e6987/5f5a912c54051f8a8525638400549a7e?OpenDocument]Windows 95 shortcut[/url].
akaplan@sprezzatura.com
[url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url]
[img]http://www.sprezzatura.com/zz.jpg[/img]
----
=== At 11 JAN 1999 01:56PM Art Solomon wrote: ===
Thanks again, guys.
Got the FAQ and PIF a while ago. While the PIF recommends loading LHIPXTSR from the "batch file" line in the PIF, I've also seen it recommended (on my BOOST app's web site)that all can be loaded from a batch file. I like loading LHIPXTSR from the PIF, more appros for Win95, but I'm overruled.
Anyway the batch file is:
c:
cd\arev (verbatim, no space???)
lhipxtsr.exe /p
g:
cd\boost (just tried "cd\system" from my WinDir, bombed, could this be a problem with no path statement in autoexec? I know I'm grabbing at straws)
arev BOOST.COLLECTOR /M4096(S)
C:
cd\arev
lhipxtsr/u
----
=== At 12 JAN 1999 02:38PM Victor Engel wrote: ===
Either will work. I like doing it from a batch file, because then that same batch file can be used for all platforms. The /P option is not needed for a DOS system, but it doesn't hurt, either.
----
=== At 24 FEB 1999 02:37PM Art Solomon wrote: ===
No more string line errors!! Just want to say thanks (big time!) to Steve Smith and Spetazurra (which I probably spelled wrong). We've been using AREV for at least 5 yrs. The guy who set up our network is a CNE. The staff AREV programmer has been writing AREV for at least seven years that I know of.
And there by the grace of God go I. I am neither a CNE or much of an AREV programmer. I've been working with this situation for 11 months. When I finally disregarded my boss's (the AREV programmer) warnings about changing the startup switches, and added the X to the startup switches, we went from Expanded Memory being unavailable to ~559K being available. Haven't had problem one since. This board is the greatest!
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=DCA2D0B0BD40B277852566F100813D7E|View this thread on the forum...]]