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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] populate the dropdown

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] populate the dropdown
 Login/Join
 
Gold member
posted
Hi,

I would like to do modification on my production program, so I made the copy for test version. I run the test version before I make any change, but none of populate dropdown parameters working. Do you know why? Am I missing any steps? I am sure it is working in production version.

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,


May

WebFOCUS 7.6.8 Servlet
- MRE/BID/Self Service/ReportCaster
- MS Windows Server 2003
- MS SQL Server 2005
- DataMigrator 7.6.9
 
Posts: 51 | Registered: December 15, 2006Report This Post
Virtuoso
posted Hide Post
If the TABLE code is being invoked but is failing, you won't get any error message, and the HTML SELECT control will remain empty.

If they are populated by an external fex, test that directly. ("Run" it in Dev Studio and see what it returns.)

If it's embedded code, copy it into the console window and test it [or, better yet, take the opportunity to convert to an external procedure and proceed as above.]

It may well be an issue with the "connection" to the database from your test environment, in which case you need to look at the synonym(s).


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Platinum Member
posted Hide Post
Hi Jack,
Funnily enough I have had exactly the same problem recently myself. I inserted the following .fex into the composer in Dev Studio and can see everything fine (list of CARs) and sample output apears. When I save the generated code and then run it outside of DevStudio it will NOT display the drop-down. This happens on only one of the the 3 servers we have - I assume therefore it must be a client setting that needs changing ?
-*
TABLE FILE CAR
PRINT SEG.WEIGHT
BY COUNTRY
BY CAR
WHERE CAR EQ &CAR.(OR(FIND CAR IN CAR)).CAR:.;
END
-*
Regards,
Ian

ps. for what it's worth here is the generated code from composer...
< !-- Generated by Report Layout Painter -->
< !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">




<script id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}


<script id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls3";

var rltdyncalendar = "rltdyncalendar";
var gmap = "ibigmap";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";

var ibixmltree="ibixmltree";

var ibiOptions = new Array(cgipath,ibirls);


<script id=IBI_nls type=text/javascript src="/ibi_html/javaassist/nls.js">

<script id=IBI_nlsVars type=text/javascript src="/ibi_html/javaassist/nlsvars.js">

<script id=IBI_ibigbl type=text/javascript src="/ibi_html/javaassist/ibi/html/js/ibigbl.js">

<script id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
addIntlTranslatedJS("composertrans.js");

HtmlPage
<script id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {

UpdateData();

// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload


<script for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }


<iframe style="Z-INDEX: 1; POSITION: absolute; WIDTH: 810px; HEIGHT: 560px; TOP: 180px; LEFT: 40px" id=report1 tabIndex=1 elementtype="2" requests_list="0" autoExecute="False" name="report1">









<script type="text/xml">

























