[SOLVED] FOC227 Error recieved in explorer but not firefox or chrome

Hello,

Wanted to see if anyone else out there has run into this problem and if so, what they might have done to fix it.

Currently, I have an HTML form that can be used to view, modify, add or delete records. The form is using basic SQL in a focus procedure.
I had to add "ibihttpxml" which allows me to query XML data retrieved from a .fex and populate the text boxes with the queried data.
Similar to the code below, which was provided to me courtesy of WAZ.

The code works great in firefox and chrome - I was able to take the example and work it into my code to do what I need it to do.
Unfortunately, the same code produces a FOC227 error when I attempt to view the records. It claims that it cannot find the .fex that calls the data.

Question of the day: Why would this work in both firefox and chrome, and not in explorer?

If anyone has any thoughts on this, I would greatly appreciate.
Thanks in advance for any help that anyone can offer.

Example code:

HTML part: (fp_xmlhttp.html)
You will have to change the IBIAPP_app to your location.

< !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
 <head>
  <title> My Report </title>
  <meta http-equiv="CACHE-CONTROL" content="NO-CACHE">
  <script id=IBI_OptionsScript type=text/javascript>
    var ibiOptions = new Array("ibihttpxml") ;
  </script>
  <script type="text/javascript" language="Javascript" src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT>
  <script type="text/javascript">
   < !--
    function funGetData() {
     var ibihttp = new ibihttpxml("/ibi_apps/WFServlet",null) ;
     ibihttp.openFromForm(document.forms.My_Form) ;
     alert(ibihttp.xmlhttp.responseText) ;
     var CtySales = ibihttp.selectSingleNode("//fxf/report/table/tr/td");
     document.getElementById("SALES").value = ibihttp.getNodeText(CtySales) ;
    }
   //-->
  </script>
 </head>

 <body onload="">
  <form method="post" name="My_Form">
   <table>
    <tr>
     <td>Country</td><td><input type=text name="COUNTRY" value="ENGLAND"></td>
    </tr>
    <tr>
     <td>Sales</td><td><input type=text name="SALES" id="SALES"></td>
    </tr>
    <tr>
     <td><input type=button value="Get Sales" onclick="funGetData[)"></td>
     <td></td>
    </tr>
   </table>
   <input type=hidden name="IBIF_ex" value="fp_xmlhttp">
   <input type=hidden name="IBIAPP_app" value="focalpoint">
 </form>
 </body>
</html>

Fex part: (fp_xmlhttp.fex)

TABLE FILE CAR
SUM SALES
WHERE COUNTRY EQ '&COUNTRY'
ON TABLE PCHOLD FORMAT XML
END

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

WebFOCUS 8008
Windows, All Outputs

Posts: 26 | Registered: October 11, 2010

Waz

Expert

posted

Hide Post

Please use the code tags around your code.

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

Ignored post by Waz posted

Show Post

Waz

Expert

posted

Hide Post

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
 <head>
  <base href="http://localhost:8080">
  <title> My Report </title>
  <meta http-equiv="CACHE-CONTROL" content="NO-CACHE">
  <script id=IBI_OptionsScript type=text/javascript>
    var ibiOptions = new Array("ibihttpxml") ;
  </script>
  <script type="text/javascript" language="Javascript" src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT>
  <script type="text/javascript">
   <!--
    function funGetData() {
     var ibihttp = new ibihttpxml("/ibi_apps/WFServlet",null) ;
     ibihttp.openFromForm(document.forms.My_Form) ;
     alert(ibihttp.xmlhttp.responseText) ;
     var CtySales = ibihttp.selectSingleNode("//fxf/report/table/tr/td");
     document.getElementById("SALES").value = ibihttp.getNodeText(CtySales) ;
    }
   //-->
  </script>
 </head>

 <body onload="">
  <form method="post" name="My_Form">
   <table>
    <tr>
     <td>Country</td><td><input type=text name="COUNTRY" value="ENGLAND"></td>
    </tr>
    <tr>
     <td>Sales</td><td><input type=text name="SALES" id="SALES"></td>
    </tr>
    <tr>
     <td><input type=button value="Get Sales" onclick="funGetData()"></td>
     <td></td>
    </tr>
   </table>
   <input type=hidden name="IBIF_ex" value="fp_xmlhttp">
   <input type=hidden name="IBIAPP_app" value="focalpoint">
 </form>
 </body>
