[Info-ingres] Occasional SELECT statement error.

Wed Apr 29 08:06:44 UTC 2020

Hi Martin

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.

Thanks

Darren

Get Outlook for Android<https://aka.ms/ghei36>

________________________________
From: Martin Bowes <martin.bowes at ndph.ox.ac.uk>
Sent: Wednesday, April 29, 2020 4:56:59 PM
To: Darren Harvey <Darren.Harvey at fusion5.com.au>; info-ingres at lists.planetingres.org <info-ingres at lists.planetingres.org>
Subject: RE: [Info-ingres] Occasional SELECT statement error.

Hi Darren,

That’s not a lot to go on.

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.

Have you tried correlating errors in the errlog with the failed execution of this procedure?

Martin Bowes

From: Darren Harvey <Darren.Harvey at fusion5.com.au>
Sent: 29 April 2020 04:44
To: info-ingres at lists.planetingres.org
Subject: [Info-ingres] Occasional SELECT statement error.

Hi All

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.

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?

Thanks

Darren

Error Message

[cid:image009.jpg at 01D61DFB.C257D060]

SELECT statement in procedure that is getting error.

[cid:image010.jpg at 01D61DFB.C257D060]

The ACTIAN Generic Error Code for -3200 is described as follows:

[cid:image011.jpg at 01D61DFB.C257D060]

Darren Harvey

Senior Developer

M +61 400 398 188
P +61 3 9922 5519
Teams or Skype for Business ID darren.harvey at fusion5.com.au<mailto:darren.harvey at fusion5.com.au>

www.fusion5.com.au<https://www.fusion5.com.au?utm_source=F5-Int.Sig&utm_medium=email&utm_campaign=AskUs2020/> [cid:image013.png at 01D61DFB.C257D060] <https://www.linkedin.com/company/fusion5> [cid:image014.png at 01D61DFB.C257D060] <https://www.instagram.com/jemini_hrpayroll_software/>

[cid:image015.jpg at 01D61DFB.C257D060]<http://business.fusion5.com.au/HCM2020?utm_source=F5-Int.Sig&utm_medium=email&utm_campaign=HCM2020Conf>

Fusion5 | Level 27, 570 Bourke Street, Melbourne, 3000, Australia

This email and any attachments are confidential and intended exclusively for the person to whom the email is addressed. Please see our Privacy Policy<https://www.fusion5.com.au/privacy-policy/>

Are you interested in Fusion5’s COVID-19 business update?　
Please visit https://www.fusion5.com.au/covid-19-update/

Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.
http://www.mailguard.com.au/mg

Report this message as spam<https://console.mailguard.com.au/ras/1Y224Axk04/692AzJtZ3fqYQws7UzQf14/0.2>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/efd1ba12/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image009.jpg
Type: image/jpeg
Size: 12462 bytes
Desc: image009.jpg
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/efd1ba12/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image010.jpg
Type: image/jpeg
Size: 26556 bytes
Desc: image010.jpg
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/efd1ba12/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image011.jpg
Type: image/jpeg
Size: 10986 bytes
Desc: image011.jpg
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/efd1ba12/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image013.png
Type: image/png
Size: 974 bytes
Desc: image013.png
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/efd1ba12/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image014.png
Type: image/png
Size: 3560 bytes
Desc: image014.png
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/efd1ba12/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image015.jpg
Type: image/jpeg
Size: 43812 bytes
Desc: image015.jpg
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/efd1ba12/attachment-0003.jpg>