Title: | FOCUS, from INFORMATION BUILDERS |
Moderator: | ZAYIUS::BROUILLETTE |
Created: | Thu Feb 19 1987 |
Last Modified: | Mon May 05 1997 |
Last Successful Update: | Fri Jun 06 1997 |
Number of topics: | 615 |
Total number of notes: | 1779 |
Environment: FOCUS 6.1, VMS 5.4-2, Rdb 4.0 I am getting the following error in a FOCUS procedure when trying reporting on an Rdb database. ERROR AT OR NEAR LINE 72 IN PROCEDURE DISK$USERS1:[UWINS.OA]IWTEST.FEX (FOC206) INSUFFICIENT MEMORY SPACE IS AVAILABLE FOR LOADING PROGRAM BYPASSING TO END OF COMMAND The focus user manual (appendix A) says :- FOC206 ...Define larger storage and retry. Can anybody explain what needs to be increased. These are the current process quotas. I have decreased WSEXT from 32000 and increased ENQLM to 20000 and the report still fails. Flags: Primary days: Mon Tue Wed Thu Fri Secondary days: Sat Sun No access restrictions Expiration: 2-FEB-2000 00:00 Pwdminimum: 15 Login Fails: 0 Pwdlifetime: 30 00:00 Pwdchange: 11-MAY-1992 13:53 Last Login: 20-MAY-1992 10:26 (interactive), 20-MAY-1992 07:30 (non-interactive) Maxjobs: 0 Fillm: 300 Bytlm: 100000 Maxacctjobs: 0 Shrfillm: 0 Pbytlm: 0 Maxdetach: 0 BIOlm: 150 JTquota: 5000 Prclm: 6 DIOlm: 150 WSdef: 1024 Prio: 4 ASTlm: 160 WSquo: 2048 Queprio: 0 TQElm: 246 WSextent: 16000 CPU: (none) Enqlm: 20000 Pgflquo: 200000 Thanks.
T.R | Title | User | Personal Name | Date | Lines |
---|---|---|---|---|---|
513.1 | Increase your WSEXTENT AND WSQUOTA.... | AIMHI::CIONI_L | Thu May 21 1992 13:34 | 20 | |
Here's a view of mine: Maxjobs: 0 Fillm: 250 Bytlm: 120000 Maxacctjobs: 0 Shrfillm: 0 Pbytlm: 0 Maxdetach: 0 BIOlm: 150 JTquota: 2048 Prclm: 10 DIOlm: 150 WSdef: 644 Prio: 4 ASTlm: 150 WSquo: 48000 Queprio: 0 TQElm: 100 WSextent: 99000 CPU: (none) Enqlm: 8000 Pgflquo: 141000 Also, with some of the V5 versions of FOCUS, I got the same problem and increasing the WSEXTENT and WSQUOTA didn't help until I had it really high - I called the IBI hotline and they said that there was some sort of an internal buffer limit FOCUS had for something that was the culprit and that they had written a paper patch a while ago in conjunction with a DEC site to cure the problem but I was never able to get a paper patch of it and went with the higher WSquo and WSextent LisaC | |||||
513.2 | Wot! no memory! it's a VAX!!! | PEKING::MCSHANEG | Deceptively Co-operative | Fri Jun 05 1992 12:02 | 18 |
Nigel, I've come across this error many times and in the majority of cases it's due to a FOCUS restriction on the number of lookup elements in either an external DECODE table that you may have FILEDEF'd or the same with a list of test elements. The easiest way around it is to either define a .MAS for the lookup and use JOIN or to split the lookup into smaller files and refer to them using OR's. Gary. Gary. |