<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;}
/* 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;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
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";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle24
{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:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></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">Thank-you for your suggestion!<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">I was looking for a Powerhouse *<b>E</b>* type error message. Turns out it was an
<b>%RDB-E-</b> error on a date conversion in a view.<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">Because the dozen QTP programs were being executed in the same QTP session, it just carries on regardless executing the others, then aborts when it exits back to DCL. Who knew!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I’ll split them up into separate “$ QTP auto=” statements so DCL will error out on the right one.<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">Thanks again Herald.<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""> Thomson, Martyn
<br>
<b>Sent:</b> August-24-15 11:21 AM<br>
<b>To:</b> 'HERALD KAFFKA'; 'powerh-l@lists.sowder.com'<br>
<b>Subject:</b> RE: Alpha to Itanium DCL issue<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">“com” is just a logical for the location of DCL command procedures. Used throughout the app.<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">I’ll try your suggestion of running each procedure from command line.<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""> HERALD KAFFKA [<a href="mailto:Herald.Kaffka@westfraser.com">mailto:Herald.Kaffka@westfraser.com</a>]
<br>
<b>Sent:</b> August-24-15 11:07 AM<br>
<b>To:</b> Thomson, Martyn; 'powerh-l@lists.sowder.com'<br>
<b>Subject:</b> RE: Alpha to Itanium DCL issue<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">RDB? Oracle? Or straight RMS/ISAM…<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">About 2 years ago we went through the same process (Large Powerhouse application => Alpha->Itanium).<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">App was a mix of Oracle and RMS/ISAM (mostly Oracle with a few legacy RMS files hanging around…). (No RDB).<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">Near Zero problems with the OS/Shell. (Alpha by default ran a stable sort, Itanium ran a unstable sort, so if
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Your quiz/qtp runs were sorting down x levels, and detail lines were at x+1, the order of the detail lines was
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Undetermined. (Subtotals were ok, ie Sort down to the level of a “parent company”, (say Home Depot), then<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Display sales to each individual store, subtotals/grand totals would all be good, but the order in which individual<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Stores printed out was random, (oracle returns data in a random order if you don’t explicitly sort, if you are using pure<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">RMS/ISAM you would be fine as RMS runs indexes and retrieves in order). “I think” there was a logical you could set<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">To force the old behavior, but as this only affected about 4 quiz/qtp runs out of hundreds, we simply added the last sort
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">level to reports. (Cleaner and easier to understand in the long run than using an invisible logical name out at the system level…).<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 was pretty much the only problem we ran into on this. (course we had moved from various VAXes in the past, and from
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">VAX to Alpha, so there is/was a pretty good abstraction layer setup in logical names to hide the physical hardware…).<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">“@com:proc2.com”;<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Is the @com in the above an “inhouse” symbol/procedure to run a command file? You might want to look at it if so, and see if it’s your problem…<o:p></o:p></p>
<p class="MsoNormal">If your routine is not too involved, you might want to step through processing one step at a time at the DCL command line to see if something
<o:p></o:p></p>
<p class="MsoNormal">Is getting trapped out (and/or confused) by something in the com file wrapper/driver…<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Just a few random thoughts… <span lang="EN-US" style="color:#1F497D">
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> <a href="mailto:powerh-l-bounces+herald.kaffka=westfraser.com@lists.sowder.com">
powerh-l-bounces+herald.kaffka=westfraser.com@lists.sowder.com</a> [<a href="mailto:powerh-l-bounces+herald.kaffka=westfraser.com@lists.sowder.com">mailto:powerh-l-bounces+herald.kaffka=westfraser.com@lists.sowder.com</a>]
<b>On Behalf Of </b>Thomson, Martyn<br>
<b>Sent:</b> Monday, August 24, 2015 12:03 PM<br>
<b>To:</b> 'powerh-l@lists.sowder.com' <<a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>><br>
<b>Subject:</b> Alpha to Itanium DCL issue<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal">Moving a large PowerHouse app from Alpha to Itanium. Getting strange behaviour with a DCL procedure terminating prematurely.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">DCL procedure proc1.com submitted;<o:p></o:p></p>
<p class="MsoNormal">Does a few things then executes proc2.com i.e. “@com:proc2.com”;<o:p></o:p></p>
<p class="MsoNormal">Proc2.com runs a dozen QTP programs then drops out to proc1.com prematurely! The QUIZ programs don’t get run; the reports aren’t printed;<o:p></o:p></p>
<p class="MsoNormal">On returning to proc1.com it immediately exits, not executing the remainder of proc1.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">All QTP/QUIZ were recompiled.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I added “on error then goto err_handler” to both procedures to display $status. Proc2 is terminating with %X1900802A. That’s a QTP error “A file access error has been detected, but the QTP program did write to the database the number
of records shown in the log. The protection on all tables it references is correct. There are no subfiles involved.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Has anyone seen this before? Very puzzled. Any insights, suggestions, etc much appreciated.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I should point out I searched the logs on the Alpha for this job. It happened once last month for the first time ever.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">OpenVMS 8.4<o:p></o:p></p>
<p class="MsoNormal">Oracle Rdb SQL V7.3-100<o:p></o:p></p>
<p class="MsoNormal">PowerHouse 8.40G<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">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>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p><span lang="EN-US"><br>
<br>
-------------EOP--------------- <br>
<br>
This e-mail message and any attachments are confidential. Any dissemination or use of this information by a person other than the intended recipient is unauthorized. If you are not the intended recipient, please notify me by return e-mail, do not open any attachment
and delete this communication and any copy. <br>
<br>
Thank you <o:p></o:p></span></p>
</div>
</body>
</html>