710 ERROR
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.
You are correct, you probably should not see -710 errors on EXECUTE
IMMEDIATE statements. Is this all being done withing a single transaction
(ie is this an ANSI database or other logged database where a BEGIN WORK was
executed but no committed yet)? That's the only thing that I can think of.
Art
On Tue, Sep 23, 2008 at 5:50 AM, Jorge cruces <jorge.cruces@accelya.com>wrote:
> 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.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.
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.
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.
>
>
In my case, there are several transations between the alter table and the
insert than fails by 710 error.
Juan Jorge Cruces Fernández
Accelya
----- Original Message -----
From: "Art Kagel" <art.kagel@gmail.com>
To: <ids@iiug.org>
Sent: Tuesday, September 23, 2008 1:35 PM
Subject: Re: 710 ERROR [13474]
> You are correct, you probably should not see -710 errors on EXECUTE
> IMMEDIATE statements. Is this all being done withing a single transaction
> (ie is this an ANSI database or other logged database where a BEGIN WORK
> was
> executed but no committed yet)? That's the only thing that I can think of.
>
> Art
>
> On Tue, Sep 23, 2008 at 5:50 AM, Jorge cruces
> <jorge.cruces@accelya.com>wrote:
>
>> 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.
>>
>>
>
> --
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> do not reflect on my employer, Oninit, the IIUG, nor any other
> organization
> with which I am associated either explicitly or implicitly. Neither do
> those
> opinions reflect those of other individuals affiliated with any entity
> with
> which I am affiliated nor those of the entities themselves.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>