<div dir="auto">Hi Darren. I've had a lot of success with tracepoint SC930. It has very little impact on performance. I leave it running during business hours and then restart in a clean directory each day. <div dir="auto">Paul</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, 29 Apr. 2020, 6:26 pm Adrian Williamson, <<a href="mailto:adrian.williamson@rationalcommerce.com" target="_blank" rel="noreferrer">adrian.williamson@rationalcommerce.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-GB" link="#0563C1" vlink="#954F72"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Hi Darren<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Is that a table returning database procedure or OpenROAD?<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">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).<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Can you show the full source of the procedure?<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Cheers<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Adrian<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></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" rel="noreferrer noreferrer" target="_blank">info-ingres-bounces@lists.planetingres.org</a> <<a href="mailto:info-ingres-bounces@lists.planetingres.org" rel="noreferrer noreferrer" target="_blank">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" rel="noreferrer noreferrer" target="_blank">info-ingres@lists.planetingres.org</a>; Martin Bowes <<a href="mailto:martin.bowes@ndph.ox.ac.uk" rel="noreferrer noreferrer" target="_blank">martin.bowes@ndph.ox.ac.uk</a>><br><b>Subject:</b> Re: [Info-ingres] Occasional SELECT statement error.<u></u><u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></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<u></u><u></u></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.<u></u><u></u></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<u></u><u></u></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 <u></u><u></u></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" rel="noreferrer noreferrer" target="_blank">Outlook for Android</a><u></u><u></u></span></p></div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:black"><u></u> <u></u></span></p></div><div class="MsoNormal" align="center" style="text-align:center"><hr size="2" width="98%" align="center"></div><div id="m_-7071366777446931524m_-8298156039677490764divRplyFwdMsg"><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" rel="noreferrer noreferrer" target="_blank">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" rel="noreferrer noreferrer" target="_blank">Darren.Harvey@fusion5.com.au</a>>; <a href="mailto:info-ingres@lists.planetingres.org" rel="noreferrer noreferrer" target="_blank">info-ingres@lists.planetingres.org</a> <<a href="mailto:info-ingres@lists.planetingres.org" rel="noreferrer noreferrer" target="_blank">info-ingres@lists.planetingres.org</a>><br><b>Subject:</b> RE: [Info-ingres] Occasional SELECT statement error.</span> <u></u><u></u></p><div><p class="MsoNormal"> <u></u><u></u></p></div></div><div><div><p><span style="color:#1f497d">Hi Darren,</span><u></u><u></u></p><p><span style="color:#1f497d"> </span><u></u><u></u></p><p><span style="color:#1f497d">That’s not a lot to go on.</span><u></u><u></u></p><p><span style="color:#1f497d"> </span><u></u><u></u></p><p><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><u></u><u></u></p><p><span style="color:#1f497d"> </span><u></u><u></u></p><p><span style="color:#1f497d">Have you tried correlating errors in the errlog with the failed execution of this procedure?</span><u></u><u></u></p><p><span style="color:#1f497d"> </span><u></u><u></u></p><p><span style="color:#1f497d">Martin Bowes</span><u></u><u></u></p><p><span style="color:#1f497d"> </span><u></u><u></u></p><div><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Darren Harvey <<a href="mailto:Darren.Harvey@fusion5.com.au" rel="noreferrer noreferrer" target="_blank">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" rel="noreferrer noreferrer" target="_blank">info-ingres@lists.planetingres.org</a><br><b>Subject:</b> [Info-ingres] Occasional SELECT statement error.</span><u></u><u></u></p></div></div><p> <u></u><u></u></p><p><span lang="EN-AU">Hi All</span><u></u><u></u></p><p><span lang="EN-AU"> </span><u></u><u></u></p><p><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><u></u><u></u></p><p><span lang="EN-AU"> </span><u></u><u></u></p><p><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><u></u><u></u></p><p><span lang="EN-AU"> </span><u></u><u></u></p><p><span lang="EN-AU">Thanks</span><u></u><u></u></p><p><span lang="EN-AU"> </span><u></u><u></u></p><div style="border:none;border-bottom:solid windowtext 1.0pt;padding:0cm 0cm 1.0pt 0cm"><p><span lang="EN-AU">Darren</span><u></u><u></u></p><p><span lang="EN-AU"> </span><u></u><u></u></p></div><p><span lang="EN-AU"> </span><u></u><u></u></p><p><span lang="EN-AU">Error Message</span><u></u><u></u></p><p><span lang="EN-AU"> </span><u></u><u></u></p><p><span lang="EN-AU"><img border="0" width="461" height="252" style="width:4.802in;height:2.625in" id="m_-7071366777446931524m_-8298156039677490764x_Picture_x0020_6" src="cid:image001.jpg@01D61E08.02080520"></span><u></u><u></u></p><p><span lang="EN-AU"> </span><u></u><u></u></p><p><span lang="EN-AU"> </span><u></u><u></u></p><p><span lang="EN-AU"> </span><u></u><u></u></p><p><span lang="EN-AU">SELECT statement in procedure that is getting error.</span><u></u><u></u></p><p><span lang="EN-AU"> </span><u></u><u></u></p><p><span lang="EN-AU"> </span><u></u><u></u></p><p><span lang="EN-AU"><img border="0" width="790" height="286" style="width:8.2291in;height:2.9791in" id="m_-7071366777446931524m_-8298156039677490764x_Picture_x0020_5" src="cid:image002.jpg@01D61E08.02080520"></span><u></u><u></u></p><p><span lang="EN-AU"> </span><u></u><u></u></p><p><span lang="EN-AU"> </span><u></u><u></u></p><p><span lang="EN-AU">The ACTIAN Generic Error Code for -3200 is described as follows:</span><u></u><u></u></p><p><span lang="EN-AU"><img border="0" width="646" height="93" style="width:6.7291in;height:.9687in" id="m_-7071366777446931524m_-8298156039677490764x_Picture_x0020_7" src="cid:image003.jpg@01D61E08.02080520"></span><u></u><u></u></p><p><span lang="EN-AU"> </span><u></u><u></u></p><table 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 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><b><span style="font-size:15.0pt;color:#3a444a">Darren Harvey </span></b><u></u><u></u></p></td></tr><tr><td width="600" style="width:450.0pt;padding:0cm 0cm 0cm 0cm"><p><b><span style="font-size:10.5pt;color:#3a444a">Senior Developer </span></b><u></u><u></u></p></td></tr><tr><td width="600" style="width:450.0pt;padding:7.5pt 0cm 3.75pt 0cm"><p><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" rel="noreferrer noreferrer" target="_blank">darren.harvey@fusion5.com.au</a> </span><u></u><u></u></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><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/" rel="noreferrer noreferrer" target="_blank"><span style="color:#3a444a">www.fusion5.com.au</span></a> <a href="https://www.linkedin.com/company/fusion5" rel="noreferrer noreferrer" target="_blank"><span style="color:#3a444a;text-decoration:none"><img border="0" width="79" height="20" style="width:.8229in;height:.2083in" id="m_-7071366777446931524m_-8298156039677490764x__symprex_i0001" src="cid:image004.png@01D61E08.02080520"></span></a></span><span style="color:black"><a href="https://www.instagram.com/jemini_hrpayroll_software/" rel="noreferrer noreferrer" 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="m_-7071366777446931524m_-8298156039677490764x__symprex_i0002" src="cid:image005.png@01D61E08.02080520"></span></a></span><u></u><u></u></p></td></tr><tr><td width="600" style="width:450.0pt;padding:7.5pt 0cm 7.5pt 0cm"><p><span style="color:black"><a href="http://business.fusion5.com.au/HCM2020?utm_source=F5-Int.Sig&utm_medium=email&utm_campaign=HCM2020Conf" rel="noreferrer noreferrer" target="_blank"><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="m_-7071366777446931524m_-8298156039677490764x__symprex_i0003" src="cid:image006.jpg@01D61E08.02080520"></span></a></span><span style="font-size:10.5pt;color:#3a444a"> </span><u></u><u></u></p></td></tr><tr><td width="600" style="width:450.0pt;padding:7.5pt 0cm 0cm 0cm"><p><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><u></u><u></u></p></td></tr><tr><td width="600" style="width:450.0pt;padding:3.75pt 0cm 0cm 0cm"><p style="margin-bottom:12.0pt"><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/" rel="noreferrer noreferrer" target="_blank"><span style="color:#3a444a">Privacy Policy</span></a> </span><u></u><u></u></p><p><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/" rel="noreferrer noreferrer" target="_blank"><span style="color:#0066cc">https://www.fusion5.com.au/covid-19-update/</span></a></span><u></u><u></u></p></td></tr></table></td></tr></table><p><span lang="EN-AU"> </span><u></u><u></u></p></div><p class="MsoNormal"><u></u> <u></u></p><p>Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.<br><a href="http://www.mailguard.com.au/mg" rel="noreferrer noreferrer" target="_blank">http://www.mailguard.com.au/mg</a><u></u><u></u></p><p class="MsoNormal"><br><a href="https://console.mailguard.com.au/ras/1Y224Axk04/692AzJtZ3fqYQws7UzQf14/0.2" rel="noreferrer noreferrer" target="_blank">Report this message as spam</a> <br> <u></u><u></u></p></div></div></div>_______________________________________________<br>
Info-ingres mailing list<br>
<a href="mailto:Info-ingres@lists.planetingres.org" rel="noreferrer noreferrer" target="_blank">Info-ingres@lists.planetingres.org</a><br>
<a href="https://lists.planetingres.org/mailman/listinfo/info-ingres" rel="noreferrer noreferrer noreferrer" target="_blank">https://lists.planetingres.org/mailman/listinfo/info-ingres</a><br>
</blockquote></div>