[Info-ingres] Occasional SELECT statement error.

[Karl Schendel]

> On Apr 29, 2020, at 6:57 AM, Paul White <paul.white at shift7solutions.com.au> wrote:
> 
> 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.  

If you're on Ingres 11 or later, you can use SET SESSION_TRACE if the session is predictable, or
SET SERVER_TRACE if it's not, and trace for the specific error.


> 
> 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
> 
>  
> 
> 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 
> 
>   
> 
> 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 
> 
> 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  
>  
> 
> _______________________________________________
> Info-ingres mailing list
> Info-ingres at lists.planetingres.org
> https://lists.planetingres.org/mailman/listinfo/info-ingres
> _______________________________________________
> Info-ingres mailing list
> Info-ingres at lists.planetingres.org
> https://lists.planetingres.org/mailman/listinfo/info-ingres