Re: [Info-Ingres] Query stopped running since Ingres upgrade.

Hi Stephen,

we had the same issue. Turns out to be Bug 122625. Fixed in patch 13605. Also see KB Doc ID: 419144.

Regards,

Dave Stephens.

-----Original Message-----
From: info-ingres-bounces@kettleriverconsulting.com [mailto:info-ingres-bounces@kettleriverconsulting.com]On Behalf Of McCulloch, Stephen
Sent: 14 December 2009 11:20
To: 'Ingres and related product discussion forum'
Subject: [Info-Ingres] Query stopped running since Ingres upgrade.



Hi All



Since upgrading our Ingres Installation from 2.6 to II 9.2.0 (su9.us5/143)with patch 13590 a query that was working has now stopped working,

Returning the following error:



Error : E_US1265 Database reorganization activity has rendered the query plan invalid. Try again after the db activity is complete. In case of dynamic SQL, the statement must be prepared again.



Has anyone seen this before and can offer an explanation/solution?



Thanks

Stephen McCulloch






_____



************************************************** *******************************************
The information contained in this e-mail is confidential and is intended only for the named recipient(s). If you are not the intended recipient, youmust not copy, distribute or take any action or reliance on it. If you have received this e-mail in error, please notify the sender. Any unauthorised disclosure of the information contained in this e-mail is strictly prohibited.

The views and opinions expressed in this e-mail are the senders own and donot necessarily represent the views and opinions of Falkirk Council.
************************************************** *******************************************

__________________________________________________ ____________
This message has been scanned for all viruses by BTnet VirusScreen.
The service is delivered in partnership with MessageLabs.

This service does not scan any password protected or encrypted
attachments.



__________________________________________________ ____________

This message has been checked for all viruses by BTnet VirusScreen.
The service is delivered in partnership with MessageLabs and does not scanany password protected or encrypted attachments.

Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of the company. The contents of this email are confidential to the addressee and may also be privileged. If you are not the addressee of this email, you must not copy, forward, disclose or otherwise use it, or any part of it, for anypurpose, nor disclose its contents to any other person. If you have received this email in error please notify the sender. Please be aware that any email sent to, or received from, this address may be monitored for quality control, staff training or security purposes. Although the company scans all outgoing email and attachments for viruses, neither the sender nor the company accepts any responsibility for viruses and it remains the responsibility of the recipient to scan email and attachments (if any) for viruses.