</html>

Works for me with IE 6.

What version of ie are you using ?

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

Ignored post by Waz posted

Show Post

Tony A

Expert

posted

Hide Post

Also works OK in IE8 on 7.6.10

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

Wep5622

Virtuoso

posted

Hide Post

We had a very similar issue recently, although with normal reports. It started out with just a few specific fexes that couldn't be found, but after a while it couldn't even find our site-wide launch fex anymore. But only with IE (6 & 7) - Firefox just worked.
I think it stopped happening after we restarted the server. Not really sure what cured it.

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

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

Ignored post by Wep5622 posted

Show Post

jhasty

Member

posted

Hide Post

Sorry about leaving out the code tags - still a newbie round these parts.

To be more specific, the sample code works just fine in IE, it is when I work in the sample code into my HTML form that I start getting the issue. It works great in firefox and chrome, but when I run my form in IE it says it cannot find the procedure is linked to my "run" button. I am running IE 8.0.7601.

If I go directly to the .fex and run it, the .fex runs without a problem in IE. But when I run the HTML form it says it cannot find app/myfex.fex - I have compared the code to previous versions that worked before I integrated the sample code above but I cannot seem to isolate the issue.

I know it is difficult to troubleshoot this without seeing the code in the context of how it's being used. I was just hoping that someone might have encountered this or a similar issue and might have found a fix for it.

Again I appreciate any further insight anyone is willing to offer.

Thank you.

WebFOCUS 8008
Windows, All Outputs

Posts: 26 | Registered: October 11, 2010

Ignored post by jhasty posted

Show Post

Waz

Expert

posted

Hide Post

I think the first check you need to do is add a submit button to the form, make sure you add action=/ibi_apps/WFServlet to the form.

Then run the html page, and hit the submit button, and see if it works.

If it does, then its something to do with xmlhttp.

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

Ignored post by Waz posted

Show Post

Wep5622

Virtuoso

posted

Hide Post

Is the fex in a location in the APPPATH at the server-side?

A difference in behaviour of how xmlhttp is issued between the different browsers could probably account for not sending the ibiapp_app path-string (as it appears in the form) when using IE. That would explain the issue if the focexec is not in the server's path.

The most peculiar thing about what we were seeing (assuming it's the same problem) is that it said it couldn't find focexec's that were actually in its path. So, the above doesn't explain what we were seeing, but maybe it does explain what the OP is seeing.
Our case is quite baffling and I think I'll subscribe it to a glitch. I suspect we had a misbehaving java process and we may have gotten fooled by our browser caches as well. It has happened from time to time, though.

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

Ignored post by Wep5622 posted

Show Post

jhasty

Member

posted

Hide Post

Thanks for the replies - I haven't had an opportunity to dig into this today, but will do some further investigation tomorrow and let you know what I find.
Thank you.

WebFOCUS 8008
Windows, All Outputs

Posts: 26 | Registered: October 11, 2010

Ignored post by jhasty posted

Show Post

jhasty

Member

posted

Hide Post

Update: I did as Waz suggested and added another submit button and connected it to my .fex. It reset a few things which I had to repair but this time through it seems to be working fine.

Not sure what the specific item was, but glad I was able to get it working.

Thanks everyone for your help.

WebFOCUS 8008
Windows, All Outputs

Posts: 26 | Registered: October 11, 2010

Ignored post by jhasty posted

Show Post

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point

Focal Point Forums

WebFOCUS/FOCUS Forum on Focal Point

[SOLVED] FOC227 Error recieved in explorer but not firefox or chrome

Focal Point | Privacy Statement | Terms of Service