[CLOSED] populate the dropdown

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, 2005

Ignored post by j.gross posted

Platinum Member

posted

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, 2005

Ignored post by Ian Dalton posted

Platinum Member

posted

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, 2005

Ignored post by Ian Dalton posted

j.gross

Virtuoso

posted

revise the post -- add surrounding [ code ] tags.

Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005

Ignored post by j.gross posted

Platinum Member

posted

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, 2005

Ignored post by Ian Dalton posted

May

Gold member

posted

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, 2006

Ignored post by May posted

j.gross

Virtuoso

posted

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, 2005

Ignored post by j.gross posted

Platinum Member

posted

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, 2005

Ignored post by Ian Dalton posted

Platinum Member

posted

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, 2005

Ignored post by Ian Dalton posted