<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-GB 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'>Hi,<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'>Apart from my mild surprise that you don’t have to prefix target variables in the select statement with colons that looks pretty straight forward.<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'>Recently we have noticed an increase in odd error messages being generated by what seem like innocent enough statements.<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'>Typically in some sort of batch context it tosses an error then stops.<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'>If you take the offending statement and run it in isolation it just works – its been too difficult to put a test case together so we have just moved on.<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'>What is the target DBMS and OS / Hardware?<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’m afraid I’m not going to be able to help much other than to encourage you to use the flight recorder and wait for the next instance.<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'>Sorry,<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'>Adrian<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><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'> info-ingres-bounces@lists.planetingres.org <info-ingres-bounces@lists.planetingres.org> <b>On Behalf Of </b>Darren Harvey<br><b>Sent:</b> 29 April 2020 23:39<br><b>To:</b> info-ingres@lists.planetingres.org<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-AU 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 lang=EN-AU 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-AU 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 lang=EN-AU 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-AU 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 lang=EN-AU 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-AU 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-AU 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-AU 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 lang=EN-AU 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-AU 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'><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'><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> <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=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:.8229in;height:.2083in' id="_symprex_i0001" src="cid:image001.png@01D61ED1.8515E0D0"></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.0729in;height:.2083in' id="_symprex_i0002" src="cid:image002.png@01D61ED1.8515E0D0"></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.5625in' id="_symprex_i0003" src="cid:image003.jpg@01D61ED1.8515E0D0"></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></table></td></tr></table></div><p class=MsoNormal><span lang=EN-AU 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 <<a href="mailto:adrian.williamson@rationalcommerce.com">adrian.williamson@rationalcommerce.com</a>> <br><b>Sent:</b> Wednesday, 29 April 2020 6:26 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>; '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-AU><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'>Hi 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'>Is that a table returning database procedure or OpenROAD?<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'>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 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'>Can you show the full source of the procedure?<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'>Adrian<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><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><o:p> </o:p></p><div><p class=MsoNormal style='margin-bottom:12.0pt'><span 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 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 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 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 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 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'><hr size=2 width="98%" align=center></div><div id=divRplyFwdMsg><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'>From:</span></b><span 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> <o:p></o:p></p><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><div><p class=xmsonormal><span style='color:#1F497D'>Hi Darren,</span><o:p></o:p></p><p class=xmsonormal><span style='color:#1F497D'> </span><o:p></o:p></p><p class=xmsonormal><span style='color:#1F497D'>That’s not a lot to go on.</span><o:p></o:p></p><p class=xmsonormal><span style='color:#1F497D'> </span><o:p></o:p></p><p class=xmsonormal><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.</span><o:p></o:p></p><p class=xmsonormal><span style='color:#1F497D'> </span><o:p></o:p></p><p class=xmsonormal><span style='color:#1F497D'>Have you tried correlating errors in the errlog with the failed execution of this procedure?</span><o:p></o:p></p><p class=xmsonormal><span style='color:#1F497D'> </span><o:p></o:p></p><p class=xmsonormal><span style='color:#1F497D'>Martin Bowes</span><o:p></o:p></p><p class=xmsonormal><span style='color:#1F497D'> </span><o:p></o:p></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><o:p></o:p></p></div></div><p class=xmsonormal> <o:p></o:p></p><p class=xmsonormal><span lang=EN-AU>Hi All</span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p><p class=xmsonormal><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.</span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p><p class=xmsonormal><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?</span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU>Thanks</span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p><div style='border:none;border-bottom:solid windowtext 1.0pt;padding:0cm 0cm 1.0pt 0cm'><p class=xmsonormal><span lang=EN-AU>Darren</span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p></div><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU>Error Message</span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU><img border=0 width=461 height=252 style='width:4.802in;height:2.625in' id="x_Picture_x0020_6" src="cid:image004.jpg@01D61ED1.8515E0D0"></span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU>SELECT statement in procedure that is getting error.</span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU><img border=0 width=790 height=286 style='width:8.2291in;height:2.9791in' id="x_Picture_x0020_5" src="cid:image005.jpg@01D61ED1.8515E0D0"></span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU>The ACTIAN Generic Error Code for -3200 is described as follows:</span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU><img border=0 width=646 height=93 style='width:6.7291in;height:.9687in' id="x_Picture_x0020_7" src="cid:image006.jpg@01D61ED1.8515E0D0"></span><o:p></o:p></p><p class=xmsonormal><span lang=EN-AU> </span><o:p></o:p></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 align=left width="100%" style='width:100.0%;background:white;border-collapse:collapse'><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'><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:.8229in;height:.2083in' id="x__symprex_i0001" src="cid:image001.png@01D61ED1.8515E0D0"></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.0729in;height:.2083in' id="x__symprex_i0002" src="cid:image002.png@01D61ED1.8515E0D0"></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.5625in' id="x__symprex_i0003" src="cid:image003.jpg@01D61ED1.8515E0D0"></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></table></td></tr></table><p class=xmsonormal><span lang=EN-AU style='color:white'> </span><o:p></o:p></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/1Y224Axk04/692AzJtZ3fqYQws7UzQf14/0.2">Report this message as spam</a> <br> <o:p></o:p></p></div><p class=MsoNormal><span lang=EN-AU><o:p> </o:p></span></p><p><span lang=EN-AU>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-AU><br><a href="https://console.mailguard.com.au/ras/1Y238TVa5Q/43QtGy8T54pRPLTQhucVrJ/0.2">Report this message as spam</a> <br> <o:p></o:p></span></p></div></body></html>