Focal Point
[CLOSED] Extra port added to Excel url

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/728105822

September 03, 2009, 05:33 AM
Fazlina
[CLOSED] Extra port added to Excel url
we are creating a Java application, from where we call the WFServlet to create the report. Instead of exposing the WFServlet directly, we have created a wrapper servlet that extends ibi.webfoc.WFServlet and internally it calls super.doPost().

While we generate the excel report, it creates the url with extra port 8036 along with the domain.

https://domain:8036/nxpReporti...=GETBINARY&PG_File=p
vyjesqi.xht

With this port we are not able to generate the report.
Can anyone please clarify why and from where this port is getting generated and is getting appended to the url.

This message has been edited. Last edited by: Kerry,
September 03, 2009, 07:13 AM
GamP
Usually the url created by WFServlet is a relative url which is appended to a kind of base url. This base url is a value that can be obtained by querying the browser. If you do not want or need that, you can set the focexurl variable to override this.
If you want to know more, do a search on FOCEXURL in this forum.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
September 03, 2009, 07:38 AM
Fazlina
Yes it is getting the base url from the browser. But it appends the port (which is not used in our application and dont know how that port is determined ) to that url.

we are giving this url as an input for window.open when generating the excel file.
September 04, 2009, 11:25 AM
dlogan
As GamP points out, the WebFOCUS references are all relative. If that port is being tacked on, its probably because of your application.

If you actually run an HTTP Trace with a tool like Fiddler2 .

You will see that when you submit a request to the WFServlet for a PDF or XLS it actually creates a simple page like the following:

<HTML>
              <Head>
                <Title>WebFOCUS Report</Title>
                	
                <Script Language="JavaScript">
                <!--
                 function getrep()
                     {
                   if(parseInt(window.navigator.appVersion,10)<4)
                     location.assign("/ibi_apps/WFServlet?PG_REQTYPE=REDIRECT&PG_MRsaved=false&PG_Func=GETBINARY&PG_File=dduxkwqx.pdf");
                   else
                     location.replace("/ibi_apps/WFServlet?PG_REQTYPE=REDIRECT&PG_MRsaved=false&PG_Func=GETBINARY&PG_File=dduxkwqx.pdf");
                 } //-->
             </Script></Head>
             <body onload="getrep()"></BODY>
           </HTML><!--
0 NUMBER OF RECORDS IN TABLE=       18  LINES=     18
0 HOLDING PDF FILE ON PC DISK ...

WebFOCUS Version 7.6.8 compiled and linked on Tue Dec 30 00:34:32 EST 2008 (Gen branch768:141)
-->


That page then redirects to the actual output.

As you can see from this output, the references are completely relative.

I suppose it is always possible if you're using an older release of WebFOCUS that this is not relative in an older release, but I'm pretty sure this goes back some time.

If you add your WebFOCUS release to your signature it would be much easier to assist you with things like this with answers that are release specific.

Thanks,
Doug Logan


WF 71.x, 76.x, 7701, 8.0 Beta OS: Linux, Win2k3, Win2k, Win2k8, WinXP