IDS Forum

Re: 710 ERROR

Posted By: Jorge cruces
Date: Tuesday, 23 September 2008, at 8:18 a.m.

In Response To: RE: 710 ERROR (Haracz Greg)

I already see the error than you mention in the release notes, that is
170372 but in theory this is solve in version 10 UC3. Update statistics work
if its is done in the table where i am doing the insert, but don't work in
the table that have be altered and also not work in table than have been
referencing by the foreing key.

Juan Jorge Cruces Fernández
Accelya

----- Original Message -----
From: "Haracz Greg" <Greg.Haracz@barclaycard.co.uk>
To: <ids@iiug.org>
Sent: Tuesday, September 23, 2008 2:05 PM
Subject: RE: 710 ERROR [13475]

> Juan
> I have come across a very similar problem on a version 7 database on AIX.
> If you run an alter on a table that has a relationship with another table
> or
> is in a chain of relationships we had the application returning a 710
> error.
> The work around is to run update stats on the table being altered and
> those in
> the relationship chain.
> May have been a bug but can't remember as it was some time ago.
> Hope that helps.
>
> Greg
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Jorge
> cruces
> Sent: 23 September 2008 10:50
> To: ids@iiug.org
> Subject: 710 ERROR [13472]
>
> Hi,
>
> I have a strange 710 error in infomirx linux 10.00.UC6. The scneario is
> the
> following
>
> Table T1 (a int primary key, b)
> Tabla T2 (a int primary key, b int foreign key references t1(a))
> Tabla T3 (a int primary key, b int)
>
> alter table t3 add constraint foreign key (b) references t1(a);
> other alters
> .................
> select ............
> into temp T4 with no log;
> insert into t2 select * from t4;
>
> The last insert return 710 error referencing t1 as the problem
>
> The strange is if I comment the alter from t3 the 710 don't happen. It's
> like
> the alter change the structure of all table
> with a foreing key to t1. The other strange think if that all statements
> in
> the scenario are ESQL/C execute inmediate statement, not previous prepared
> statement.
>
> Any Idea?
>
> Juan Jorge Cruces Fernández
> Accelya
>
> Este mensaje se dirige exclusivamente a su destinatario, contiene
> información
> CONFIDENCIAL sometida a secreto profesional y su divulgación está
> prohibida
> por ley. Si ha recibido este mensaje por error, su copia y uso están
> prohibidos, rogándole que nos lo comunique inmediatamente por esta misma
> vía y
> proceda a su destrucción.
> El correo electrónico no garantiza la confidencialidad de los mensajes ni
> su
> integridad o correcta recepción. La compañía ACCELYA no asume
> responsabilidad
> por estas circunstancias.
> Si el destinatario de este mensaje no consintiera la utilización del
> correo
> electrónico y la grabación de los mensajes, rogamos nos lo notifique de
> forma
> inmediata.
> This message is intended exclusively for its addressee. It contains
> information that is CONFIDENTIAL and protected by a professional privilege
> or
> whose disclosure is prohibited by law. If this message has been received
> in
> error, you should know that it is forbidden to copy or use it. Please
> immediately notify us via e-mail and delete it.
> Internet e-mail neither guarantees the confidentiality nor the integrity
> or
> proper receipt of the messages sent. ACCELYA company assumes no liability
> or
> responsibility for any error caused by matters beyond our control. If the
> addressee of this message does not consent to the use of Internet e-mail
> and
> message recording, please notify us immediately.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> This e-mail and any attachments are confidential and intended solely for
> the
> addressee and may also be privileged or exempt from disclosure under
> applicable law. If you are not the addressee, or have received this e-mail
> in
> error, please notify the sender immediately, delete it from your system
> and do
> not copy, disclose or otherwise act upon any part of this e-mail or its
> attachments.
>
> Internet communications are not guaranteed to be secure or virus-free. The
> Barclays Group does not accept responsibility for any loss arising from
> unauthorised access to, or interference with, any Internet communications
> by
> any third party, or from the transmission of any viruses. Replies to this
> e-mail may be monitored by the Barclays Group for operational or business
> reasons.
>
> Any opinion or other information in this e-mail or its attachments that
> does
> not relate to the business of the Barclays Group is personal to the sender
> and
> is not given or endorsed by the Barclays Group.
>
> Barclaycard is a trading name of Barclays Bank Plc.
>
> Barclays Bank Plc. Registered in England and Wales (registered no.
> 1026167).
> Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom.
>
> Barclays Bank Plc. is authorised and regulated by the Financial Services
> Authority.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

Messages In This Thread

• 710 ERROR
  Jorge cruces -- Tuesday, 23 September 2008, at 5:50 a.m.
  • Re: 710 ERROR
    Art Kagel -- Tuesday, 23 September 2008, at 7:35 a.m.
    • Re: 710 ERROR
      Jorge cruces -- Tuesday, 23 September 2008, at 8:20 a.m.
  • RE: 710 ERROR
    Haracz Greg -- Tuesday, 23 September 2008, at 8:05 a.m.
    • Re: 710 ERROR
      Jorge cruces -- Tuesday, 23 September 2008, at 8:18 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.