Host was not found error in PH Web
Edis, Bob
bob.edis@fleetpride.com
Fri, 27 Jul 2001 11:25:24 -0500
I found the problem!!!! Well actually our admin guy did.
One the new box the TCP/IP DNS domain name was missing the '.com' from the
end of it. We added this and all the screens work hunky dory now.
Blue
-----Original Message-----
From: Edis, Bob [mailto:bob.edis@fleetpride.com]
Sent: Friday, July 27, 2001 11:07 AM
To: 'powerh-l@list.swau.edu'
Subject: RE: Host was not found error in PH Web
Thanks for the info Bob and that's great about the change in version ?. I
just read in the latest SupportLink about the new stuff in the next version
of PH Web. This is very good. When we be able to get our hands on this
version?
Both machines are being accessed via intranet and yes, there are two
separate web servers, one for production and one for test/dev. Could the
problem have anything to do with how the intranet is accessing the web
server on the machine with the problem? Could some proxy configuration
being set wrong somewhere? The proxy server is on a separate box altogether
but I have set the web browser to bypass the proxy server for local
addresses. Could the new box be seen as non-local perhaps?
Regards,
Blue
-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
Sent: Friday, July 27, 2001 11:01 AM
To: 'powerh-l@list.swau.edu'
Subject: RE: Host was not found error in PH Web
As for the deployment issue, yes, you would have to recompile based on the
deploy PHCGI if your development and production environments use different
PHCGI locations, which probably means different web servers. We are doing
something about this for next time because we had a number of suggestions
(okay - complaints). The next version will be quite flexible this way.
What you can do is compile one set with the SET HTTP and have a copy
without. Use conditional compile around the SET HTTP to control whether it's
included or not. Yes, it's a bit of a kludge but it's the best I can suggest
for now.
As for why there's a problem on one machine versus the other, it's hard to
pinpoint without knowing the exact configuration. The issue generally seems
to be whether you're on an intranet versus the internet. Early on we were
using the Server_Name variable as the prefix to the phcgi name when we
constructed the DEFER LINKSCREEN request stream. And in fact that's how it's
documented in the manual. However that caused problems on intranets and at
times if you were doing everything on one machine. I'm not sure of all the
technical details. We changed to use the HOSTNAME variable. Part of the
problem was what gets added automatically by the web server if you don't
specify an absolute phcgi location starting with http://. In any case, using
the HOSTNAME can cause problems on an internet setup where you're going
across machines.
For the next release you'll be able to specify which of Server_Name or
HostName to use. In addition, you'll be able to identify the PHCGI location
with a name (as in SET HTTP TEST) and then specify the value of the name as
a program parameter at run time. This will allow you to compile and test on
one platform and deploy to another without recompiling.
Bob
-----Original Message-----
From: Edis, Bob [mailto:bob.edis@fleetpride.com]
Sent: Friday, July 27, 2001 9:48 AM
To: 'powerh-l@list.swau.edu'
Subject: RE: Host was not found error in PH Web
You are right Bob, of course. Simply recompiling does not help as I tried
that to no avail. However I still have the problem of recompiling all the
screens on the new box. Now the problem is we only have a development
license on one of the boxes so now we have a change control issue - we can't
use the same compiled QKC file on both boxes due to the SET HTTP string
differences.
I still would like to know why this is a problem on only one of the two
machines when other than name they are set a the same way.
Regards,
Blue
-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
Sent: Friday, July 27, 2001 5:40 AM
To: 'Edis, Bob'; 'powerh-l@list.swau.edu'
Subject: RE: Host was not found error in PH Web
Glad the problem's solved. I don't believe simply recompiling the screen
would make a difference. We do not pick up any local machine information
because then you'd have to recompile when you deployed.
Page 81 of the PH Web Guide (part #27845) discusses PHCGI locations. I do
have a note for the next version of the book to discuss this aspect in more
detail as well as describing how server versus host names are used.
Bob
-----Original Message-----
From: Edis, Bob [mailto:bob.edis@fleetpride.com]
Sent: July 26, 2001 5:28 PM
To: 'powerh-l@list.swau.edu'
Subject: RE: Host was not found error in PH Web
That worked. However I don't know if it was the added syntax or that fact I
had to recompile the screen on the test box. As I will have to recompile
all the screens after including this syntax, I will never really know what
fixed the problem, the SET HTTP statement or the recompile. :(
Thanks for the quidence Bob. Can I suggest that the next version's
documentation show this better? The copy I have mentions the SET HTTP on
page 204 but doesn't indicate where it should be placed in the source code
or show an example.
Regards,
Blue
-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
Sent: Thursday, July 26, 2001 3:20 PM
To: 'powerh-l@list.swau.edu'
Subject: RE: Host was not found error in PH Web
That depends on what you need to do. PH Web is flexible enough to allow you
to deal with multiple web servers (and therefore multiple phcgi locations).
For the purposes of the test, put it just before the DEFER LINKSCREEN.
Bob
-----Original Message-----
From: Edis, Bob [mailto:bob.edis@fleetpride.com]
Sent: Thursday, July 26, 2001 4:06 PM
To: 'powerh-l@list.swau.edu'
Subject: RE: Host was not found error in PH Web
Thanks Bob, I'll try it and let you know.
Where exactly does this SET HTTP statement go, in the procedure just prior
to the DEFER LINKSCREEN statement or at the start of the code prior to the
SCREEN statement?
Blue
-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
Sent: Thursday, July 26, 2001 2:55 PM
To: 'powerh-l@list.swau.edu'
Subject: RE: Host was not found error in PH Web
I suspect it's the DEFER LINKSCREEN processing that's causing the problem.
We've seen this before. Try using the SET HTTP statement to specify the
complete path to the PHCGI as in
"HTTP://web-server-machine-root/cgi-bin/phcgi.exe". What may be happening is
that the hostname is being used instead of the server name. In the next
release, we'll have a parameter to let you specify which to use, but in the
mean time you'll have to "hard code it".
Bob
-----Original Message-----
From: Edis, Bob [mailto:bob.edis@fleetpride.com]
Sent: Thursday, July 26, 2001 3:41 PM
To: 'powerh-l@list.swau.edu'
Subject: RE: Host was not found error in PH Web
G'day Bob
The web server is on a different machine. The setup is three machines,
data, web and app servers. IIS and the PHCGI stuff is on the web server.
PH Web, PH, the dispatcher, etc. are all on the app server.
ALL the screens are behaving the same way.
Here is the report section from the HTML of one of them:
<!--PH:REPORT-->
<center>
<font size="+3"></font>
<table border="1" width="594">
<tr>
<td width="84">Corp Cust Id</td>
<td width="278">Corp Cust Name</td>
<td width="157">City</td>
<td width="47">State</td>
</tr>
<!--PH:REPORTDATA:MAX=10-->
<tr>
<td width="84">
<A
HREF="/cgi-bin/phcgi.exe?PH_HTML=cc_vw_corp_cust.htm&PH_QKC=cc_vw_corp_c
ust&PH_APP=CorpCust_App&PH_SEARCH=<!--PH:LINKVALUE:PH_SEARCH-->&
PH_ACTION=LoadData&CORP_CUSTOMER:corp_cust_Id=<!--PH:LINKVALUE:CORP_CUST
OMER:corp_cust_Id-->"> <!--PH:VALUE:CORP_CUSTOMER:corp_cust_Id-->
</a>
</td>
<td width="278"><!--PH:VALUE:CORP_CUSTOMER:corp_cust_name--></td>
<td width="157"><!--PH:VALUE:CORP_CUSTOMER:corp_cust_city--></td>
<td width="47"><!--PH:VALUE:CORP_CUSTOMER:corp_cust_state--></td>
</tr>
<!--PH:/REPORTDATA-->
</table>
<!--PH:REPORTPREVIOUS-->
<A
HREF="/cgi-bin/phcgi.exe?PH_HTML=cc_vw_corp_cust.htm&PH_QKC=cc_vw_corp_c
ust&PH_APP=CorpCust_App&PH_SEARCH=<!--PH:LINKVALUE:PH_SEARCH-->&
PH_ACTION=LoadPage&PH_LOADID=<!--PH:VALUE:PH_LOADID-->"> <<
Previous Result
</A>
<!--PH:/REPORTPREVIOUS-->
<!--PH:REPORTNEXT-->
<A
HREF="/cgi-bin/phcgi.exe?PH_HTML=cc_vw_corp_cust.htm&PH_QKC=cc_vw_corp_c
ust&PH_APP=CorpCust_App&PH_SEARCH=<!--PH:LINKVALUE:PH_SEARCH-->&
PH_ACTION=LoadPage&PH_LOADID=<!--PH:VALUE:PH_LOADID-->"> Next Result
>>
</A>
<!--PH:/REPORTNEXT-->
</center>
<br>
<br>
<!--PH:VALUE:PH_MSG-->
<br>
<!--PH:/REPORT-->
And here is the POSTPATH procedure from the same screen. This is used to
populate the search screen with the values selected from the search results
list.
PROCEDURE POSTPATH
BEGIN
IF PROMPTOK FOR corp_cust_id OF corp_customer &
AND t_flag NE "Y"
THEN BEGIN
LET t_flag = "Y"
DEFER LINKSCREEN cc_vw_corp_cust &
ACTION "loaddata" &
PASSING corp_cust_id, t_flag, &
t_inv_doc_type, t_cc_central_invoice, &
t_statement_field
END
END
Blue
-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
Sent: Thursday, July 26, 2001 2:32 PM
To: 'powerh-l@list.swau.edu'
Subject: RE: Host was not found error in PH Web
Is this a self-contained test or is the web server on a different box than
PH Web? Is this a straight link or are you using DEFER LINKSCREENS?
Bob Deskin
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
-----Original Message-----
From: Edis, Bob [mailto:bob.edis@fleetpride.com]
Sent: Thursday, July 26, 2001 3:21 PM
To: 'powerh-l@list.swau.edu'
Subject: Host was not found error in PH Web
G'day all
PowerHouse 4GL 8.21D
PowerHouse Web 2.21D
Windows NT 4.0 sp6
IIS 4.0
We have replicated our PH Web environment on a test box. We copied the
programs, source and compiled, Quick and HTML, from the production box to
the test box. The IIS configuration and PH Web dispatcher configuration are
identical on both machines other than references to host machine names.
Here is the problem:
We open a screen from a HTML menu page and click on the Search button. A
list of records is returned with the key item hilited so we can select a
particular record. In the production system we are returned to the first
screen with the fields filled in using the record selected from the list.
On the test box we get a Proxy error:
Proxy Reports:
11001 Host was not found
The host specified in your URL could not be found.
This error could have been caused by:
* Bad / misspelled URL
* Following an invalid link
* Your network connection and/or transient conditions on the Internet
The host specified in the URL is the same that allowed into the first search
screen so that's OK.
Any ideas where we should look to find the source of the problem?
Regards to all,
Blue
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.