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.
ThanksThis 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
February 06, 2014, 03:11 PM
j.gross
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
February 07, 2014, 05:57 AM
Ian Dalton
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">
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
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
February 07, 2014, 02:28 PM
j.gross
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
February 19, 2014, 08:53 AM
Ian Dalton
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.
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 ***
February 20, 2014, 10:45 AM
Ian Dalton
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.