[Info-ingres] Occasional SELECT statement error.

[Paul White]

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.
Paul

On Wed, 29 Apr. 2020, 6:26 pm Adrian Williamson, <
adrian.williamson at rationalcommerce.com> wrote:

> Hi Darren
>
>
>
> Is that a table returning database procedure or OpenROAD?
>
>
>
> 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).
>
>
>
> Can you show the full source of the procedure?
>
>
>
> Cheers
>
>
>
> Adrian
>
>
>
> *From:* info-ingres-bounces at lists.planetingres.org <
> info-ingres-bounces at lists.planetingres.org> *On Behalf Of *Darren Harvey
> *Sent:* 29 April 2020 09:07
> *To:* info-ingres at lists.planetingres.org; Martin Bowes <
> martin.bowes at ndph.ox.ac.uk>
> *Subject:* Re: [Info-ingres] Occasional SELECT statement error.
>
>
>
> 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
>
>
>
>
>
>
>
>
>
> SELECT statement in procedure that is getting error.
>
>
>
>
>
>
>
>
>
> The ACTIAN Generic Error Code for -3200 is described as follows:
>
>
>
> *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
>
> www.fusion5.com.au
> <https://www.fusion5.com.au?utm_source=F5-Int.Sig&utm_medium=email&utm_campaign=AskUs2020/>
> <https://www.linkedin.com/company/fusion5>
> <https://www.instagram.com/jemini_hrpayroll_software/>
>
>
> <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>
>
>
> _______________________________________________
> Info-ingres mailing list
> Info-ingres at lists.planetingres.org
> https://lists.planetingres.org/mailman/listinfo/info-ingres
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/2495c936/attachment.html>