<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";
panose-1:2 15 7 4 3 5 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
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;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
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;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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:18.0pt;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:54.0pt;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:90.0pt;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:126.0pt;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:162.0pt;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:198.0pt;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:234.0pt;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:270.0pt;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:306.0pt;
text-indent:-9.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></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-CA" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi Bob.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Times out immediately. When the data is good its returned within 5 secs. The message is misleading. Its not a timeout issue.
<o:p></o:p></span></p>
<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 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Bob Deskin [mailto:bob.deskin@unicomglobal.com]
<br>
<b>Sent:</b> August-15-14 9:47 AM<br>
<b>To:</b> Thomson, Martyn; powerh-l@lists.sowder.com<br>
<b>Subject:</b> RE: 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-US" style="color:#1F497D">How long does it take for the message to be returned?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" 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 lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Bob<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Bob Deskin<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">PowerHouse Consultant<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">UNICOM Global<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" 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 lang="EN-US" style="color:#1F497D">(973) 526-3856<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" 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 lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
<a href="mailto:powerh-l-bounces+bob.deskin=unicomglobal.com@lists.sowder.com">powerh-l-bounces+bob.deskin=unicomglobal.com@lists.sowder.com</a> [<a href="mailto:powerh-l-bounces+bob.deskin=unicomglobal.com@lists.sowder.com">mailto:powerh-l-bounces+bob.deskin=unicomglobal.com@lists.sowder.com</a>]
<b>On Behalf Of </b>Thomson, Martyn<br>
<b>Sent:</b> Friday, August 15, 2014 12:37 PM<br>
<b>To:</b> <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><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"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal">Hey Listers!<o:p></o:p></p>
<p class="MsoNormal">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></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">create view LINKAGE_UNION_VIEW<o:p></o:p></p>
<p class="MsoNormal"> (FLD1,<o:p></o:p></p>
<p class="MsoNormal"> FLD2,<o:p></o:p></p>
<p class="MsoNormal"> EFFECTIVE_YYMM,<o:p></o:p></p>
<p class="MsoNormal"> TERMINATE_YYMM,<o:p></o:p></p>
<p class="MsoNormal"> DB_PERCENT,<o:p></o:p></p>
<p class="MsoNormal"> CURRENT_FLAG) as<o:p></o:p></p>
<p class="MsoNormal"> select C2.FLD1, C2.FLD2, C2.EFFECTIVE_YYMM, C2.TERMINATE_YYMM,<o:p></o:p></p>
<p class="MsoNormal"> C2.DB_PERCENT, C2.CURRENT_FLAG<o:p></o:p></p>
<p class="MsoNormal"> from CURRENT_VIEW C2<o:p></o:p></p>
<p class="MsoNormal"> union distinct<o:p></o:p></p>
<p class="MsoNormal"> select C3.FLD1, C3.FLD2, C3.EFFECTIVE_YYMM, C3.TERMINATE_YYMM,<o:p></o:p></p>
<p class="MsoNormal"> C3.DB_PERCENT, C3.CURRENT_FLAG<o:p></o:p></p>
<p class="MsoNormal"> from TERMINATED_VIEW C3<o:p></o:p></p>
<p class="MsoNormal"> union distinct<o:p></o:p></p>
<p class="MsoNormal"> select C4.FLD1, C4.FLD2, C4.EFFECTIVE_YYMM, C4.TERMINATE_YYMM,<o:p></o:p></p>
<p class="MsoNormal"> C4.DB_PERCENT, 'C'<o:p></o:p></p>
<p class="MsoNormal"> from LINKAGE_1_TABLE C4<o:p></o:p></p>
<p class="MsoNormal"> where (C4.TERMINATE_YYMM <= '000000')<o:p></o:p></p>
<p class="MsoNormal"> union distinct<o:p></o:p></p>
<p class="MsoNormal"> select C5.FLD1, C5.FLD2, C5.EFFECTIVE_YYMM, C5.TERMINATE_YYMM,<o:p></o:p></p>
<p class="MsoNormal"> C5.DB_PERCENT, 'T'<o:p></o:p></p>
<p class="MsoNormal"> from LINKAGE_1_TABLE C5<o:p></o:p></p>
<p class="MsoNormal"> where (C5.TERMINATE_YYMM > '000000')<o:p></o:p></p>
<p class="MsoNormal"> union distinct<o:p></o:p></p>
<p class="MsoNormal"> select C6.FLD1, C6.FLD2, C6.EFFECTIVE_YYMM, C6.TERMINATE_YYMM,<o:p></o:p></p>
<p class="MsoNormal"> C6.DB_PERCENT, 'C'<o:p></o:p></p>
<p class="MsoNormal"> from LINKAGE_2_TABLE C6<o:p></o:p></p>
<p class="MsoNormal"> where (C6.TERMINATE_YYMM <= '000000')<o:p></o:p></p>
<p class="MsoNormal"> union distinct<o:p></o:p></p>
<p class="MsoNormal"> select C7.FLD1, C7.FLD2, C7.EFFECTIVE_YYMM, C7.TERMINATE_YYMM,<o:p></o:p></p>
<p class="MsoNormal"> C7.DB_REPORTING_PERCENT, 'T'<o:p></o:p></p>
<p class="MsoNormal"> from LINKAGE_2_TABLE C7<o:p></o:p></p>
<p class="MsoNormal"> where (C7.TERMINATE_YYMM > '000000')<o:p></o:p></p>
<p class="MsoNormal"> order by 2 asc, 6 asc, 1 asc;<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Data is retrieved by providing a value for FLD2.<o:p></o:p></p>
<p class="MsoNormal">CURRENT_VIEW and TERMINATED_VIEW are both views of a third table, differentiated on TERMINATE_YYMM.
<o:p></o:p></p>
<p class="MsoNormal">The corresponding attributes of each table/view are the same and use the same domain definitions.
<o:p></o:p></p>
<p class="MsoNormal">Whenever there’s data originating from table LINKAGE_1_TABLE it always gives the connection timeout error.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Things I’ve tried: <o:p></o:p></p>
<p class="MsoListParagraph" style="margin-left:18.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo2">
<![if !supportLists]><span style="mso-list:Ignore">1.<span style="font:7.0pt "Times New Roman"">
</span></span><![endif]>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></p>
<p class="MsoListParagraph" style="margin-left:18.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo2">
<![if !supportLists]><span style="mso-list:Ignore">2.<span style="font:7.0pt "Times New Roman"">
</span></span><![endif]>changed order of tables in view definition. No effect;<o:p></o:p></p>
<p class="MsoListParagraph" style="margin-left:18.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo2">
<![if !supportLists]><span style="mso-list:Ignore">3.<span style="font:7.0pt "Times New Roman"">
</span></span><![endif]>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></p>
<p class="MsoListParagraph" style="margin-left:18.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo2">
<![if !supportLists]><span style="mso-list:Ignore">4.<span style="font:7.0pt "Times New Roman"">
</span></span><![endif]>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></p>
<p class="MsoListParagraph" style="margin-left:18.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo2">
<![if !supportLists]><span style="mso-list:Ignore">5.<span style="font:7.0pt "Times New Roman"">
</span></span><![endif]>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></p>
<p class="MsoListParagraph" style="margin-left:18.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo2">
<![if !supportLists]><span style="mso-list:Ignore">6.<span style="font:7.0pt "Times New Roman"">
</span></span><![endif]>This is the only PH Web screen we have using data from LINKAGE_1_TABLE;<o:p></o:p></p>
<p class="MsoListParagraph" style="margin-left:18.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo2">
<![if !supportLists]><span style="mso-list:Ignore">7.<span style="font:7.0pt "Times New Roman"">
</span></span><![endif]>The protection on LINKAGE_1_TABLE is no different than the other tables;<o:p></o:p></p>
<p class="MsoListParagraph" style="margin-left:18.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo2">
<![if !supportLists]><span style="mso-list:Ignore">8.<span style="font:7.0pt "Times New Roman"">
</span></span><![endif]>Same view used in QUICK, QUIZ or SQL has no problem retrieving data. Only PowerHouse Web server coughs.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Anyone seen this before? Is it because each of 3 tables is defined twice in the view?
<o:p></o:p></p>
<p class="MsoNormal">Losing hair here! Any suggestions much appreciated.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-top:6.0pt"><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">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 lang="EN-US" style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">Regards,
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial Rounded MT Bold","sans-serif";color:#1F497D">Martyn Thomson<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:#1F497D">Senior Technical Analyst, Development Services</span><span style="font-family:"Arial Rounded MT Bold","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif";color:#1F497D">Information Technology Services<o:p></o:p></span></p>
<p class="MsoNormal"><b><i><span lang="EN-US" style="font-size:14.0pt;color:#003D83">HP Advanced Solutions Inc.<o:p></o:p></span></i></b></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">phone: 250.405.4555 | fax: 250.405.4422</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">email:<a href="mailto:martyn.thomson@hpadvancedsolutions.com">martyn.thomson@hpadvancedsolutions.com</a>
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">web:
<a href="http://www.hpadvancedsolutions.com/">www.hpadvancedsolutions.com</a> <o:p>
</o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<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. <o:p></o:p></pre>
<pre><o:p> </o:p></pre>
</div>
</body>
</html>