<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Arial Rounded MT Bold";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:932009319;
mso-list-type:hybrid;
mso-list-template-ids:247395710 269025295 269025305 269025307 269025295 269025305 269025307 269025295 269025305 269025307;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.25in;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:1.25in;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.75in;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.25in;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:2.75in;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.25in;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.75in;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:4.25in;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>How long does it take for the message to be returned?<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>The PH Web Server Timeout is set in the Administrator PHWebServer Properties dialog. It is the amount of time that the Dispatcher waits for the PH Web Server to complete a task. If the task takes too long, the Dispatcher assumes that the PH Web Server has run into problems and shuts it down. The default timeout is 5 minutes. If you’ve lowered the value, maybe it’s too low for the process you’re trying to do.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Bob<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='color:#1F497D'>Bob Deskin<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>PowerHouse Consultant<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>UNICOM Global<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><a href="mailto:bob.deskin@unicomglobal.com">bob.deskin@unicomglobal.com</a><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>(973) 526-3856<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>This message (including any attachments) contains confidential information that is PRIVILEGED, CONFIDENTIAL and/or ATTORNEY WORK PRODUCT and is intended only for the individual(s) named herein. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this message in error, please notify the UNICOM Systems, Inc. Postmaster (<a href="mailto:postmaster@unicomsi.com">postmaster@unicomsi.com</a>) of the error immediately, do not read or use the email and any attachments in any manner, destroy all copies, and delete it from your system if the communication was sent via email. UNICOM Systems, Inc. (818) 838-0606 Fax: (818) 838-0776<o:p></o:p></span></p></div><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> powerh-l-bounces+bob.deskin=unicomglobal.com@lists.sowder.com [mailto:powerh-l-bounces+bob.deskin=unicomglobal.com@lists.sowder.com] <b>On Behalf Of </b>Thomson, Martyn<br><b>Sent:</b> Friday, August 15, 2014 12:37 PM<br><b>To:</b> powerh-l@lists.sowder.com<br><b>Subject:</b> The request failed because the PowerHouse Web Server ConnectionTimeout has expired<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-CA>Hey Listers!<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA>I have a PH Web screen (8.40G) using a union view of several tables/views that somehow trips up the PH Web server. Here is the generalised view definition:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-CA>create view LINKAGE_UNION_VIEW<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> (FLD1,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> FLD2,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> EFFECTIVE_YYMM,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> TERMINATE_YYMM,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> DB_PERCENT,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> CURRENT_FLAG) as<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> select C2.FLD1, C2.FLD2, C2.EFFECTIVE_YYMM, C2.TERMINATE_YYMM,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> C2.DB_PERCENT, C2.CURRENT_FLAG<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> from CURRENT_VIEW C2<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> union distinct<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> select C3.FLD1, C3.FLD2, C3.EFFECTIVE_YYMM, C3.TERMINATE_YYMM,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> C3.DB_PERCENT, C3.CURRENT_FLAG<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> from TERMINATED_VIEW C3<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> union distinct<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> select C4.FLD1, C4.FLD2, C4.EFFECTIVE_YYMM, C4.TERMINATE_YYMM,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> C4.DB_PERCENT, 'C'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> from LINKAGE_1_TABLE C4<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> where (C4.TERMINATE_YYMM <= '000000')<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> union distinct<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> select C5.FLD1, C5.FLD2, C5.EFFECTIVE_YYMM, C5.TERMINATE_YYMM,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> C5.DB_PERCENT, 'T'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> from LINKAGE_1_TABLE C5<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> where (C5.TERMINATE_YYMM > '000000')<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> union distinct<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> select C6.FLD1, C6.FLD2, C6.EFFECTIVE_YYMM, C6.TERMINATE_YYMM,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> C6.DB_PERCENT, 'C'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> from LINKAGE_2_TABLE C6<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> where (C6.TERMINATE_YYMM <= '000000')<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> union distinct<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> select C7.FLD1, C7.FLD2, C7.EFFECTIVE_YYMM, C7.TERMINATE_YYMM,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> C7.DB_REPORTING_PERCENT, 'T'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> from LINKAGE_2_TABLE C7<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> where (C7.TERMINATE_YYMM > '000000')<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA> order by 2 asc, 6 asc, 1 asc;<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-CA>Data is retrieved by providing a value for FLD2.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA>CURRENT_VIEW and TERMINATED_VIEW are both views of a third table, differentiated on TERMINATE_YYMM. <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA>The corresponding attributes of each table/view are the same and use the same domain definitions. <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA>Whenever there’s data originating from table LINKAGE_1_TABLE it always gives the connection timeout error. <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-CA>Things I’ve tried: <o:p></o:p></span></p><p class=MsoListParagraph style='margin-left:.25in;text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span lang=EN-CA><span style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-CA>The error has nothing to do with amount of data returned. So long as there’s none from LINKAGE_1_TABLE the view works for one or hundreds of rows;<o:p></o:p></span></p><p class=MsoListParagraph style='margin-left:.25in;text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span lang=EN-CA><span style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-CA>changed order of tables in view definition. No effect;<o:p></o:p></span></p><p class=MsoListParagraph style='margin-left:.25in;text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span lang=EN-CA><span style='mso-list:Ignore'>3.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-CA>For a FLD2 value with no LINKAGE_2_TABLE data, moved data from table LINKAGE_1_TABLE to LINKAGE_2_TABLE. Still get error;<o:p></o:p></span></p><p class=MsoListParagraph style='margin-left:.25in;text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span lang=EN-CA><span style='mso-list:Ignore'>4.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-CA>For a FLD2 value with no LINKAGE_1_TABLE data, moved data from table LINKAGE_2_TABLE to LINKAGE_1_TABLE. No error;<o:p></o:p></span></p><p class=MsoListParagraph style='margin-left:.25in;text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span lang=EN-CA><span style='mso-list:Ignore'>5.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-CA>3 and 4 imply data is corrupted. Used DUMP/REC to look at LINKAGE_1_TABLE in Hex. Nothing unusual about it;<o:p></o:p></span></p><p class=MsoListParagraph style='margin-left:.25in;text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span lang=EN-CA><span style='mso-list:Ignore'>6.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-CA>This is the only PH Web screen we have using data from LINKAGE_1_TABLE;<o:p></o:p></span></p><p class=MsoListParagraph style='margin-left:.25in;text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span lang=EN-CA><span style='mso-list:Ignore'>7.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-CA>The protection on LINKAGE_1_TABLE is no different than the other tables;<o:p></o:p></span></p><p class=MsoListParagraph style='margin-left:.25in;text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span lang=EN-CA><span style='mso-list:Ignore'>8.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span lang=EN-CA>Same view used in QUICK, QUIZ or SQL has no problem retrieving data. Only PowerHouse Web server coughs.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-CA>Anyone seen this before? Is it because each of 3 tables is defined twice in the view? <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA>Losing hair here! Any suggestions much appreciated.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA><o:p> </o:p></span></p><p class=MsoNormal style='margin-top:6.0pt'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-CA'>Using PH 8.4G, OpenVMS 8.3, Oracle Rdb SQL V7.2<o:p></o:p></span></p><p class=MsoNormal style='margin-top:6.0pt'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-CA'>Regards, <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA style='font-family:"Arial Rounded MT Bold";color:#1F497D;mso-fareast-language:EN-CA'>Martyn Thomson<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA style='font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-CA'>Senior Technical Analyst, Development Services</span><span lang=EN-CA style='font-family:"Arial Rounded MT Bold";color:#1F497D;mso-fareast-language:EN-CA'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA style='font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-CA'>Information Technology Services<o:p></o:p></span></p><p class=MsoNormal><b><i><span style='font-size:14.0pt;color:#003D83;mso-fareast-language:EN-CA'>HP Advanced Solutions Inc.<o:p></o:p></span></i></b></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-CA'>phone: 250.405.4555 | fax: 250.405.4422</span><span lang=EN-CA style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-CA'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-CA'>email:<a href="mailto:martyn.thomson@hpadvancedsolutions.com">martyn.thomson@hpadvancedsolutions.com</a> </span><span lang=EN-CA style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-CA'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-CA'>web: <a href="http://www.hpadvancedsolutions.com/">www.hpadvancedsolutions.com</a> <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-CA><o:p> </o:p></span></p></div></body></html>
<pre>This e-mail message has been scanned and cleared by Postini / Google Message Security and the UNICOM Global security systems. This message is for the named person's use only. If you receive this message in error, please delete it and notify the sender.