< ![CDATA[TABLE FILE CAR
SUM FST.CAR.COMP.CAR
BY CAR.COMP.CAR
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]>








< ![CDATA[-* File bugrep34.fex
TABLE FILE CAR
PRINT SEG.WEIGHT
BY COUNTRY
BY CAR
WHERE CAR EQ &CAR.(OR(FIND CAR IN CAR)).CAR:.;
END]]>


<script id=IBI_loader type=text/javascript>
doBeforeLoad();



_______________________
*** WebFOCUS 8.1.05M ***
 
Posts: 196 | Location: London, UK | Registered: December 06, 2005Report This Post
Platinum Member
posted Hide Post
Sorry Jack - pasting of composer code into this thread missed out lots of it.
Ian


_______________________
*** WebFOCUS 8.1.05M ***
 
Posts: 196 | Location: London, UK | Registered: December 06, 2005Report This Post
Virtuoso
posted Hide Post
revise the post -- add surrounding [ code ] tags.
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Platinum Member
posted Hide Post
I should have read the FocalPoint rules...
Here it is the HTML generated code in its entirety:-
<!-- Generated by Report Layout Painter -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Created in release 7703, Generation 3.0">
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>
 
<SCRIPT id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls3";
 
var rltdyncalendar = "rltdyncalendar";
var gmap = "ibigmap";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";
 
var ibixmltree="ibixmltree";
 
var ibiOptions = new Array(cgipath,ibirls);
</SCRIPT>
 
<SCRIPT id=IBI_nls type=text/javascript src="/ibi_html/javaassist/nls.js"></SCRIPT>
 
<SCRIPT id=IBI_nlsVars type=text/javascript src="/ibi_html/javaassist/nlsvars.js"></SCRIPT>
 
<SCRIPT id=IBI_ibigbl type=text/javascript src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT>
 
<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
addIntlTranslatedJS("composertrans.js");
</SCRIPT>
<TITLE>HtmlPage</TITLE>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {
 
UpdateData();
 
// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload
</SCRIPT>
 
<SCRIPT for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" nextelementuniquenumber="1" thumbnailscale="4" elementtype="21" edaconnectionrequired="true">
<IFRAME style="Z-INDEX: 1; POSITION: absolute; WIDTH: 810px; HEIGHT: 560px; TOP: 180px; LEFT: 40px" id=report1 tabIndex=1 elementtype="2" requests_list="0" autoExecute="False" name="report1"></IFRAME>
<FORM style="Z-INDEX: 2; POSITION: absolute; WIDTH: 231px; HEIGHT: 142px; TOP: 30px; LEFT: 40px" id=form1 onsubmit="OnExecute(this);return false;" method=post requests_list="0" tempheight="142" tempwidth="231" fexlist_list="report1" form_newline_chain="1" default_slider_type="4" form_type="1" form_prompt_location="1" form_number_of_visible_rows="4" form_number_of_columns="4" vert_dist_between_controls="10" form_hor_dist_between_controls="10" form_dist_between_desc_and_input="10" name="form1">
<LABEL style="Z-INDEX: 5; POSITION: absolute; WIDTH: 36px; HEIGHT: 19px; CURSOR: default; TOP: 5px; LEFT: 5px" id=label1 tabIndex=4 for=listbox1 name="listbox1">CAR:</LABEL> 
<SELECT style="Z-INDEX: 6; POSITION: absolute; WIDTH: 194px; HEIGHT: 54px; TOP: 34px; LEFT: 5px" id=listbox1 tabIndex=5 multiple size=3 defaultlocation="0,0,54,174" boundtovariable="1" requiredfield="1" persistentuniqueid="compUid_1" name="listbox1"></SELECT> 
<INPUT style="Z-INDEX: 3; POSITION: absolute; BACKGROUND-COLOR: lavender; WIDTH: 38px; BACKGROUND-REPEAT: no-repeat; HEIGHT: 22px; TOP: 115px; LEFT: 5px" id=form1Submit tabIndex=2 value=" " type=submit StyleBack_rtFileName="htmlpathsub/javaassist/ibi/html/describe/run16.gif" name="submit1"> 
<INPUT style="Z-INDEX: 4; POSITION: absolute; BACKGROUND-COLOR: lavender; WIDTH: 38px; BACKGROUND-REPEAT: no-repeat; HEIGHT: 22px; TOP: 115px; LEFT: 48px" id=form1Reset tabIndex=3 value=" " type=reset StyleBack_rtFileName="htmlpathsub/javaassist/ibi/html/describe/reset.gif" name="reset1"></FORM>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden resourcectrlids="form1Submit;form1Reset">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=devarcs type=hidden name="ibiapp_app">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibic_server value=EDASERVE type=hidden isdataserversarea="1" name="ibic_server">
<xml id=focus_xmlelement>
<script type="text/xml">
	
<rootxmlnode focoption="_FOC_NULL">
		
<variables>
			
<variable controltype="9" parametercreatedinreslay="0" type="unresolved" desc="CAR:" name="CAR" default="" textvarname="" accept="0" select="1" create="1">
				
<link linktype="default" from="compUid_1">
					
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						
<data_info checkForDuplicateValues="0" displayfield="CAR" ibiformat="A16" datafield="CAR" datasource="CAR.mas" datatype="1" selectedvalue="" operation="OR" slider_range_from="" slider_range_to="" previewvalue="" sourcetype="typeMaster"></data_info></condition></link>
				
<requestid id="0"></requestid></variable></variables>
		
<input_controls>
			
<input_control bindcontrolid="compUid_1" elementtype="9" name="listbox1" id="listbox1" multiple="1" onetimepopulated="0">
				
<link linktype="default">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						
<data_info checkForDuplicateValues="0" datatype="1" datasource="CAR.mas" datafield="CAR.COMP.CAR" displayfield="CAR.COMP.CAR" addalloption="1" sourcetype="typeMaster" cacheruntimedata="0" dynalldisplayvalue="ALL" ibiformat="A16" dfformat="A16" accept="0" selectedvalue="" operation="OR">
							
<![CDATA[TABLE FILE CAR
SUM FST.CAR.COMP.CAR
 BY CAR.COMP.CAR
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control></input_controls>
		
<other_bound_objects></other_bound_objects>
		
<requests nextrequestsid="0">
			
<request requestid="0" targetname="report1" ibif_ex="report1" targettype="iframe" sourcetype="typeAdhocfex" activereport="0" compoundreport="0" reportcolumns="" reportrealcolumns="" ibiapp_app="">
				
<![CDATA[-* File bugrep34.fex
TABLE FILE CAR
PRINT SEG.WEIGHT
BY COUNTRY 
BY CAR
WHERE CAR EQ &CAR.(OR(FIND CAR IN CAR)).CAR:.;
END]]></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>


_______________________
*** WebFOCUS 8.1.05M ***
 
Posts: 196 | Location: London, UK | Registered: December 06, 2005Report This Post
Gold member
posted Hide Post
Hi Jack,

My test program is running in the same server with the production program. And I am sure the external procedures are working fine, because the production program is running without any issue. I just did copy production program and paste in the same server, and then ran it; however the drop down didn't work in the pasted program.


May

WebFOCUS 7.6.8 Servlet
- MRE/BID/Self Service/ReportCaster
- MS Windows Server 2003
- MS SQL Server 2005
- DataMigrator 7.6.9
 
Posts: 51 | Registered: December 15, 2006Report This Post
Virtuoso
posted Hide Post
To pierce the mystery shrouding the execution of the fex that returns the XML file to populate the dropdown:

You can add some scaffolding to the fex --
-WRITE statements to log what's going on as execution proceeds. You'll need a FILEDEF (and a -RUN) at the top, to provide access to the log file. Use the MOD keyword, so the -WRITE's will extend the log file.

You can thus reveal whether it ran at all, whether the TABLE request completed, and what values wound up in &LINES and &FOCERRNUM.

If that checks out, then you know the HTML (and supporting JavaScript library functions) are fumbling.


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Platinum Member
posted Hide Post
Hi Jack and May,
Have finally got to the bottom of this after extensive trawling through Tomcat logs.It appears that the servlet which is responsible for retrieving the values for the controls in HTML pages could not be loaded during startup of Tomcat.

INFO: Marking servlet RemoteValues as unavailable

java.lang.ClassNotFoundException: com.ibi.remotecall.RemoteValues

The above class should be in
WebFOCUS77\webapps\webfocus\WEB-INF\lib\com_ibi_remotecall.jar.

Please check, if the above jar file is located in the WEB-INF\lib folder.

Once I copied in this file - BINGO !! Why it wasn't there in the first place is a mystery.
Ian


_______________________
*** WebFOCUS 8.1.05M ***
 
Posts: 196 | Location: London, UK | Registered: December 06, 2005Report This Post
Platinum Member
posted Hide Post
Now I know why the file went missing....bloody Big McAfee !!

Symptom:
HTML form drop downs are not populating.
Problem:
McAfee Antivirus software was performing a file scan (DAT version prior to
7097) falsely flagging the com_ibi_remotecall.jar file as a virus which caused
McAfee to delete the file.
Solution:
The dynamically populated controls on the HTML pages were not populating. The
following was performed to address this issue:
1. Download the McAfee fix that is listed for the correct version which can
be reached by logging into http://techsupport.informationbuilders.com and
click on "Download" menu item.
2. Added the com_ibi_remotecall.jar in the
ibi\WebFOCUS77\webapps\webfocus\WEB-INF\lib folder.
3. Re-start the Application Server (ie Tomcat) and Developer Studio.

com_ibi_remotecall.jar is applicable to Windows installations of WebFOCUS and
Developer Studio. When downloading the McAfee patch, refer to the readme file.


_______________________
*** WebFOCUS 8.1.05M ***
 
Posts: 196 | Location: London, UK | Registered: December 06, 2005Report 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] populate the dropdown

Copyright © 1996-2020 Information Builders