<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=iso-2022-jp">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"MS PGothic";
panose-1:2 11 6 0 7 2 5 8 2 4;}
@font-face
{font-family:"\@MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
{font-family:"\@MS PGothic";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"MS PGothic",sans-serif;
mso-fareast-language:JA;}
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.EmailStyle20
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.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="1027" />
</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-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi Darren,<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">That’s not a lot to go on.<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">As a guess there is some condition that occurs that allows your procedure to branch into a rarely executed section of code which contains the syntactic error that causes this popup. For example a deadlock may
occur, your procedure freaks. In this case you would see some deadlock errors reported in the errlog.<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">Have you tried correlating errors in the errlog with the failed execution of this procedure?<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">Martin Bowes<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 #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="mso-fareast-language:JA">From:</span></b><span lang="EN-US" style="mso-fareast-language:JA"> Darren Harvey <Darren.Harvey@fusion5.com.au>
<br>
<b>Sent:</b> 29 April 2020 04:44<br>
<b>To:</b> info-ingres@lists.planetingres.org<br>
<b>Subject:</b> [Info-ingres] Occasional SELECT statement error.<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-AU">Hi All<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU">We are getting the following popup message occasionally at customers sites. The process that calls the procedure that contains the SELECT statement (screenshot below) is an end of week process, and we have customers
who run the process without the error for lots of weeks, and then one week they get the error message, and then the next time they run the process there is no popup error message.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU">Does anyone have any suggestions/thoughts as to why this problem doesn’t occur every time the process is run, but is just an occasional problem?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU">Thanks<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
<div style="border:none;border-bottom:solid windowtext 1.0pt;padding:0cm 0cm 1.0pt 0cm">
<p class="MsoNormal"><span lang="EN-AU">Darren<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU">Error Message<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><img width="461" height="252" style="width:4.802in;height:2.625in" id="Picture_x0020_6" src="cid:image009.jpg@01D61DFB.C257D060"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU">SELECT statement in procedure that is getting error.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><img width="790" height="286" style="width:8.2291in;height:2.9791in" id="Picture_x0020_5" src="cid:image010.jpg@01D61DFB.C257D060"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU">The ACTIAN Generic Error Code for -3200 is described as follows:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><img width="646" height="93" style="width:6.7291in;height:.9687in" id="Picture_x0020_7" src="cid:image011.jpg@01D61DFB.C257D060"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%;background:white;border-collapse:collapse;margin-left:-2.25pt;margin-right:-2.25pt">
<tbody>
<tr>
<td style="padding:12.0pt 12.0pt 24.0pt 12.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="0" style="width:300.0pt;background:white;border-collapse:collapse;margin-left:-2.25pt;margin-right:-2.25pt">
<tbody>
<tr>
<td width="403" style="width:450.0pt;border:none;border-top:solid #FD7B23 1.0pt;padding:7.5pt 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-element:frame;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<b><span style="font-size:15.0pt;color:#3A444A;mso-fareast-language:EN-AU">Darren Harvey
<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width="403" style="width:450.0pt;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-element:frame;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<b><span style="font-size:10.5pt;color:#3A444A;mso-fareast-language:EN-AU">Senior Developer
<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width="403" style="width:450.0pt;padding:7.5pt 0cm 3.75pt 0cm">
<p class="MsoNormal" style="mso-element:frame;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<b><span style="font-size:10.5pt;color:#3A444A;mso-fareast-language:EN-AU">M</span></b><span style="font-size:10.5pt;color:#3A444A;mso-fareast-language:EN-AU"> +61 400 398 188<br>
<b>P </b>+61 3 9922 5519<br>
<b>Teams or Skype for Business ID</b> <a href="mailto:darren.harvey@fusion5.com.au">
darren.harvey@fusion5.com.au</a> <o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="403" style="width:450.0pt;border:none;border-bottom:solid #FD7B23 1.0pt;padding:3.75pt 0cm 3.75pt 0cm">
<p class="MsoNormal" style="mso-element:frame;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:10.5pt;color:#3A444A;mso-fareast-language:EN-AU"><a href="https://www.fusion5.com.au?utm_source=F5-Int.Sig&utm_medium=email&utm_campaign=AskUs2020/" target="_blank"><span style="color:#3A444A">www.fusion5.com.au</span></a>
<a href="https://www.linkedin.com/company/fusion5" target="_blank"><span style="font-size:11.0pt;color:black;mso-fareast-language:EN-US;text-decoration:none"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter" />
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0" />
<v:f eqn="sum @0 1 0" />
<v:f eqn="sum 0 0 @1" />
<v:f eqn="prod @2 1 2" />
<v:f eqn="prod @3 21600 pixelWidth" />
<v:f eqn="prod @3 21600 pixelHeight" />
<v:f eqn="sum @0 0 1" />
<v:f eqn="prod @6 1 2" />
<v:f eqn="prod @7 21600 pixelWidth" />
<v:f eqn="sum @8 21600 0" />
<v:f eqn="prod @7 21600 pixelHeight" />
<v:f eqn="sum @10 21600 0" />
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect" />
<o:lock v:ext="edit" aspectratio="t" />
</v:shapetype><v:shape id="_symprex_t1" o:spid="_x0000_s1026" type="#_x0000_t75" style='position:absolute;margin-left:0;margin-top:0;width:50pt;height:50pt;z-index:251659264;visibility:hidden;mso-width-percent:0;mso-height-percent:0;mso-wrap-distance-left:9pt;mso-wrap-distance-top:0;mso-wrap-distance-right:9pt;mso-wrap-distance-bottom:0;mso-position-horizontal:absolute;mso-position-horizontal-relative:text;mso-position-vertical:absolute;mso-position-vertical-relative:text;mso-width-percent:0;mso-height-percent:0;mso-width-relative:page;mso-height-relative:page'>
<o:lock v:ext="edit" aspectratio="f" selection="t" />
</v:shape><![endif]--></span><span style="color:#3A444A;text-decoration:none"><img border="0" width="79" height="20" style="width:.8229in;height:.2083in" id="_symprex_i0001" src="cid:image013.png@01D61DFB.C257D060"></span></a></span><span style="color:black"><a href="https://www.instagram.com/jemini_hrpayroll_software/" target="_blank"><span style="font-size:10.5pt;color:#3A444A;mso-fareast-language:EN-AU;text-decoration:none"><img border="0" width="103" height="20" style="width:1.0729in;height:.2083in" id="_symprex_i0002" src="cid:image014.png@01D61DFB.C257D060"></span></a></span><span style="font-size:10.5pt;color:#3A444A;mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="403" style="width:450.0pt;padding:7.5pt 0cm 7.5pt 0cm">
<p class="MsoNormal" style="mso-element:frame;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="color:black"><a href="http://business.fusion5.com.au/HCM2020?utm_source=F5-Int.Sig&utm_medium=email&utm_campaign=HCM2020Conf"><span style="font-size:10.5pt;color:#3A444A;mso-fareast-language:EN-AU;text-decoration:none"><img border="0" width="400" height="150" style="width:4.1666in;height:1.5625in" id="_symprex_i0003" src="cid:image015.jpg@01D61DFB.C257D060"></span></a></span><span style="font-size:10.5pt;color:#3A444A;mso-fareast-language:EN-AU">
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="403" style="width:450.0pt;padding:7.5pt 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-element:frame;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<b><span style="font-size:10.5pt;color:#3A444A;mso-fareast-language:EN-AU">Fusion5 |</span></b><span style="font-size:10.5pt;color:#3A444A;mso-fareast-language:EN-AU"> Level 27, 570 Bourke Street, Melbourne, 3000, Australia<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="403" style="width:450.0pt;padding:3.75pt 0cm 0cm 0cm">
<p class="MsoNormal" style="margin-bottom:12.0pt;mso-element:frame;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:9.0pt;color:#3A444A;mso-fareast-language:EN-AU">This email and any attachments are confidential and intended exclusively for the person to whom the email is addressed. Please see our
<a href="https://www.fusion5.com.au/privacy-policy/" target="_blank"><span style="color:#3A444A">Privacy Policy</span></a> <o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-element:frame;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:9.0pt;color:#3A444A;mso-fareast-language:EN-AU">Are you interested in Fusion5’s COVID-19 business update?</span><span lang="JA" style="font-size:9.0pt;font-family:"MS Mincho";color:#3A444A;mso-fareast-language:JA"> </span><span style="font-size:9.0pt;color:#3A444A;mso-fareast-language:EN-AU"> </span><span style="font-size:7.5pt;color:#3A444A;mso-fareast-language:EN-AU"><br>
</span><span style="font-size:9.0pt;color:#3A444A;mso-fareast-language:EN-AU">Please visit
<a href="https://www.fusion5.com.au/covid-19-update/"><span style="color:#0066CC">https://www.fusion5.com.au/covid-19-update/</span></a><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span lang="EN-AU"><o:p> </o:p></span></p>
</div>
</body>
</html>