<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 PGothic";}
@font-face
{font-family:"\@MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"MS PGothic",sans-serif;
mso-fareast-language:JA;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:JA;}
span.EmailStyle22
{mso-style-type:personal-reply;
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-AU" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">The Procedure is an OpenRoad procedure, which I have attached.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">I have looked at the customers errlog.log file and there is nothing in it which corresponds with the timing of when the error occurred.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">Thanks for all the responses I’ve had.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">Cheers<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">Darren<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<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="400" style="width:300.0pt;background:white;border-collapse:collapse;margin-left:-2.25pt;margin-right:-2.25pt">
<tbody>
<tr>
<td width="600" 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;font-family:"Calibri",sans-serif;color:#3A444A;mso-fareast-language:EN-AU">Darren Harvey
<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width="600" 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;font-family:"Calibri",sans-serif;color:#3A444A;mso-fareast-language:EN-AU">Senior Developer
<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width="600" 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;font-family:"Calibri",sans-serif;color:#3A444A;mso-fareast-language:EN-AU">M</span></b><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;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> darren.harvey@fusion5.com.au <o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="600" 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;font-family:"Calibri",sans-serif;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:12.0pt;font-family:"MS PGothic",sans-serif;color:black;mso-fareast-language:JA;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:.825in;height:.2083in" id="_symprex_i0001" src="cid:image004.png@01D61ECA.627DFFA0"></span></a></span><span style="color:black"><a href="https://www.instagram.com/jemini_hrpayroll_software/" target="_blank"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:#3A444A;mso-fareast-language:EN-AU;text-decoration:none"><img border="0" width="103" height="20" style="width:1.075in;height:.2083in" id="_symprex_i0002" src="cid:image005.png@01D61ECA.627DFFA0"></span></a></span><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:#3A444A;mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="600" 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;font-family:"Calibri",sans-serif;color:#3A444A;mso-fareast-language:EN-AU;text-decoration:none"><img border="0" width="400" height="150" style="width:4.1666in;height:1.5666in" id="_symprex_i0003" src="cid:image006.jpg@01D61ECA.627DFFA0"></span></a></span><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:#3A444A;mso-fareast-language:EN-AU">
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="600" 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;font-family:"Calibri",sans-serif;color:#3A444A;mso-fareast-language:EN-AU">Fusion5 |</span></b><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;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="600" 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;font-family:"Calibri",sans-serif;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;font-family:"Calibri",sans-serif;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"> </span><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#3A444A;mso-fareast-language:EN-AU"> </span><span style="font-size:7.5pt;font-family:"Calibri",sans-serif;color:#3A444A;mso-fareast-language:EN-AU"><br>
</span><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;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>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><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="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Adrian Williamson <adrian.williamson@rationalcommerce.com>
<br>
<b>Sent:</b> Wednesday, 29 April 2020 6:26 PM<br>
<b>To:</b> Darren Harvey <Darren.Harvey@fusion5.com.au>; info-ingres@lists.planetingres.org; 'Martin Bowes' <martin.bowes@ndph.ox.ac.uk><br>
<b>Subject:</b> RE: [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-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">Hi Darren<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">Is that a table returning database procedure or OpenROAD?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">If the errlog provides no clues then I‘d be tempted to use PRINTQRY or the flight recorder to understand what arrived at the database
(if it is OpenROAD).<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">Can you show the full source of the procedure?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">Cheers<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US">Adrian<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US"><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="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">
<a href="mailto:info-ingres-bounces@lists.planetingres.org">info-ingres-bounces@lists.planetingres.org</a> <<a href="mailto:info-ingres-bounces@lists.planetingres.org">info-ingres-bounces@lists.planetingres.org</a>>
<b>On Behalf Of </b>Darren Harvey<br>
<b>Sent:</b> 29 April 2020 09:07<br>
<b>To:</b> <a href="mailto:info-ingres@lists.planetingres.org">info-ingres@lists.planetingres.org</a>; Martin Bowes <<a href="mailto:martin.bowes@ndph.ox.ac.uk">martin.bowes@ndph.ox.ac.uk</a>><br>
<b>Subject:</b> Re: [Info-ingres] Occasional SELECT statement error.<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Arial",sans-serif;color:black">Hi Martin<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Arial",sans-serif;color:black">Thanks for your response, and I had not thought of checking the errlog file, so I will get it and look for any errors at
the time the process is run.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Arial",sans-serif;color:black">Thanks<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Arial",sans-serif;color:black">Darren
<o:p></o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Arial",sans-serif;color:black">Get
<a href="https://aka.ms/ghei36">Outlook for Android</a><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center"><span lang="EN-GB">
<hr size="2" width="98%" align="center">
</span></div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> Martin Bowes <<a href="mailto:martin.bowes@ndph.ox.ac.uk">martin.bowes@ndph.ox.ac.uk</a>><br>
<b>Sent:</b> Wednesday, April 29, 2020 4:56:59 PM<br>
<b>To:</b> Darren Harvey <<a href="mailto:Darren.Harvey@fusion5.com.au">Darren.Harvey@fusion5.com.au</a>>;
<a href="mailto:info-ingres@lists.planetingres.org">info-ingres@lists.planetingres.org</a> <<a href="mailto:info-ingres@lists.planetingres.org">info-ingres@lists.planetingres.org</a>><br>
<b>Subject:</b> RE: [Info-ingres] Occasional SELECT statement error.</span><span lang="EN-GB">
<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span lang="EN-GB"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="xmsonormal"><span lang="EN-GB" style="color:#1F497D">Hi Darren,</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"><span lang="EN-GB" style="color:#1F497D"> </span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"><span lang="EN-GB" style="color:#1F497D">That’s not a lot to go on.</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"><span lang="EN-GB" style="color:#1F497D"> </span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"><span lang="EN-GB" 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.</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"><span lang="EN-GB" style="color:#1F497D"> </span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"><span lang="EN-GB" style="color:#1F497D">Have you tried correlating errors in the errlog with the failed execution of this procedure?</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"><span lang="EN-GB" style="color:#1F497D"> </span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"><span lang="EN-GB" style="color:#1F497D">Martin Bowes</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"><span lang="EN-GB" style="color:#1F497D"> </span><span lang="EN-GB"><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="xmsonormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Darren Harvey <<a href="mailto:Darren.Harvey@fusion5.com.au">Darren.Harvey@fusion5.com.au</a>>
<br>
<b>Sent:</b> 29 April 2020 04:44<br>
<b>To:</b> <a href="mailto:info-ingres@lists.planetingres.org">info-ingres@lists.planetingres.org</a><br>
<b>Subject:</b> [Info-ingres] Occasional SELECT statement error.</span><span lang="EN-GB"><o:p></o:p></span></p>
</div>
</div>
<p class="xmsonormal"><span lang="EN-GB"> <o:p></o:p></span></p>
<p class="xmsonormal">Hi All<span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal">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.<span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal">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?<span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal">Thanks<span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
<div style="border:none;border-bottom:solid windowtext 1.0pt;padding:0cm 0cm 1.0pt 0cm">
<p class="xmsonormal">Darren<span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
</div>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal">Error Message<span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"><img border="0" width="461" height="252" style="width:4.8in;height:2.625in" id="x_Picture_x0020_6" src="cid:image007.jpg@01D61ECA.627DFFA0"><span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal">SELECT statement in procedure that is getting error.<span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"><img border="0" width="790" height="286" style="width:8.225in;height:2.975in" id="x_Picture_x0020_5" src="cid:image008.jpg@01D61ECA.627DFFA0"><span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal">The ACTIAN Generic Error Code for -3200 is described as follows:<span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"><img border="0" width="646" height="93" style="width:6.725in;height:.9666in" id="x_Picture_x0020_7" src="cid:image009.jpg@01D61ECA.627DFFA0"><span lang="EN-GB"><o:p></o:p></span></p>
<p class="xmsonormal"> <span lang="EN-GB"><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">
<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="400" style="width:300.0pt;background:white;border-collapse:collapse">
<tbody>
<tr>
<td width="600" style="width:450.0pt;border:none;border-top:solid #FD7B23 1.0pt;padding:7.5pt 0cm 0cm 0cm">
<p class="xmsonormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;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">Darren Harvey </span></b><o:p></o:p></p>
</td>
</tr>
<tr>
<td width="600" style="width:450.0pt;padding:0cm 0cm 0cm 0cm">
<p class="xmsonormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;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">Senior Developer </span></b><o:p></o:p></p>
</td>
</tr>
<tr>
<td width="600" style="width:450.0pt;padding:7.5pt 0cm 3.75pt 0cm">
<p class="xmsonormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;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">M</span></b><span style="font-size:10.5pt;color:#3A444A"> +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> </span><o:p></o:p></p>
</td>
</tr>
<tr>
<td width="600" style="width:450.0pt;border:none;border-bottom:solid #FD7B23 1.0pt;padding:3.75pt 0cm 3.75pt 0cm">
<p class="xmsonormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;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"><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>
</span><span style="color:black"><a href="https://www.linkedin.com/company/fusion5" target="_blank"><span style="font-size:10.5pt;color:#3A444A;text-decoration:none"><img border="0" width="79" height="20" style="width:.825in;height:.2083in" id="x__symprex_i0001" src="cid:image004.png@01D61ECA.627DFFA0"></span></a><a href="https://www.instagram.com/jemini_hrpayroll_software/" target="_blank"><span style="font-size:10.5pt;color:#3A444A;text-decoration:none"><img border="0" width="103" height="20" style="width:1.075in;height:.2083in" id="x__symprex_i0002" src="cid:image005.png@01D61ECA.627DFFA0"></span></a></span><o:p></o:p></p>
</td>
</tr>
<tr>
<td width="600" style="width:450.0pt;padding:7.5pt 0cm 7.5pt 0cm">
<p class="xmsonormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;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;text-decoration:none"><img border="0" width="400" height="150" style="width:4.1666in;height:1.5666in" id="x__symprex_i0003" src="cid:image006.jpg@01D61ECA.627DFFA0"></span></a></span><span style="font-size:10.5pt;color:#3A444A">
</span><o:p></o:p></p>
</td>
</tr>
<tr>
<td width="600" style="width:450.0pt;padding:7.5pt 0cm 0cm 0cm">
<p class="xmsonormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;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">Fusion5 |</span></b><span style="font-size:10.5pt;color:#3A444A"> Level 27, 570 Bourke Street, Melbourne, 3000, Australia</span><o:p></o:p></p>
</td>
</tr>
<tr>
<td width="600" style="width:450.0pt;padding:3.75pt 0cm 0cm 0cm">
<p class="xmsonormal" style="margin-bottom:12.0pt;mso-element:frame;mso-element-frame-hspace:2.25pt;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">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> </span><o:p></o:p></p>
<p class="xmsonormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;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">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"> </span><span style="font-size:9.0pt;color:#3A444A"> </span><span style="font-size:7.5pt;color:#3A444A"><br>
</span><span style="font-size:9.0pt;color:#3A444A">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></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<p class="xmsonormal"> <span lang="EN-GB"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p><span lang="EN-GB">Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.<br>
<a href="http://www.mailguard.com.au/mg">http://www.mailguard.com.au/mg</a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><br>
<a href="https://console.mailguard.com.au/ras/1Y224Axk04/692AzJtZ3fqYQws7UzQf14/0.2">Report this message as spam</a> <br>
<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p>Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.<br>
<a href="http://www.mailguard.com.au/mg">http://www.mailguard.com.au/mg</a><o:p></o:p></p>
<p class="MsoNormal"><br>
<a href="https://console.mailguard.com.au/ras/1Y238TVa5Q/43QtGy8T54pRPLTQhucVrJ/0.2">Report this message as spam</a> <br>
<o:p></o:p></p>
</div>
</body>
</html>