Focal Point Banner


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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Save parameter report have too long URL

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Save parameter report have too long URL
 Login/Join
 
Member
posted
Hi,
I have a problem with HTML that is opened from the save parameter reports that
have too long URL.

At first, I thought this problem was caused by too many number of parameters but
it's not.

The original HTML is 1setup_allocation1.htm that contains many parameters. I
tested it by selecting and inputiing parameters and then used the 'save
selection' feature to save these set of selected parameters.

For the save selection report name 320.fex, everything is ok. We can open it
and found the URL is

http://172.22.200.118/ibi_apps...e=IBIMR_savedParamF-
ile&IBIMR_action=MR_RUN_FEX&IBIMR_sub_action=MR_STD_REPORT&IBIMR_fex=app%2F1set-
up_allocation1.htm&IBIMR_folder=%23simulational&IBIMR_domain=projctl1%2Fprojctl-
1.htm&CREDIT_LIMIT_F=&CREDIT_LIMIT_T=3333333&LOAN_INT_F=&LOAN_INT_T=&MINI_PAY_F-
=&MINI_PAY_T=&PAY_PENALTY_F=&PAY_PENALTY_T=&AGE_F=&AGE_T=&AGE_OF_JOB_F=&AGE_OF_-
JOB_T=&LIVING_PERIOD_F=&LIVING_PERIOD_T=&NO_OF_AG_F=&NO_OF_AG_T=&LAST_OCS_CNT_F-
=&LAST_OCS_CNT_T=&OS_BALANCE_F=&OS_BALANCE_T=&SALARY_F=&SALARY_T=&OS_BALANCE_ST-
AT_F=&OS_BALANCE_STAT_T=&EMBO_DATE_F=&EMBO_DATE_T=&FIRST_DATE_F=&FIRST_DATE_T=&-
GRP_ID=88888&DEQ_COUNT=0&DEQ_COUNT=1&DEQ_COUNT=2&DEQ_COUNT=3&DEQ_COUNT=4&DEQ_CO-
UNT=5&DEQ_COUNT=6&CARD_TYPE=0&CARD_TYPE=3562&CARD_TYPE=4079&CARD_TYPE=4090&CARD-
_TYPE=4629&CARD_TYPE=4924&CARD_TYPE=5105&CARD_TYPE=5178&CARD_TYPE=5221&CARD_TYP-
E=5256&CARD_TYPE=5275&CARD_TYPE=8577&LAST_DEQ_STAT=0&LAST_DEQ_STAT=1&LAST_DEQ_S-
TAT=2&LAST_DEQ_STAT=3&LAST_DEQ_STAT=4&LAST_DEQ_STAT=5&LAST_DEQ_STAT=6&LAST_RESU-
LT_CD=0&LAST_RESULT_CD=11&LAST_RESULT_CD=12&LOAN_TYPE=FOC_NONE&PL_TYPE=FOC_NONE-
&PRODUCT=FOC_NONE&PAY_HISTORY01=FOC_NONE&PAY_HISTORY02=FOC_NONE&PAY_HISTORY03=F-
OC_NONE&PAY_HISTORY04=FOC_NONE&PAY_HISTORY05=FOC_NONE&PAY_HISTORY06=FOC_NONE&PA-
Y_HISTORY07=FOC_NONE&PAY_HISTORY08=FOC_NONE&PAY_HISTORY09=FOC_NONE&PAY_HISTORY1-
0=FOC_NONE&PAY_HISTORY11=FOC_NONE&PAY_HISTORY12=FOC_NONE&PAY_HISTORY13=FOC_NONE-
&PAY_HISTORY14=FOC_NONE&PAY_HISTORY15=FOC_NONE&PAY_HISTORY16=FOC_NONE&PAY_HISTO-
RY17=FOC_NONE&PAY_HISTORY18=FOC_NONE&PAY_HISTORY19=FOC_NONE&PAY_HISTORY20=FOC_N-
ONE&PAY_HISTORY21=FOC_NONE&PAY_HISTORY22=FOC_NONE&PAY_HISTORY23=FOC_NONE&PAY_HI-
STORY24=FOC_NONE&PAY_TYPE=FOC_NONE&AREA_CD=FOC_NONE&DELINQ=FOC_NONE&BRANCH_CD=F-
OC_NONE&BUSINESS_TYPE=FOC_NONE&COMPANY_CODE=FOC_NONE&COMPANY_STATUS=FOC_NONE&DE-
LINQ_STAT=FOC_NONE&CUSTOMER_STATUS=FOC_NONE&EDUCATION=FOC_NONE&HOME_CD=FOC_NONE-
&LAST_CATEGORY_GRP=FOC_NONE&MARITAL=FOC_NONE&HOME_ZIP=FOC_NONE&SEX=FOC_NONE&TYP-
E_OF_JOB=FOC_NONE&NATIONALIT=FOC_NONE&LAST_CUS_TYPE=FOC_NONE&BLOCK_CD=C1&BLOCK_-
CD=P1&BLOCK_CD=P2&BLOCK_CD=P3

