 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [solved] Too many ampers derived from URL gives (FOC206) INSUFFICIENT MEMORY
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [solved] Too many ampers derived from URL gives (FOC206) INSUFFICIENT MEMORY Read-Only TopicGo | Search | Notify | Tools |
| [solved] Too many ampers derived from URL gives (FOC206) INSUFFICIENT MEMORY | Login/Join |
| Master |
I am passing wf a long url (via Post method) where there are hundreds of variables X1,X2... which are then being translated into amper variables &X1,&X2 etc and I get this message once a certain limit is passed. (FOC206) INSUFFICIENT MEMORY IS AVAILABLE FOR PROGRAM/CACHE Is there a simple method of increasing the memory available. Regards JohnThis message has been edited. Last edited by: hammo1j, Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | ||
|
| Master |
Here's the code to create the error in WebFOCUS (sorry JG) With 100 iterations of :LOOP on our system it gives FOC206. With 2 or 3 it works fine. What also is surprising is the time taken to render by IE. I didn't have time to work out the limit, but would be interested if anyone knows a way to increase since it seems quite small.
-* testinput.fex
-SET &ECHO=ON ;
-? &
FILEDEF HOLD DISK HOLD.FTM ( APPEND
-REPEAT : LOOP FOR &I FROM 1 TO 100
TABLE FILE CAR
PRINT COUNTRY
ON TABLE HOLD
END
-RUN
-:LOOP
DEFINE FILE HOLD
MSG_NO/I3 WITH COUNTRY = LAST MSG_NO + 1 ;
COUNTERR/A3=PTOA(MSG_NO,'(P3)','A3');
COUNTER/A3=LJUST(3,COUNTERR,'A3');
SPONSORX/A120V='<tr><td><input type=text name="COUNTR' || COUNTER || '" size="11" value="' || COUNTRY || '" >' || '</td></tr>' ;
END
-RUN
TABLE FILE HOLD
PRINT
SPONSORX AS 'Sponsor'
ON TABLE HOLD AS MESSAGES FORMAT HTMTABLE
ON TABLE SET PAGE-NUM NOPAGE
ON TABLE SET HTMLCSS ON
END
-RUN
-HTMLFORM BEGIN
<html>
<head>
<title>Test Input</title>
</head>
<body>
<form name="form" method=post action="/ibi_apps/WFServlet">
<table width="100%" >
<tr>
<td width="100%" COLSPAN="2">
<INPUT TYPE="BUTTON" NAME="Submit" VALUE="Submit" onclick="submit();">
<input type=hidden name="IBIF_ex" id="IBIF_ex" value="testinput">
<input type=hidden name="IBIAPP_app" id="IBIAPP_app" value="UTILITIES">
<input type=hidden name="IBIMR_random" id="IBIMR_random" value=0>
</td>
</tr>
<tr><td nowrap width="100%">!IBI.FIL.MESSAGES;</td></tr>
</table>
</form>
</body>
</html>
-HTMLFORM END
-EXIT
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Virtuoso |
Two things to note: 1. Your amper vars are &COUNTR1, &COUNTR2, etc. If you shorten that to &X1, &X2, ..., the available memory will (I presume) stretch further. 2. If you name all the INPUT tags identically, the CGI process will index them (assigning the series of "name='X'" parameters to &X1, &X2, ...) -- so if the index numbers have no real significance you can further reduce the size of the generated HTML code, and the volume of data transmitted by the submit. - Jack Gross WF through 8.1.05 | |||
|
| Expert |
John, I just ran your code on our system and I didn't have any problems. I am on a Unix platform however. Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Expert |
moi non plus i changed &I to I changed REPEAT : LOOP to REPEAT :LOOP and didn't have any problems i'm on unix as is Ginny something about providing code snippets... its simply irresistible... ya gotta try it  as jack says, shortening parm names as much as possible..i run in to this problem with long multidrills... the limit in length to a url in ie is 2k..i don't know if POST vs GET addresses that issue at all, does it?
| |||||
|
| Platinum Member |
We have a process where we send over 150 varies in a query string from some Microsoft Excel VBA code. But we send is a one varaible seperated by ~ (tilta). It is parsed using the GETTOK function. Of course everything is positional. The VBA also code "scrubbs" the input for special characters. Just about any thing other then a letter or number will cause problems, some place in the process. Jim Morrow Web Focus 7.6.10 under Windows 2003 MVS 7.3.3 | |||
|
| Expert |
Post doesn't have the limitations of a GET. I've passed a couple of thousand variables my self, most being small. There is another post in this forum where Gerry says WebFOCUS has no limit on variable except for available resources. I have also done what Jim has done pass a single long string delimited by a unique char or string. The code you posted also works for me as well. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
and servlet is POST by default, is that right, Waz?
| |||||
|
| Master |
Thanks very much guys for your input. I did not make the point clear about where the problem occurs. This is not when the original HTML is rendered but when the Submit button is pressed. Please could you let me know if you pressed Submit in your tests because I think this issue may have been resolved by a later release of wf because I note you are all on 766/767 who said it worked. John Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Master |
More stuff: On failure I get this in the log. 12/08/2008 13:33:41 error in COMP: Memory Allocation Failure. In addition it seems that the limiting factor is the size of the query string (ie variable name plus data ) which seems to have a maximum size of about 4800.This message has been edited. Last edited by: hammo1j, Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Expert |
Ok, I saved the posted code and ran it 6-7 times in succession and had no problems. I am on 7.6.5 and on AIX. Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Master |
Ginny, are you saying you clicked on Submit 6 or 7 times? Btw can you run and click on submit with a 1000 iterations of the loop instead of a 100? If so it looks like an upgrade will get us round this problem. Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Master |
More stuff 1000 amper variables does not cause a problem in wf -REPEAT :LOOP FOR &J FROM 1 TO 1000 -SET &COUNTR.&J = 'W GERMANY' ; -:LOOP -? & Works so it is not a limit there. I assume that the servlet takes the variables in the http message contained in the POST area and parses them into amper variables. I would guess it actually does it like this. -SET &COUNTR1 = 'W GERMANY'; -SET &COUNTR10 = 'W GERMANY'; -SET &COUNTR100 = 'W GERMANY'; -SET &COUNTR1000 = 'W GERMANY'; -SET &COUNTR101 = 'W GERMANY' ;' -SET &COUNTR102 = 'W GERMANY'; -* ETC -INCLUDE testinput but when I did
<input type=hidden name="IBIWF_msgviewer" id="IBIWF_msgviewer" value="ECHOALL">
to set an echo prior to the execution of the fex I only got. SET GRAPHSERVURL=http://electra:80/ibi_apps/IBIGraphServlet SET GRAPHENGINE=GRAPH53 -INCLUDE testinput Maybe I need to look at server traces... Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Master |
looking at the wfservlet traces we can see that indeed it does build a .fex to run before your actual fex. The variables in the querystring come across in the reverse order they are defined but there is no particular order in which they are issued as -set commands -SET &COUNTR105='ENGLAND'; -SET &COUNTR498='JAPAN'; -SET &COUNTR504='S AFRICA'; -SET &COUNTR571='ITALY'; -SET &COUNTR375='E GERMANY'; -SET &COUNTR678='CROATIA'; -SET &COUNTR604='W GERMANY'; -SET &COUNTR52='W GERMANY'; -SET &COUNTR6='CROATIA'; -SET &COUNTR391='E GERMANY'; -SET &COUNTR268='W GERMANY'; -SET &COUNTR133='FRANCE'; -SET &COUNTR256='S AFRICA'; -SET &COUNTR414='CROATIA'; -SET &COUNTR295='E GERMANY'; I assume they have been put into a hash table which has been scanned. Anyway the error is server side so over to there... Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Master |
-SET &QUERY_STRING='COUNTR559=E+GERMANY'|'&'|'COUNTR558=CROATIA'|'&'|'COUNTR557=FRANCE'|'&'|'COUNTR556=W+GERMANY'|'&'|'COUNTR555=ITALY'|'&'|'COUNTR554=JAPAN'|'&'|'COUNTR553=ENGLAND'|'&'|'COUNTR552=S+AFRICA'|'&'|'COUNTR551=E+GERMANY'|'&'|'COUNTR550=CROATIA'|'&'|'COUNTR549=FRANCE'|'&'|'COUNTR548=W+GERMANY'|'&'|'COUNTR547=ITALY'|'&'|'COUNTR546=JAPAN'|'&'|'COUNTR545=ENGLAND'|'&'|'COUNTR544=S+AFRICA'|'&'|'COUNTR543=E+GERMANY'|'&'|'COUNTR542=CROATIA'|'&'|'COUNTR541=FRANCE'|'&'|'COUNTR540=W+GERMANY'|'&'|'COUNTR539=ITALY'|'&'|'COUNTR538=JAPAN'|'&'|'COUNTR537=ENGLAND'|'&'|'COUNTR536=S+AFRICA'|'&'|'COUNTR535=E+GERMANY'|'&'|'COUNTR534=CROATIA'|'&'|'COUNTR533=FRANCE'|'&'|'COUNTR532=W+GERMANY'|'&'|'COUNTR531=ITALY'|'&'|'COUNTR530=JAPAN'|'&'|'COUNTR529=ENGLAND'|'&'|'COUNTR528=S+AFRICA'|'&'|'COUNTR527=E+GERMANY'|'&'|'COUNTR526=CROATIA'|'&'|'COUNTR525=FRANCE'|'&'|'COUNTR524=W+GERMANY'|'&'|'COUNTR523=ITALY'|'&'|'COUNTR522=JAPAN'|'&'|'COUNTR521=ENGLAND'|'&'|'COUNTR520=S+AFRICA'|'&'|'COUNTR519=E+GERMANY'|'&'|'COUNTR518=CROATIA'|'&'|'COUNTR517=FRANCE'|'&'|'COUNTR516=W+GERMANY'|'&'|'COUNTR515=ITALY'|'&'|'COUNTR514=JAPAN'|'&'|'COUNTR513=ENGLAND'|'&'|'COUNTR512=S+AFRICA'|'&'|'COUNTR511=E+GERMANY'|'&'|'COUNTR510=CROATIA'|'&'|'COUNTR509=FRANCE'|'&'|'COUNTR508=W+GERMANY'|'&'|'COUNTR507=ITALY'|'&'|'COUNTR506=JAPAN'|'&'|'COUNTR505=ENGLAND'|'&'|'COUNTR504=S+AFRICA'|'&'|'COUNTR503=E+GERMANY'|'&'|'COUNTR502=CROATIA'|'&'|'COUNTR501=FRANCE'|'&'|'COUNTR500=W+GERMANY'|'&'|'IBIMR_random=0'|'&'|'COUNTR399=E+GERMANY'|'&'|'COUNTR398=CROATIA'|'&'|'COUNTR397=FRANCE'|'&'|'COUNTR396=W+GERMANY'|'&'|'COUNTR395=ITALY'|'&'|'COUNTR394=JAPAN'|'&'|'COUNTR393=ENGLAND'|'&'|'COUNTR392=S+AFRICA'|'&'|'COUNTR391=E+GERMANY'|'&'|'COUNTR390=CROATIA'|'&'|'COUNTR389=FRANCE'|'&'|'COUNTR388=W+GERMANY'|'&'|'COUNTR387=ITALY'|'&'|'COUNTR386=JAPAN'|'&'|'COUNTR385=ENGLAND'|'&'|'COUNTR384=S+AFRICA'|'&'|'COUNTR383=E+GERMANY'|'&'|'COUNTR382=CROATIA'|'&'|'COUNTR381=FRANCE'|'&'|'COUNTR380=W+GERMANY'|'&'|'COUNTR379=ITALY'|'&'|'COUNTR378=JAPAN'|'&'|'COUNTR377=ENGLAND'|'&'|'COUNTR376=S+AFRICA'|'&'|'COUNTR375=E+GERMANY'|'&'|'COUNTR374=CROATIA'|'&'|'COUNTR373=FRANCE'|'&'|'COUNTR372=W+GERMANY'|'&'|'COUNTR371=ITALY'|'&'|'COUNTR370=JAPAN'|'&'|'COUNTR369=ENGLAND'|'&'|'COUNTR368=S+AFRICA'|'&'|'COUNTR367=E+GERMANY'|'&'|'COUNTR366=CROATIA'|'&'|'COUNTR365=FRANCE'|'&'|'COUNTR364=W+GERMANY'|'&'|'COUNTR363=ITALY'|'&'|'COUNTR362=JAPAN'|'&'|'COUNTR361=ENGLAND'|'&'|'COUNTR360=S+AFRICA'|'&'|'COUNTR359=E+GERMANY'|'&'|'COUNTR358=CROATIA'|'&'|'COUNTR357=FRANCE'|'&'|'COUNTR356=W+GERMANY'|'&'|'COUNTR355=ITALY'|'&'|'COUNTR354=JAPAN'|'&'|'COUNTR353=ENGLAND'|'&'|'COUNTR352=S+AFRICA'|'&'|'COUNTR351=E+GERMANY'|'&'|'COUNTR350=CROATIA'|'&'|'COUNTR349=FRANCE'|'&'|'COUNTR348=W+GERMANY'|'&'|'COUNTR347=ITALY'|'&'|'COUNTR346=JAPAN'|'&'|'COUNTR345=ENGLAND'|'&'|'COUNTR344=S+AFRICA'|'&'|'COUNTR343=E+GERMANY'|'&'|'COUNTR342=CROATIA'|'&'|'COUNTR341=FRANCE'|'&'|'COUNTR340=W+GERMANY'|'&'|'COUNTR339=ITALY'|'&'|'COUNTR699=ITALY'|'&'|'COUNTR338=JAPAN'|'&'|'COUNTR698=JAPAN'|'&'|'COUNTR337=ENGLAND'|'&'|'COUNTR697=ENGLAND'|'&'|'COUNTR336=S+AFRICA'|'&'|'COUNTR696=S+AFRICA'|'&'|'COUNTR335=E+GERMANY'|'&'|'COUNTR695=E+GERMANY'|'&'|'COUNTR334=CROATIA'|'&'|'COUNTR694=CROATIA'|'&'|'COUNTR333=FRANCE'|'&'|'COUNTR693=FRANCE'|'&'|'COUNTR332=W+GERMANY'|'&'|'COUNTR692=W+GERMANY'|'&'|'COUNTR331=ITALY'|'&'|'COUNTR691=ITALY'|'&'|'COUNTR330=JAPAN'|'&'|'COUNTR690=JAPAN'|'&'|'IBIAPP_app=UTILITIES'|'&'|'COUNTR329=ENGLAND'|'&'|'COUNTR689=ENGLAND'|'&'|'COUNTR328=S+AFRICA'|'&'|'COUNTR688=S+AFRICA'|'&'|'COUNTR327=E+GERMANY'|'&'|'COUNTR687=E+GERMANY'|'&'|'COUNTR326=CROATIA'|'&'|'COUNTR686=CROATIA'|'&'|'COUNTR325=FRANCE'|'&'|'COUNTR685=FRANCE'|'&'|'COUNTR324=W+GERMANY'|'&'|'COUNTR684=W+GERMANY'|'&'|'COUNTR323=ITALY'|'&'|'COUNTR683=ITALY'|'&'|'COUNTR322=JAPAN'|'&'|'COUNTR682=JAPAN'|'&'|'COUNTR321=ENGLAND'|'&'|'COUNTR681=ENGLAND'|'&'|'COUNTR320=S+AFRICA'|'&'|'COUNTR680=S+AFRICA'|'&'|'COUNTR319=E+GERMANY'|'&'|'COUNTR679=E+GERMANY'|'&'|'COUNTR318=CROATIA'|'&'|'COUNTR678=CROATIA'|'&'|'COUNTR317=FRANCE'|'&'|'COUNTR677=FRANCE'|'&'|'COUNTR316=W+GERMANY'|'&'|'COUNTR676=W+GERMANY'|'&'|'COUNTR315=ITALY'|'&'|'COUNTR675=ITALY'|'&'|'COUNTR314=JAPAN'|'&'|'COUNTR674=JAPAN'|'&'|'COUNTR313=ENGLAND'|'&'|'COUNTR673=ENGLAND'|'&'|'COUNTR312=S+AFRICA'|'&'|'COUNTR672=S+AFRICA'|'&'|'COUNTR311=E+GERMANY'|'&'|'COUNTR671=E+GERMANY'|'&'|'COUNTR310=CROATIA'|'&'|'COUNTR670=CROATIA'|'&'|'COUNTR309=FRANCE'|'&'|'COUNTR669=FRANCE'|'&'|'COUNTR308=W+GERMANY'|'&'|'COUNTR668=W+GERMANY'|'&'|'COUNTR307=ITALY'|'&'|'COUNTR667=ITALY'|'&'|'COUNTR306=JAPAN'|'&'|'COUNTR666=JAPAN'|'&'|'COUNTR305=ENGLAND'|'&'|'COUNTR665=ENGLAND'|'&'|'COUNTR304=S+AFRICA'|'&'|'COUNTR664=S+AFRICA'|'&'|'COUNTR303=E+GERMANY'|'&'|'COUNTR663=E+GERMANY'|'&'|'COUNTR302=CROATIA'|'&'|'COUNTR662=CROATIA'|'&'|'COUNTR301=FRANCE'|'&'|'COUNTR661=FRANCE'|'&'|'COUNTR300=W+GERMANY'|'&'|'COUNTR660=W+GERMANY'|'&'|'COUNTR659=ITALY'|'&'|'COUNTR658=JAPAN'|'&'|'COUNTR657=ENGLAND'|'&'|'COUNTR656=S+AFRICA'|'&'|'COUNTR655=E+GERMANY'|'&'|'COUNTR654=CROATIA'|'&'|'COUNTR653=FRANCE'|'&'|'COUNTR652=W+GERMANY'|'&'|'COUNTR651=ITALY'|'&'|'COUNTR650=JAPAN'|'&'|'COUNTR649=ENGLAND'|'&'|'COUNTR648=S+AFRICA'|'&'|'COUNTR647=E+GERMANY'|'&'|'COUNTR646=CROATIA'|'&'|'COUNTR645=FRANCE'|'&'|'COUNTR644=W+GERMANY'|'&'|'COUNTR643=ITALY'|'&'|'COUNTR642=JAPAN'|'&'|'COUNTR641=ENGLAND'|'&'|'COUNTR640=S+AFRICA'|'&'|'COUNTR639=E+GERMANY'|'&'|'COUNTR638=CROATIA'|'&'|'COUNTR637=FRANCE'|'&'|'COUNTR636=W+GERMANY'|'&'|'COUNTR635=ITALY'|'&'|'COUNTR634=JAPAN'|'&'|'COUNTR633=ENGLAND'|'&'|'COUNTR632=S+AFRICA'|'&'|'COUNTR631=E+GERMANY'|'&'|'COUNTR630=CROATIA'|'&'|'COUNTR199=E+GERMANY'|'&'|'COUNTR198=CROATIA'|'&'|'COUNTR197=FRANCE'|'&'|'COUNTR196=W+GERMANY'|'&'|'COUNTR195=ITALY'|'&'|'COUNTR194=JAPAN'|'&'|'COUNTR193=ENGLAND'|'&'|'COUNTR192=S+AFRICA'|'&'|'COUNTR191=E+GERMANY'|'&'|'COUNTR190=CROATIA'|'&'|'COUNTR629=FRANCE'|'&'|'COUNTR628=W+GERMANY'|'&'|'COUNTR627=ITALY'|'&'|'COUNTR626=JAPAN'|'&'|'COUNTR625=ENGLAND'|'&'|'COUNTR624=S+AFRICA'|'&'|'COUNTR623=E+GERMANY'|'&'|'COUNTR622=CROATIA'|'&'|'COUNTR621=FRANCE'|'&'|'COUNTR620=W+GERMANY'|'&'|'COUNTR189=FRANCE'|'&'|'COUNTR188=W+GERMANY'|'&'|'COUNTR187=ITALY'|'&'|'COUNTR186=JAPAN'|'&'|'COUNTR185=ENGLAND'|'&'|'COUNTR184=S+AFRICA'|'&'|'COUNTR183=E+GERMANY'|'&'|'COUNTR182=CROATIA'|'&'|'COUNTR181=FRANCE'|'&'|'COUNTR180=W+GERMANY'|'&'|'COUNTR619=ITALY'|'&'|'COUNTR618=JAPAN'|'&'|'COUNTR617=ENGLAND'|'&'|'COUNTR616=S+AFRICA'|'&'|'COUNTR615=E+GERMANY'|'&'|'COUNTR614=CROATIA'|'&'|'COUNTR613=FRANCE'|'&'|'COUNTR612=W+GERMANY'|'&'|'COUNTR611=ITALY'|'&'|'COUNTR610=JAPAN'|'&'|'COUNTR179=ITALY'|'&'|'COUNTR178=JAPAN'|'&'|'COUNTR177=ENGLAND'|'&'|'COUNTR176=S+AFRICA'|'&'|'COUNTR175=E+GERMANY'|'&'|'COUNTR174=CROATIA'|'&'|'COUNTR173=FRANCE'|'&'|'COUNTR172=W+GERMANY'|'&'|'COUNTR171=ITALY'|'&'|'COUNTR170=JAPAN'|'&'|'COUNTR609=ENGLAND'|'&'|'COUNTR608=S+AFRICA'|'&'|'COUNTR607=E+GERMANY'|'&'|'COUNTR606=CROATIA'|'&'|'COUNTR605=FRANCE'|'&'|'COUNTR604=W+GERMANY'|'&'|'COUNTR603=ITALY'|'&'|'COUNTR602=JAPAN'|'&'|'COUNTR601=ENGLAND'|'&'|'COUNTR600=S+AFRICA'|'&'|'COUNTR169=ENGLAND'|'&'|'COUNTR168=S+AFRICA'|'&'|'COUNTR167=E+GERMANY'|'&'|'COUNTR166=CROATIA'|'&'|'COUNTR165=FRANCE'|'&'|'COUNTR164=W+GERMANY'|'&'|'COUNTR163=ITALY'|'&'|'COUNTR162=JAPAN'|'&'|'COUNTR161=ENGLAND'|'&'|'COUNTR160=S+AFRICA'|'&'|'COUNTR159=E+GERMANY'|'&'|'COUNTR158=CROATIA'|'&'|'COUNTR157=FRANCE'|'&'|'COUNTR156=W+GERMANY'|'&'|'COUNTR155=ITALY'|'&'|'COUNTR154=JAPAN'|'&'|'COUNTR153=ENGLAND'|'&'|'COUNTR152=S+AFRICA'|'&'|'COUNTR151=E+GERMANY'|'&'|'COUNTR150=CROATIA'|'&'|'COUNTR149=FRANCE'|'&'|'COUNTR148=W+GERMANY'|'&'|'COUNTR147=ITALY'|'&'|'COUNTR146=JAPAN'|'&'|'COUNTR145=ENGLAND'|'&'|'COUNTR144=S+AFRICA'|'&'|'COUNTR143=E+GERMANY'|'&'|'COUNTR142=CROATIA'|'&'|'COUNTR141=FRANCE'|'&'|'COUNTR140=W+GERMANY'|'&'|'COUNTR139=ITALY'|'&'|'COUNTR499=ITALY'|'&'|'COUNTR138=JAPAN'|'&'|'COUNTR498=JAPAN'|'&'|'COUNTR137=ENGLAND'|'&'|'COUNTR497=ENGLAND'|'&'|'COUNTR136=S+AFRICA'|'&'|'COUNTR496=S+AFRICA'|'&'|'COUNTR135=E+GERMANY'|'&'|'COUNTR495=E+GERMANY'|'&'|'COUNTR134=CROATIA'|'&'|'COUNTR494=CROATIA'|'&'|'COUNTR133=FRANCE'|'&'|'COUNTR493=FRANCE'|'&'|'COUNTR132=W+GERMANY'|'&'|'COUNTR492=W+GERMANY'|'&'|'COUNTR131=ITALY'|'&'|'COUNTR491=ITALY'|'&'|'COUNTR130=JAPAN'|'&'|'COUNTR490=JAPAN'|'&'|'COUNTR129=ENGLAND'|'&'|'COUNTR489=ENGLAND'|'&'|'COUNTR128=S+AFRICA'|'&'|'COUNTR488=S+AFRICA'|'&'|'COUNTR127=E+GERMANY'|'&'|'COUNTR487=E+GERMANY'|'&'|'COUNTR126=CROATIA'|'&'|'COUNTR486=CROATIA'|'&'|'COUNTR125=FRANCE'|'&'|'COUNTR485=FRANCE'|'&'|'COUNTR124=W+GERMANY'|'&'|'COUNTR484=W+GERMANY'|'&'|'COUNTR123=ITALY'|'&'|'COUNTR483=ITALY'|'&'|'COUNTR122=JAPAN'|'&'|'COUNTR99=ITALY'|'&'|'COUNTR482=JAPAN'|'&'|'COUNTR121=ENGLAND'|'&'|'COUNTR98=JAPAN'|'&'|'COUNTR481=ENGLAND'|'&'|'COUNTR120=S+AFRICA'|'&'|'COUNTR97=ENGLAND'|'&'|'COUNTR480=S+AFRICA'|'&'|'COUNTR96=S+AFRICA'|'&'|'COUNTR95=E+GERMANY'|'&'|'COUNTR94=CROATIA'|'&'|'COUNTR93=FRANCE'|'&'|'COUNTR92=W+GERMANY'|'&'|'COUNTR91=ITALY'|'&'|'COUNTR90=JAPAN'|'&'|'COUNTR119=E+GERMANY'|'&'|'COUNTR479=E+GERMANY'|'&'|'COUNTR118=CROATIA'|'&'|'COUNTR478=CROATIA'|'&'|'COUNTR117=FRANCE'|'&'|'COUNTR477=FRANCE'|'&'|'COUNTR116=W+GERMANY'|'&'|'COUNTR476=W+GERMANY'|'&'|'COUNTR115=ITALY'|'&'|'COUNTR475=ITALY'|'&'|'COUNTR114=JAPAN'|'&'|'COUNTR474=JAPAN'|'&'|'COUNTR113=ENGLAND'|'&'|'COUNTR473=ENGLAND'|'&'|'COUNTR112=S+AFRICA'|'&'|'COUNTR89=ENGLAND'|'&'|'COUNTR472=S+AFRICA'|'&'|'COUNTR111=E+GERMANY'|'&'|'COUNTR88=S+AFRICA'|'&'|'COUNTR471=E+GERMANY'|'&'|'COUNTR110=CROATIA'|'&'|'COUNTR87=E+GERMANY'|'&'|'COUNTR470=CROATIA'|'&'|'COUNTR86=CROATIA'|'&'|'COUNTR85=FRANCE'|'&'|'COUNTR84=W+GERMANY'|'&'|'COUNTR83=ITALY'|'&'|'COUNTR82=JAPAN'|'&'|'COUNTR81=ENGLAND'|'&'|'COUNTR80=S+AFRICA'|'&'|'COUNTR109=FRANCE'|'&'|'COUNTR469=FRANCE'|'&'|'COUNTR108=W+GERMANY'|'&'|'COUNTR468=W+GERMANY'|'&'|'COUNTR107=ITALY'|'&'|'COUNTR467=ITALY'|'&'|'COUNTR106=JAPAN'|'&'|'COUNTR466=JAPAN'|'&'|'COUNTR105=ENGLAND'|'&'|'COUNTR465=ENGLAND'|'&'|'COUNTR104=S+AFRICA'|'&'|'COUNTR464=S+AFRICA'|'&'|'COUNTR103=E+GERMANY'|'&'|'COUNTR463=E+GERMANY'|'&'|'COUNTR102=CROATIA'|'&'|'COUNTR79=E+GERMANY'|'&'|'COUNTR462=CROATIA'|'&'|'COUNTR101=FRANCE'|'&'|'COUNTR78=CROATIA'|'&'|'COUNTR461=FRANCE'|'&'|'COUNTR100=W+GERMANY'|'&'|'COUNTR77=FRANCE'|'&'|'COUNTR460=W+GERMANY'|'&'|'COUNTR76=W+GERMANY'|'&'|'COUNTR75=ITALY'|'&'|'COUNTR74=JAPAN'|'&'|'COUNTR73=ENGLAND'|'&'|'COUNTR72=S+AFRICA'|'&'|'COUNTR71=E+GERMANY'|'&'|'COUNTR70=CROATIA'|'&'|'COUNTR459=ITALY'|'&'|'COUNTR458=JAPAN'|'&'|'COUNTR457=ENGLAND'|'&'|'COUNTR456=S+AFRICA'|'&'|'COUNTR455=E+GERMANY'|'&'|'COUNTR454=CROATIA'|'&'|'COUNTR453=FRANCE'|'&'|'COUNTR69=FRANCE'|'&'|'COUNTR452=W+GERMANY'|'&'|'COUNTR68=W+GERMANY'|'&'|'COUNTR451=ITALY'|'&'|'COUNTR67=ITALY'|'&'|'COUNTR450=JAPAN'|'&'|'COUNTR66=JAPAN'|'&'|'COUNTR65=ENGLAND'|'&'|'COUNTR64=S+AFRICA'|'&'|'COUNTR63=E+GERMANY'|'&'|'COUNTR62=CROATIA'|'&'|'COUNTR61=FRANCE'|'&'|'COUNTR60=W+GERMANY'|'&'|'COUNTR449=ENGLAND'|'&'|'COUNTR448=S+AFRICA'|'&'|'COUNTR447=E+GERMANY'|'&'|'COUNTR446=CROATIA'|'&'|'COUNTR445=FRANCE'|'&'|'COUNTR444=W+GERMANY'|'&'|'COUNTR443=ITALY'|'&'|'COUNTR59=ITALY'|'&'|'COUNTR442=JAPAN'|'&'|'COUNTR58=JAPAN'|'&'|'COUNTR441=ENGLAND'|'&'|'COUNTR57=ENGLAND'|'&'|'COUNTR440=S+AFRICA'|'&'|'COUNTR56=S+AFRICA'|'&'|'COUNTR55=E+GERMANY'|'&'|'COUNTR54=CROATIA'|'&'|'COUNTR53=FRANCE'|'&'|'COUNTR52=W+GERMANY'|'&'|'COUNTR51=ITALY'|'&'|'COUNTR50=JAPAN'|'&'|'COUNTR439=E+GERMANY'|'&'|'COUNTR438=CROATIA'|'&'|'COUNTR437=FRANCE'|'&'|'COUNTR436=W+GERMANY'|'&'|'COUNTR435=ITALY'|'&'|'COUNTR434=JAPAN'|'&'|'COUNTR433=ENGLAND'|'&'|'COUNTR49=ENGLAND'|'&'|'COUNTR432=S+AFRICA'|'&'|'COUNTR48=S+AFRICA'|'&'|'COUNTR431=E+GERMANY'|'&'|'COUNTR47=E+GERMANY'|'&'|'COUNTR430=CROATIA'|'&'|'COUNTR46=CROATIA'|'&'|'COUNTR45=FRANCE'|'&'|'COUNTR44=W+GERMANY'|'&'|'COUNTR43=ITALY'|'&'|'COUNTR42=JAPAN'|'&'|'COUNTR41=ENGLAND'|'&'|'COUNTR40=S+AFRICA'|'&'|'COUNTR9=ENGLAND'|'&'|'COUNTR8=S+AFRICA'|'&'|'COUNTR7=E+GERMANY'|'&'|'COUNTR6=CROATIA'|'&'|'COUNTR5=FRANCE'|'&'|'COUNTR4=W+GERMANY'|'&'|'COUNTR3=ITALY'|'&'|'COUNTR2=JAPAN'|'&'|'COUNTR1=ENGLAND'|'&'|'COUNTR429=FRANCE'|'&'|'COUNTR428=W+GERMANY'|'&'|'COUNTR427=ITALY'|'&'|'COUNTR426=JAPAN'|'&'|'COUNTR425=ENGLAND'|'&'|'COUNTR424=S+AFRICA'|'&'|'COUNTR423=E+GERMANY'|'&'|'COUNTR39=E+GERMANY'|'&'|'COUNTR422=CROATIA'|'&'|'COUNTR38=CROATIA'|'&'|'COUNTR421=FRANCE'|'&'|'COUNTR37=FRANCE'|'&'|'COUNTR420=W+GERMANY'|'&'|'COUNTR36=W+GERMANY'|'&'|'COUNTR35=ITALY'|'&'|'COUNTR34=JAPAN'|'&'|'COUNTR33=ENGLAND'|'&'|'COUNTR32=S+AFRICA'|'&'|'COUNTR31=E+GERMANY'|'&'|'COUNTR30=CROATIA'|'&'|'COUNTR419=ITALY'|'&'|'COUNTR418=JAPAN'|'&'|'COUNTR417=ENGLAND'|'&'|'COUNTR416=S+AFRICA'|'&'|'COUNTR415=E+GERMANY'|'&'|'COUNTR414=CROATIA'|'&'|'COUNTR413=FRANCE'|'&'|'COUNTR29=FRANCE'|'&'|'COUNTR412=W+GERMANY'|'&'|'COUNTR28=W+GERMANY'|'&'|'COUNTR411=ITALY'|'&'|'COUNTR27=ITALY'|'&'|'COUNTR410=JAPAN'|'&'|'COUNTR26=JAPAN'|'&'|'COUNTR25=ENGLAND'|'&'|'COUNTR24=S+AFRICA'|'&'|'COUNTR23=E+GERMANY'|'&'|'COUNTR22=CROATIA'|'&'|'COUNTR21=FRANCE'|'&'|'COUNTR20=W+GERMANY'|'&'|'COUNTR409=ENGLAND'|'&'|'COUNTR408=S+AFRICA'|'&'|'COUNTR407=E+GERMANY'|'&'|'COUNTR406=CROATIA'|'&'|'COUNTR405=FRANCE'|'&'|'COUNTR404=W+GERMANY'|'&'|'COUNTR403=ITALY'|'&'|'COUNTR19=ITALY'|'&'|'COUNTR402=JAPAN'|'&'|'COUNTR18=JAPAN'|'&'|'COUNTR401=ENGLAND'|'&'|'COUNTR17=ENGLAND'|'&'|'COUNTR400=S+AFRICA'|'&'|'COUNTR16=S+AFRICA'|'&'|'COUNTR15=E+GERMANY'|'&'|'COUNTR14=CROATIA'|'&'|'COUNTR13=FRANCE'|'&'|'COUNTR12=W+GERMANY'|'&'|'COUNTR11=ITALY'|'&'|'COUNTR10=JAPAN'|'&'|'IBIWF_msgviewer=ECHOALL'|'&'|'COUNTR299=ITALY'|'&'|'COUNTR298=JAPAN'|'&'|'COUNTR297=ENGLAND'|'&'|'COUNTR296=S+AFRICA'|'&'|'COUNTR295=E+GERMANY'|'&'|'COUNTR294=CROATIA'|'&'|'COUNTR293=FRANCE'|'&'|'COUNTR292=W+GERMANY'|'&'|'COUNTR291=ITALY'|'&'|'COUNTR290=JAPAN'|'&'|'COUNTR720=S+AFRICA'|'&'|'COUNTR289=ENGLAND'|'&'|'COUNTR288=S+AFRICA'|'&'|'COUNTR287=E+GERMANY'|'&'|'COUNTR286=CROATIA'|'&'|'COUNTR285=FRANCE'|'&'|'COUNTR284=W+GERMANY'|'&'|'COUNTR283=ITALY'|'&'|'COUNTR282=JAPAN'|'&'|'COUNTR281=ENGLAND'|'&'|'COUNTR280=S+AFRICA'|'&'|'COUNTR719=E+GERMANY'|'&'|'COUNTR718=CROATIA'|'&'|'COUNTR717=FRANCE'|'&'|'COUNTR716=W+GERMANY'|'&'|'COUNTR715=ITALY'|'&'|'COUNTR714=JAPAN'|'&'|'COUNTR713=ENGLAND'|'&'|'COUNTR712=S+AFRICA'|'&'|'COUNTR711=E+GERMANY'|'&'|'COUNTR710=CROATIA'|'&'|'COUNTR279=E+GERMANY'|'&'|'COUNTR278=CROATIA'|'&'|'COUNTR277=FRANCE'|'&'|'COUNTR276=W+GERMANY'|'&'|'COUNTR275=ITALY'|'&'|'COUNTR274=JAPAN'|'&'|'COUNTR273=ENGLAND'|'&'|'COUNTR272=S+AFRICA'|'&'|'COUNTR271=E+GERMANY'|'&'|'COUNTR270=CROATIA'|'&'|'COUNTR709=FRANCE'|'&'|'COUNTR708=W+GERMANY'|'&'|'COUNTR707=ITALY'|'&'|'COUNTR706=JAPAN'|'&'|'COUNTR705=ENGLAND'|'&'|'COUNTR704=S+AFRICA'|'&'|'COUNTR703=E+GERMANY'|'&'|'COUNTR702=CROATIA'|'&'|'COUNTR701=FRANCE'|'&'|'COUNTR700=W+GERMANY'|'&'|'COUNTR269=FRANCE'|'&'|'COUNTR268=W+GERMANY'|'&'|'COUNTR267=ITALY'|'&'|'COUNTR266=JAPAN'|'&'|'COUNTR265=ENGLAND'|'&'|'COUNTR264=S+AFRICA'|'&'|'COUNTR263=E+GERMANY'|'&'|'COUNTR262=CROATIA'|'&'|'COUNTR261=FRANCE'|'&'|'COUNTR260=W+GERMANY'|'&'|'COUNTR259=ITALY'|'&'|'COUNTR258=JAPAN'|'&'|'COUNTR257=ENGLAND'|'&'|'COUNTR256=S+AFRICA'|'&'|'COUNTR255=E+GERMANY'|'&'|'COUNTR254=CROATIA'|'&'|'COUNTR253=FRANCE'|'&'|'COUNTR252=W+GERMANY'|'&'|'COUNTR251=ITALY'|'&'|'COUNTR250=JAPAN'|'&'|'IBIF_ex=testinput'|'&'|'COUNTR249=ENGLAND'|'&'|'COUNTR248=S+AFRICA'|'&'|'COUNTR247=E+GERMANY'|'&'|'COUNTR246=CROATIA'|'&'|'COUNTR245=FRANCE'|'&'|'COUNTR244=W+GERMANY'|'&'|'COUNTR243=ITALY'|'&'|'COUNTR242=JAPAN'|'&'|'COUNTR241=ENGLAND'|'&'|'COUNTR240=S+AFRICA'|'&'|'COUNTR239=E+GERMANY'|'&'|'COUNTR599=E+GERMANY'|'&'|'COUNTR238=CROATIA'|'&'|'COUNTR598=CROATIA'|'&'|'COUNTR237=FRANCE'|'&'|'COUNTR597=FRANCE'|'&'|'COUNTR236=W+GERMANY'|'&'|'COUNTR596=W+GERMANY'|'&'|'COUNTR235=ITALY'|'&'|'COUNTR595=ITALY'|'&'|'COUNTR234=JAPAN'|'&'|'COUNTR594=... The problem occurs because we are passing the query_string in site.wfs <set> QUERY_STRING(pass) wf obligingly reconstructs the string with a mass of concatenation which blows the execution stack! So if you dont pass query_string you are ok! I shall find a way around this.This message has been edited. Last edited by: hammo1j, Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Expert |
does it work if you escape the & in the qstring -SET &QUERY_STRING='COUNTR559=E+GERMANY'|'&|'|'COUNTR558=CROATIA'|'&|'|'COUNTR557=FRANCE'
| |||||
|
| Master |
It does not work when you escape. The problem is that the expression is too big. The servlet builds the expression as a dummy query string from the HTML post portion of the query. If it was just passing a string, rather than doing a concatenation, then there would be no problem. I tried to do this <ifndef> NOPASSQUERY <set> QUERY_STRING(pass) <endif> Unfortunately it seems there is no easy way of stopping QUERY_STRING being passed to the server by the servlet. See my other post!This message has been edited. Last edited by: hammo1j, Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Master |
Could someone out there just confirm. 1. They have QUERY_STRING passed as an amper ie -? & shows up QUERY_STRING. 2. They can run the example fex and click on the submit button and not get FOC206. 3. What release they are on to do this. This would be much appreciated so I could know if upgrading will solve the problem Thanks for all the help so far Regards John Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Expert |
John, I don't get QUERY_STRING I have run the fex and clicked on the Submit button, and got no error. I ran it on 7.1.6 Susannah, the method depends on the submission. An HTML form can be either, METHOD=POST|GET A URL call is always a GET. A GET passes the parameters via the URL call, this has a limit. A POST passes the parameters via the header of the call. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
<ifndef> NOPASSQUERY <set> QUERY_STRING(pass) <endif> Just added the code to the custom settings, and got the error 0 ERROR AT OR NEAR LINE 25 IN PROCEDURE _vartestfexFOCEXEC (FOC206) INSUFFICIENT MEMORY IS AVAILABLE FOR PROGRAM/CACHE Had to do this on 7.6.7 on Windows, not risking out Prod or Test environments. Why do you need the QUERY_STRING ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Master |
Hi Waz Thanks for your answers. Logging in from home before kip but I know its the start of the day in Oz. (How are those new posters which say you're looking for revenge on us Poms in 2012?) The QUERY_STRING is used to check the contents of &IBIF_adhoc (IIRC) which is examined to see if it contains markers of a RA generated procedure in which case a filter proc is run from our site profile to counteract a security flaw in our ERP. No, not making that up. The problem I need to solve is setting Querystring conditionally The idea was to put <input type=hidden name="NOPASSQUERY" id="NOPASSQUERY" value="True"> Into my fex above and thus conditionally switch off the passing of QUERY_STRING. Unfortunately my release 762 seems to give me QUERY_STRING no matter what. But I would be interested to see if you could insert this line into the code you have running under 767 and see whether it stops the problem occuring. Then all!$? I would have to do is upgrade to 767... Thanks for all your efforts. Put one on the Barbie for me! Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Expert |
<input type=hidden name="NOPASSQUERY" id="NOPASSQUERY" value="True"> I added the line to the fex and it does turn off the QUERY_STRING. I think though that it would be better to change your test to turn on the passing, and not have the string passed as a default. Say <ifdef> PASSQUERY <set> QUERY_STRING(pass) <endif> Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Master |
This was the eventual solution
<ifdef> NOPASSQUERY
QUERY_STRING=' '
<endif>
<set> QUERY_STRING(pass)
# this stops it being sent by default
# <set> QUERY_STRING(dontpass)
The dontpass syntax seems to be much better at stopping things than the nopass syntax but was not eventually used. Now our input screens work ok with a lot of values. Thank you very much everyone and, in particular, Waz Regards John Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Member |
We have a very large html "application" where we have had to code around the "save parameter" size issue by saving the parameters to an Oracle table and then retrieving for subsequent runs. We are able to save 20,000 bytes of saved parameters in a test application with only a few parameters being passed to the "save_my_parameters" fex. However, when we try to use the same coding in the large html application, we get the FOC206 error. I have reviewed the posts along this thread, but I am confused about where I need to place the various solutions to this problem. Where do you put the following? fex or html <ifdef> NOPASSQUERY
QUERY_STRING=' '
<endif>
<set> QUERY_STRING(pass)
# this stops it being sent by default
# <set> QUERY_STRING(dontpass)
And what about? fex or html <input type=hidden name="NOPASSQUERY" id="NOPASSQUERY" value="True"> Also, if I use this solution, do I lose the ability to pass ANY parameters to the "save_my_parameters" fex? I need to be able to pass about 8 parameters to the "save_my_parameters" fex. ThanksThis message has been edited. Last edited by: KeithD, 7.6.9 Windows for development/reporting server, Unix webserver, Unix DB Server (Oracle) HTML, PDF and Excel | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [solved] Too many ampers derived from URL gives (FOC206) INSUFFICIENT MEMORY
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [solved] Too many ampers derived from URL gives (FOC206) INSUFFICIENT MEMORYCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |