[PROBLEM IDENTIFIED] FILENAME xxxxxxxx SPECIFIED BY -HTMLFORM COULD NOT BE FOUND - Topic

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 Forums

Hop To Forum Categories

WebFOCUS/FOCUS Forum on Focal Point

[PROBLEM IDENTIFIED] FILENAME xxxxxxxx SPECIFIED BY -HTMLFORM COULD NOT BE FOUND

Read-Only Topic

Go

Search

Notify

Tools

Personal Zone	»
Member Directory
Focal Point Forums	»

Add to My Favorites

Printer Friendly Format

[PROBLEM IDENTIFIED] FILENAME xxxxxxxx SPECIFIED BY -HTMLFORM COULD NOT BE FOUND

Master

posted

Folks,

We just upgraded from WF 7702 to WF7704M server. There is no 7704 client, so we have installed 7703 with hotfix 6.

From our main menu page we have two types of hyperlinks: 1) those that link directly to FEXs that do not require any parameters and 2) those that link to other html pages that prompt for the parameters for various reports.

The first type of link (no parameters) works just fine. The second one gives the error that is the subject of this discussion.

I have a case open and the folks at IBI have been extraordinarily helpful given that they are all swimming while holding a cellphone to their ear, holding their laptops above the waves in the right and typing with their left. So far I've been in touch over about 9 hours with 5 really knowledgeable experts and right now they appear to be stumped.

We have, of course, checked all the normal stuff - permissions, APP PATH etc etc. But if anyone has seen this before all assistance would be gratefully received.

Thanks!

This message has been edited. Last edited by: George Patton,

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Report This Post

Expert

posted

Can you give some examples of the link to the HTML page that prompt ?

Where are the HTML pages stored ?

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Report This Post

Ignored post by Waz posted

Master

posted

The html pages are stored in the same directory as the fexes.

As a test we made a very simple fex in the car directory:

TABLE FILE CAR
SUM SALES BY COUNTRY BY CAR
WHERE COUNTRY EQ '&COUNTRY';
END

And then we made a super simple htmlform to provide the prompt:

<!-- 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
 