This URL length is 2083 characters

But when we just changed CREDIT_LIMIT_T from 3333333 to 33333333 and then saved
selection again as 321.fex. When we tried to open it, we got the blank page with
'Error on page' at the buttom left of browser.
The URL of this case is only

http://172.22.200.118/ibi_apps...WORP_LAUNCH_CGI&IBI-
MR_action=MR_RUN_FEX&IBIMR_domain=projctl1/projctl1.htm&IBIMR_folder=%23.olapSa-
vedParameters&IBIMR_fex=admin/321.fex&IBIMR_flags=parmrpt%2CisFex%3Dtrue%2CrunP-
owerPoint%3Dtrue&IBIMR_sub_action=MR_MY_REPORT&WORP_MRU=true&IBIMR_prompting=XM-
LRUN&&WORP_MPV=public&&IBIMR_random=66020&

The URL length should be 2084 characters with each parameter value but it have
only as above.

I also tried to select the more values for multiselect listbox it also generated the same error.

For testing you can create simple procedure like

-TYPE A is &A
-TYPE B is &B
-TYPE C is &C
-TYPE D is &D
-TYPE E is &E.(OR('A')).

and html,with save selection button to run it on MRE. Then give these parameters with the very long values or select many values for the multiselection and save selection. When open these save selection report it should generate URL that is longer than 2083 but it error as I told you

Who can suggest what I can do for solving it?
Surachet

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.7
Windows
Output: All of them
 
Posts: 5 | Registered: February 19, 2009Report This Post
Virtuoso
posted Hide Post
Please refer to this page.

The maximum length of a url, as discussed here before, in IE is 2083 as you have discovered.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Virtuoso
posted Hide Post
I would suggest to reduce the length of your amper fields.

So instead
&PAY_HISTORY05=FOC_NONE use &P5
&PAY_HISTORY06=FOC_NONE use &P6
&PA-Y_HISTORY07=FOC_NONE use &P7
&PAY_HISTORY08=FOC_NONE use &P8

and

what should this do
&CARD_TYPE=0&CARD_TYPE=3562&CARD_TYPE=4079&CARD_TYPE=4090
&CARD-TYPE=4629&CARD_TYPE=4924&CARD_TYPE=5105&CARD_TYPE=5178
&CARD_TYPE=5221&CARD_TYPE=5256&CARD_TYPE=5275&CARD_TYPE=8577

its the same amperfield every time.....




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Member
posted Hide Post
Hi
Many thanks for every suggestion

For FrankDutch
your question about &CARD_TYPE=0&CARD_TYPE=3562&CARD_TYPE=4079&CARD_TYPE=4090
&CARD-TYPE=4629&CARD_TYPE=4924&CARD_TYPE=5105&CARD_TYPE=5178
&CARD_TYPE=5221&CARD_TYPE=5256&CARD_TYPE=5275&CARD_TYPE=8577

those are the parameter values for multiselection list box.

Shortening parameter names is the way that I think to do but if URL is still limited on 2083 for IE, it can touch this limitation in some case because this HTML page contains many multiselect listbox that user can select mamy values for them.

So, I would like to find the permanant solution.


Best regards,

Surachet


WebFOCUS 7.6.7
Windows
Output: All of them
 
Posts: 5 | Registered: February 19, 2009Report This Post
Virtuoso
posted Hide Post
Surachet,

You did not tell us how this html page is being created. Usually an html page with data on it that has to be sent to the server has one or more forms on it to collect and group the data and send it to the server. The default way of doing this is by using the method GET for the form. This will produce a URL that contains all selected data that is in the form. The other method is POST, which will collect teh data and send it over to the server in a message. The url will in that case only contain the part before the ?. This way of dealing with data also has a limit on size but that limit is very much higher than the url length. I have not touched that limit yet.
It may be wise to investigate if you can use this POST method in your environment.

Hope this helps.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Member
posted Hide Post
Hi GamP
As I told my report is the save parameter reports. This feature is available only on MRE.
The 320.fex contains code

-HTMLFORM BEGIN NOEVAL

<script type=text/javascript>
function OnLoad() {
document.forms.temp.submit(); }























































































































-HTMLFORM END


This .fex will open 1setup_allocation1.htm and apply the saved parameter values for it.

This .fex' code is auto generated by WF when I used the save selection feature.

Best regards

Surachet


WebFOCUS 7.6.7
Windows
Output: All of them
 
Posts: 5 | Registered: February 19, 2009Report This Post
Virtuoso
posted Hide Post
Use the [ CODE ] tags! -- unless you prefer to keep your code invisible.
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Virtuoso
posted Hide Post
  
-HTMLFORM BEGIN NOEVAL
<HTML>
<script type=text/javascript>
function OnLoad() {
document.forms.temp.submit(); }
</script>
<BODY onload=OnLoad[)>
<FORM name=temp method=get action=/ibi_apps/WFServlet>
<INPUT type=hidden name=IBIMR_savedParamFile value=IBIMR_savedParamFile>
<INPUT type=hidden name=IBIMR_action value=MR_RUN_FEX>
<INPUT type=hidden name=IBIMR_sub_action value=MR_STD_REPORT>
<INPUT type=hidden name=IBIMR_fex value=app/1setup_allocation1.htm>
<INPUT type=hidden name=IBIMR_folder value=#simulational>
<INPUT type=hidden name=IBIMR_domain value=projctl1/projctl1.htm>
<INPUT type=hidden name=CREDIT_LIMIT_F value="">
<INPUT type=hidden name=CREDIT_LIMIT_T value="3333333">
<INPUT type=hidden name=LOAN_INT_F value="">
<INPUT type=hidden name=LOAN_INT_T value="">
<INPUT type=hidden name=MINI_PAY_F value="">
<INPUT type=hidden name=MINI_PAY_T value="">
<INPUT type=hidden name=PAY_PENALTY_F value="">
<INPUT type=hidden name=PAY_PENALTY_T value="">
<INPUT type=hidden name=AGE_F value="">
<INPUT type=hidden name=AGE_T value="">
<INPUT type=hidden name=AGE_OF_JOB_F value="">
<INPUT type=hidden name=AGE_OF_JOB_T value="">
<INPUT type=hidden name=LIVING_PERIOD_F value="">
<INPUT type=hidden name=LIVING_PERIOD_T value="">
<INPUT type=hidden name=NO_OF_AG_F value="">
<INPUT type=hidden name=NO_OF_AG_T value="">
<INPUT type=hidden name=LAST_OCS_CNT_F value="">
<INPUT type=hidden name=LAST_OCS_CNT_T value="">
<INPUT type=hidden name=OS_BALANCE_F value="">
<INPUT type=hidden name=OS_BALANCE_T value="">
<INPUT type=hidden name=SALARY_F value="">
<INPUT type=hidden name=SALARY_T value="">
<INPUT type=hidden name=OS_BALANCE_STAT_F value="">
<INPUT type=hidden name=OS_BALANCE_STAT_T value="">
<INPUT type=hidden name=EMBO_DATE_F value="">
<INPUT type=hidden name=EMBO_DATE_T value="">
<INPUT type=hidden name=FIRST_DATE_F value="">
<INPUT type=hidden name=FIRST_DATE_T value="">
<INPUT type=hidden name=GRP_ID value="88888">
<INPUT type=hidden name=DEQ_COUNT value="0">
<INPUT type=hidden name=DEQ_COUNT value="1">
<INPUT type=hidden name=DEQ_COUNT value="2">
<INPUT type=hidden name=DEQ_COUNT value="3">
<INPUT type=hidden name=DEQ_COUNT value="4">
<INPUT type=hidden name=DEQ_COUNT value="5">
<INPUT type=hidden name=DEQ_COUNT value="6">
<INPUT type=hidden name=CARD_TYPE value="0">
<INPUT type=hidden name=CARD_TYPE value="3562">
<INPUT type=hidden name=CARD_TYPE value="4079">
<INPUT type=hidden name=CARD_TYPE value="4090">
<INPUT type=hidden name=CARD_TYPE value="4629">
<INPUT type=hidden name=CARD_TYPE value="4924">
<INPUT type=hidden name=CARD_TYPE value="5105">
<INPUT type=hidden name=CARD_TYPE value="5178">
<INPUT type=hidden name=CARD_TYPE value="5221">
<INPUT type=hidden name=CARD_TYPE value="5256">
<INPUT type=hidden name=CARD_TYPE value="5275">
<INPUT type=hidden name=CARD_TYPE value="8577">
<INPUT type=hidden name=LAST_DEQ_STAT value="0">
<INPUT type=hidden name=LAST_DEQ_STAT value="1">
<INPUT type=hidden name=LAST_DEQ_STAT value="2">
<INPUT type=hidden name=LAST_DEQ_STAT value="3">
<INPUT type=hidden name=LAST_DEQ_STAT value="4">
<INPUT type=hidden name=LAST_DEQ_STAT value="5">
<INPUT type=hidden name=LAST_DEQ_STAT value="6">
<INPUT type=hidden name=LAST_RESULT_CD value="0">
<INPUT type=hidden name=LAST_RESULT_CD value="11">
<INPUT type=hidden name=LAST_RESULT_CD value="12">
<INPUT type=hidden name=LOAN_TYPE value="FOC_NONE">
<INPUT type=hidden name=PL_TYPE value="FOC_NONE">
<INPUT type=hidden name=PRODUCT value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY01 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY02 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY03 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY04 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY05 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY06 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY07 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY08 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY09 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY10 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY11 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY12 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY13 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY14 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY15 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY16 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY17 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY18 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY19 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY20 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY21 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY22 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY23 value="FOC_NONE">
<INPUT type=hidden name=PAY_HISTORY24 value="FOC_NONE">
<INPUT type=hidden name=PAY_TYPE value="FOC_NONE">
<INPUT type=hidden name=AREA_CD value="FOC_NONE">
<INPUT type=hidden name=DELINQ value="FOC_NONE">
<INPUT type=hidden name=BRANCH_CD value="FOC_NONE">
<INPUT type=hidden name=BUSINESS_TYPE value="FOC_NONE">
<INPUT type=hidden name=COMPANY_CODE value="FOC_NONE">
<INPUT type=hidden name=COMPANY_STATUS value="FOC_NONE">
<INPUT type=hidden name=DELINQ_STAT value="FOC_NONE">
<INPUT type=hidden name=CUSTOMER_STATUS value="FOC_NONE">
<INPUT type=hidden name=EDUCATION value="FOC_NONE">
<INPUT type=hidden name=HOME_CD value="FOC_NONE">
<INPUT type=hidden name=LAST_CATEGORY_GRP value="FOC_NONE">
<INPUT type=hidden name=MARITAL value="FOC_NONE">
<INPUT type=hidden name=HOME_ZIP value="FOC_NONE">
<INPUT type=hidden name=SEX value="FOC_NONE">
<INPUT type=hidden name=TYPE_OF_JOB value="FOC_NONE">
<INPUT type=hidden name=NATIONALIT value="FOC_NONE">
<INPUT type=hidden name=LAST_CUS_TYPE value="FOC_NONE">
<INPUT type=hidden name=BLOCK_CD value="C1">
<INPUT type=hidden name=BLOCK_CD value="P1">
<INPUT type=hidden name=BLOCK_CD value="P2">
<INPUT type=hidden name=BLOCK_CD value="P3">
</FORM>
</BODY>
</HTML>
-HTMLFORM END

With the veil lifted, we see that the Form has method="get" (and 113 INPUT tags, all "hidden"). Your onload function can change the method attribute to "post".
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Expert
posted Hide Post
But will the Save Parameters functionality work with a form with method post?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Virtuoso
posted Hide Post
What does NOEVAL (on the -HTMLFORM BEGIN line) do? "No Evaluation" - but of what?

I couldn't find any documentation.
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Virtuoso
posted Hide Post
quote:
Originally posted by Francis Mariani:
But will the Save Parameters functionality work with a form with method post?


I would expect the layer that looks for those special input variables and triggers the Saved Parameters process to fire up only after the variables passed (whether via Get or Post) are parsed and copied by the client -- rather than operating directly on the URL string. But it's anyone's guess, until you try it out.

I just pointed out how to try GamP's suggestion. Ball is in Surachet's court.
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Gold member
posted Hide Post
Hi Surachet,
could you please let me know if you got the solution for this problem.
I am also having the same problem....it will be very useful if you share your solution

thank you....
A.


WebFocus7.6.2, WebFocus 7.1.1,Windows
HTML, PDF and Excel
 
Posts: 71 | Registered: June 30, 2009Report This Post
Gold member
posted Hide Post
quote:
Surachet

Ditto. I hope a solution is forthcoming.


WebFOCUS 769
Windows
all
 
Posts: 53 | Registered: April 29, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Save parameter report have too long URL

Copyright © 1996-2020 Information Builders