//Begin function button1_onclick
function button1_onclick(ctrl) {
// TODO: Add your event handler code here
OnExecute(ctrl)
}
//End function button1_onclick
</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">
<INPUT style="Z-INDEX: 1; POSITION: absolute; WIDTH: 100px; HEIGHT: 80px; TOP: 250px; LEFT: 150px" id=button1 language=javascript tabIndex=1 onclick=button1_onclick(this) value=Button type=button autoExecute="false" requests_list="0" name="button1"> 
<FORM style="Z-INDEX: 2; POSITION: absolute; WIDTH: 212px; HEIGHT: 110px; TOP: 70px; LEFT: 110px" id=form1 method=post tempheight="110" tempwidth="212" fexlist_list="button1" 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: 4; POSITION: absolute; WIDTH: 67px; HEIGHT: 19px; TOP: 5px; CURSOR: default; LEFT: 5px" id=label1 tabIndex=3 for=edit1 name="edit1">COUNTY</LABEL>
<SELECT style="POSITION: absolute; WIDTH: 175px; TOP: 34px; LEFT: 5px" id=edit1 tabIndex=4 size=1 CHECKED="false" indeterminate="false" start="fileopen" width="0" loop="1" vspace="0" maxLength="2147483647" hspace="0" readOnly="false" defaultselection="1" defaultlocation="0,0,22,155" boundtovariable="1" requiredfield="1" persistentuniqueid="compUid_1" name="edit1"></SELECT>
<INPUT style="Z-INDEX: 3; POSITION: absolute; BACKGROUND-COLOR: lavender; WIDTH: 38px; BACKGROUND-REPEAT: no-repeat; HEIGHT: 22px; TOP: 83px; LEFT: 5px" id=form1Reset tabIndex=2 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="form1Reset">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=ibisamp 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" nextelementuniquenumber="2">
<rootxmlnode focoption="_FOC_NULL">
<variables>
<variable controltype="7" parametercreatedinreslay="0" type="unresolved" desc="COUNTY" name="COUNTY" default="" textvarname="" accept="0" select="0" 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="COUNTY" datafield="COUNTY" datasource="car.mas" datatype="0" selectedvalue="" operation="" 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="8" name="edit1" id="edit1" multiple="0" onetimepopulated="0">
<link linktype="default" persistentuniqueid="compUid_1">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" datatype="1" datasource="car.mas" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" operation="NONE" modifiedrequest="0" ibiformat="A10" dfformat="A10" datafield="CAR.ORIGIN.COUNTRY" displayfield="CAR.ORIGIN.COUNTRY">
<![CDATA[TABLE FILE car
SUM FST.CAR.ORIGIN.COUNTRY
 BY CAR.ORIGIN.COUNTRY
-*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" sourcetype="typeFex" targettype="window" targetname="_blank" ibif_ex="newfex.fex" activereport="0" reportcolumns="" reportrealcolumns="" ibiapp_app="ibisamp"></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>

Running from DevStudio gives:
(FOC36223) FILENAME newhtm1 SPECIFIED BY -HTMLFORM COULD NOT BE FOUND

Now I should perhaps point out that if I run any of the fexes directly the autoprompting for parameters works just fine.

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Report This Post

Ignored post by George Patton posted

Expert

posted

They are stored on the server ?

Have you thought about deleting lines till there is nothing or it works to see if womthing in the HTML file is causing the problem

Perhaps have a newhtm1 file that just says "hello", ultra simple.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Report This Post

Ignored post by Waz posted

Guru

posted

Hi George,

I have several links that run html pages that require parameters and they work fine. I would bet this is another bug with the 7704 upgrade. We did the 7704 upgrade last week and it messed up so many things and made our employee directory unusable. NOPRINTS were displaying, it was ugly. After opening a few cases and working with IBI we ended up going back to 7703. There really was no rhyme or reason, sometimes things would work other times they didn't but it couldn't be resolved after two days of trying. We were told by IBI it had to be a bug. So we have HF6 and 7703 and will do no more upgrades until we get 8. I know this doesn't solve your problem but maybe it will save you some time beating your head against the wall trying to figure out why it's not working.
Take Care, Michelle.

WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML

Posts: 272 | Location: Kalamazoo, Michigan | Registered: September 30, 2010

Report This Post

Ignored post by MAdams1 posted

Guru

posted

Okay George,
I ran your code and it didn't work, it opened a new page with auto prompting when I clicked the Button. So I copied it and made it work and here is my code if you want to compare. I put both into Beyond Compare and found only a few minor differences. One being that you have County instead of Country in this line of code;

 
<data_info checkForDuplicateValues="0" displayfield="COUNTY" datafield="COUNTY" datasource="car.mas" datatype="0" selectedvalue="" operation="" slider_range_from="" slider_range_to="" previewvalue="" sourcetype="typeMaster"></data_info></condition></link>
<requestid id="0">

My Code;

 
<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
 
//Begin function button1_onclick
function button1_onclick(ctrl) {
// TODO: Add your event handler code here
OnExecute(ctrl)
}
//End function button1_onclick
</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">
<INPUT style="Z-INDEX: 1; POSITION: absolute; WIDTH: 100px; HEIGHT: 80px; TOP: 250px; LEFT: 150px" id=button1 language=javascript tabIndex=1 onclick=button1_onclick(this) value=Button type=button autoExecute="false" requests_list="2" name="button1"> 
<FORM style="Z-INDEX: 2; POSITION: absolute; WIDTH: 212px; HEIGHT: 110px; TOP: 70px; LEFT: 110px" id=form1 method=post requests_list="2" tempheight="110" tempwidth="212" fexlist_list="button1" 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: 4; POSITION: absolute; WIDTH: 67px; HEIGHT: 19px; TOP: 5px; CURSOR: default; LEFT: 5px" id=label1 tabIndex=3 for=edit1 name="edit1">COUNTY</LABEL> 
<SELECT style="POSITION: absolute; WIDTH: 175px; TOP: 34px; LEFT: 5px" id=edit1 tabIndex=4 size=1 CHECKED="false" indeterminate="false" start="fileopen" width="0" loop="1" vspace="0" maxLength="2147483647" hspace="0" readOnly="false" defaultselection="1" defaultlocation="0,0,22,155" boundtovariable="1" requiredfield="1" persistentuniqueid="compUid_1" name="edit1"></SELECT> 
<INPUT style="Z-INDEX: 3; POSITION: absolute; BACKGROUND-COLOR: lavender; WIDTH: 38px; BACKGROUND-REPEAT: no-repeat; HEIGHT: 22px; TOP: 83px; LEFT: 5px" id=form1Reset tabIndex=2 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>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=michelle 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" nextelementuniquenumber="2">
	
<rootxmlnode focoption="_FOC_NULL" top="100" left="10" width="150" height="130">
		
<variables>
			
<variable controltype="7" parametercreatedinreslay="0" type="unresolved" desc="COUNTRY" name="COUNTRY" default="" textvarname="" accept="0" select="0" 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="COUNTRY" ibiformat="A10" datafield="COUNTRY" datasource="car.mas" datatype="0" selectedvalue="" operation="" slider_range_from="" slider_range_to="" previewvalue="" sourcetype="typeMaster"></data_info></condition></link>
				
<requestid id="2"></requestid></variable></variables>
		
<input_controls>
			
<input_control bindcontrolid="compUid_1" elementtype="8" name="edit1" id="edit1" multiple="0" onetimepopulated="0" inbinding="1" top="20" left="30" width="60" height="20">
				
<link linktype="default" persistentuniqueid="compUid_1">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						
<data_info checkForDuplicateValues="0" datatype="1" datasource="CAR.mas" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" operation="NONE" modifiedrequest="0" ibiformat="A10" dfformat="A10" datafield="CAR.ORIGIN.COUNTRY" displayfield="CAR.ORIGIN.COUNTRY" selectedvalue="" ibiapp_app="michelle">
							
<![CDATA[TABLE FILE CAR
SUM FST.CAR.ORIGIN.COUNTRY
 BY CAR.ORIGIN.COUNTRY
-*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="2">
			
<request requestid="2" sourcetype="typeFex" targettype="window" targetname="_blank" ibif_ex="newfex.fex" activereport="0" reportcolumns="" reportrealcolumns="" ibiapp_app="michelle"></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>

Hope it helps.
Michelle

WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML

Posts: 272 | Location: Kalamazoo, Michigan | Registered: September 30, 2010

Report This Post

Ignored post by MAdams1 posted

Master

posted

All files are stored on the server in the same directory.

I created hello.htm using DevStudio and hello2.htm by hand coding.

hello2.htm:

<HTML>
<BODY>
"HELLO"
</BODY>
</HTML>

Result:
Works fine when run on the local machine. Does not when run on the server:
(FOC36223) FILENAME hello2 SPECIFIED BY -HTMLFORM COULD NOT BE FOUND

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Report This Post

Ignored post by George Patton posted

Master

posted

No joy Michelle:

(FOC36223) FILENAME madams SPECIFIED BY -HTMLFORM COULD NOT BE FOUND

It's interesting what you say about rolling back to 7703. However we are specifically targeting 7704 because of the improved support for EXL07 (pure binary Excel) output that we need to make WebFOCUS work properly with OpenOffice / Lotus Symphony / other ODF-compliant software. IBI has been working on this diligently since Summit and they say that decent functionality should be there by now.

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Report This Post

Ignored post by George Patton posted

Guru

posted

Sounds like you are in a pickle, needing 7704. I wish I could help more.
Sounds like a bug to me.

WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML

Posts: 272 | Location: Kalamazoo, Michigan | Registered: September 30, 2010

Report This Post

Ignored post by MAdams1 posted

Virtuoso

posted

How are you calling these html forms?
There must be some line saying -HTMLFORM hello2.htm somewhere, and what's doing that (obviously) isn't able to find the html file.

Are the HTML form-files in your application path?
What does:

WHENCE hello2 HTML

print if you run that from the command console (Dev Studio)?

N.B. I just found that WHENCE ... HTML works, although it isn't mentioned as an option in the Help file!

WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :

Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010

Report This Post

Ignored post by Wep5622 posted

Francis Mariani

Expert

posted

I have worked in a multi-tier environment where html pages in MRE called by HTMLFORM also have to be on the repoting server. So, two copies of the .htm file - one in an MRE domain and the other in an app folder - make a change in MRE, save, then drag-n-drop into the app folder.

Just my tuppence.

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

Report This Post

Ignored post by Francis Mariani posted

Expert

posted

If something is issueing a -HTMLFORM, then its FOCUS code, and the htm file must be FILEDEF'ed.

How is the web page called ?

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Report This Post

Ignored post by Waz posted

Master

posted

We are still having immense problems with this upgrade - and still get the FILENAME xxxxxxSPECIFIED BY -HTMLFORM COULD NOT BE FOUND message.

This is very frustrating, because the Reporting Server is working fine and finally is able to produce pure binary Excel output that works flawlessly in OpenOffice / Lotus Symphony.

If I create a new html form with a single control that points to a FEX in the same directory I cannot run it from Dev Studio without getting the message. I CAN run it from the browser, but of the link points to anoter form or a FEX with -HTMLFORM filename I get another bunch of errors.

Very, very frustrating. Between me and my Linux expert we have spent orobably a hundred hours on this install with still no solution in sight.

Waz: I would be interested to see how you would FILEDEF an html form ....

We have in the past been calling the second html form via a link from the main menu. What I want to do now is replace all those links with a lidtbox (or several llistboxes) that have as a parameter ReportNumber. The run button would launch a fex that has a -GOTO ReportNumber and a label for each report, thus:

-GOTO &ReportNumber

-RPT01
-HTMLFORM launch_reportXXX.htm
-EXIT

RPT02
-HTMLFORM launch_reportYYY.htm
-EXIT

etc.

This message has been edited. Last edited by: George Patton,

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Report This Post

Ignored post by George Patton posted

Expert

posted

Where is the HTML located ?

The technique is th FILEDEF the HTML file to a DDNAME, then issue the -HTMLFORM {DDNAME}.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Report This Post

Ignored post by Waz posted

Master

posted

The html files are located in the same directory as all the fexes, in this case /approot/chemomenu

This worked fine under 7702, but is broken with the upgrade to 7704 with the 7703 client.

Under 7702 we got the error message when running directly from the editor page of DevStudio, but things ran fine from the explorer page or when using the web browser.

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Report This Post

Ignored post by George Patton posted

Expert

posted

So what happens if you use this code ?

FILEDEF RTNHTML DISK chemomenu/launch_reportXXX.htm

-RUN

-HTMLFORM RTNHTML

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Report This Post

Ignored post by Waz posted

Master

posted

(FOC36223) FILENAME RTNHTML SPECIFIED BY -HTMLFORM COULD NOT BE FOUND

I'm going to bed now .....

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Report This Post

Ignored post by George Patton posted

Expert

posted

But its only 2 in the afternoon.....

What if you FILEDEF'd with the full path, and what is one of the HTM files names ?

Could there also be some security issue here, so it can't read it ?

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Report This Post

Ignored post by Waz posted

Guru

posted

This happened to us when we "upgraded" to 7.7. I found that if I made my HTMLFORM filenames no more than 8 characters long, it would work. Luckily, we were still in development mode at the time and didn't have too many .HTM files to rename.

Webfocus 8
Windows, Linux

Posts: 258 | Location: Palm Coast, FL | Registered: February 05, 2010

Report This Post

Ignored post by Mike in DeLand posted

Platinum Member

posted

I was just about to post pretty much what Mike has said.
Somewhere between versions we also encountered issues with:
- The "app" directory name was > 8 chars e.g. chemomenu is 9
- The actual HTML file name was > 8 chars (the part preceding e.g. .htm)
- Case sensitivity of the file names

WebFOCUS 8.2.06 mostly Windows Server

Posts: 195 | Location: Johannesburg, South Africa | Registered: September 13, 2008

Report This Post

Ignored post by Twanette posted

Expert

posted

George tried a short name before with no luck.

Time for Tracing ??

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Report This Post

Ignored post by Waz posted

Master

posted

We have been through the issue of short file names and it made no difference - this is something that has theoretically been fixed in the build version we are using.

But today I did make some headway.

The problem is definitely something to do with the path where WF thinks the graphical elements reside.

Here is a shot of the a launch page inside of Developer Studio. I'm working on the X in the corner to close this form and return to the home page.

Normally I would just click the down arrow in the Actions column and choose HTML Page from the options. Select it and up pops up a box under Source where all the .htm files in my application reside (same folder as the FEXs).

But if I do that and try to run the launch page I get the -HTMLFORM cannot be found error message.

However, if I specify URL instead of HTML, and type in the URL as /approot/chemo/home.htm in the Source box it behaves properly - closes this form and returns to the menu.

Similarly, when I want to incorporate a background graphic, like the run button, I get the option in DevStudio to simply pick it from a list - because all the graphics are in the same directory as the FEXs and HTM files. But if I simply choose it from the list and save, it doesn't show up. I have to type in the specific URL for the graphical element: /approot/chemo/RunButton48px.png

So..... it looks like either we need to put the graphical elements in a different directory or figure out how to get WF to recognise that they are all in the same directory, (which is normal when the report server and the client are on the same machine.)

This message has been edited. Last edited by: George Patton,

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Report This Post

Ignored post by George Patton posted

Master

posted

After spending something like 25 hours on the phone to IBI tech support - who were as always very helpful - we remained baffled by this issue until my colleague ran some traces.

He has discovered that after restarting the reporting server EDASERVE finds the correct .htm file the FIRST time it is requested, but on subsequent requests it substitutes .XML instead of .HTM - and of course no such file exists:

After restarting EDASERVE the trace log correctly shows the htm extension the FIRST time (and only the FIRST time) it looks for the file.

15.09.36 AT ioh_nextDir:      tagname=APPPATH , tagelm=chemomenu, location=/home/iadmin/test/ibi/apps77/chemomenu, app
n=chemomenu, subdir=NULL
15.09.36 AT fcbfndopn:        ioh_nextDir returned 0
15.09.36 AT fcbfndopn:        ioh_nextDir returned loc=/home/iadmin/test/ibi/apps77/chemomenu, ind=0
15.09.36 AT r1pathnm:         result is
15.09.36 AT r1pathnm:         result is
15.09.36 AT fcbfndopn:        str=/home/iadmin/test/ibi/apps77/chemomenu/launch_cust_b2calyr.htm
15.09.36 AT r1fopen:          calling fopen( /home/iadmin/test/ibi/apps77/chemomenu/launch_cust_b2calyr.htm, r )
15.09.36 AT fcbfndopn:        f_fopen with mode= returned 7616736
15.09.36 AT fcbfndopn:        rc=1

On SUBSEQUENT requests after the first one EDASERVE is looking for files with a non-existent file extension:

14.55.25 AT fcbfndopn:        ioh_nextDir returned 0
14.55.25 AT fcbfndopn:        ioh_nextDir returned loc=/home/iadmin/test/ibi/apps77/chemomenu, ind=0
14.55.25 AT r1pathnm:         result is
14.55.25 AT r1pathnm:         result is
14.55.25 AT fcbfndopn:        str=/home/iadmin/test/ibi/apps77/chemomenu/launch_cust_b2calyr.xml
14.55.25 AT r1fopen:          calling fopen( /home/iadmin/test/ibi/apps77/chemomenu/launch_cust_b2calyr.xml, rb )
14.55.25 AT r1trcerr:         fopen: err#2, No such file or directory

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Report This Post

Ignored post by George Patton posted

Expert

posted

Hopefully IBI can repro and find what going on.

Perhaps a different version may work ?

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Report This Post

Ignored post by Waz posted

Master

posted

It looks like a serious programming or configuration bug to me. I hope they can fix it right away - our users haven't been able to run reports for two weeks. (I can run them, because autoprompt still works - and ReportCaster is doing just fine).

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Report This Post

Ignored post by George Patton posted

Expert

posted

This is on the linux version isn't it.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Report This Post

Ignored post by Waz posted

Master

posted

Yes

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Report This Post

Ignored post by George Patton posted

Expert

posted

I guess this doesn't occur in other platforms, as we would have hear about it.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Report This Post

Ignored post by Waz posted

Powered by Social Strata

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point Forums

Hop To Forum Categories

WebFOCUS/FOCUS Forum on Focal Point

[PROBLEM IDENTIFIED] FILENAME xxxxxxxx SPECIFIED BY -HTMLFORM COULD NOT BE FOUND

Focal Point | Privacy Statement | Terms of Service

Copyright © 1996-2020 Information Builders

	View $GS_USERNAME's Public Profile
	Add $GS_USERNAME to my Ignore ListRemove $GS_USERNAME from my Ignore List
	View Recent Posts by $GS_USERNAME
	Notify me of New Posts by $GS_USERNAME

New Since your Last Visit