ORA-08177: error

[Joe Boyle]

The error message suggests that qtp can't get a lock on the row it wants to
update. 

 

This can usually be solved by using a 'commit at update' which uses a
concurrent TX rather than consistency; this is similar to using 'commit at
n' but uses minimal rollback resources.

Regards, Joe. 

  _____  

From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
fernando.olmos at hpa.com.au
Sent: 13 October 2005 04:57
To: VGoparaju at tradepointsystems.com
Cc: powerh-l at lists.sowder.com
Subject: RE: ORA-08177: error

 

Yeah, we figured that but it's too risky without a good roll back.

 

I found that if I placed an ADD UPDATE, and not just an ADD after the OUTPUT
clause, it worked! It looks like PH is opening the connection to the
database differently when you say ADD UPDATE as opposed to just ADD. Mind
you this only works of course, if we're creating a subfile from the table
we're going to add back into again later on. If the logic specifically only
wants an ADD, even when there are possibilities of an UPDATE occurring
because of similar primary keys, then we're in trouble.

 

I think the best way to resolve this is to figure out how Oracle is been
accessed when it's an ADD vs an ADD UPDATE.

 

Cheers

 

-----Original Message-----
From: VGoparaju at tradepointsystems.com
[mailto:VGoparaju at tradepointsystems.com] 
Sent: Thursday, October 13, 2005 1:53 PM
To: Fernando Olmos
Cc: powerh-l at lists.sowder.com
Subject: RE: ORA-08177: error

One of the solutions is to use COMMIT AT <n transactions> could be COMMIT at
1000 transactions. 

 

Sagar Goparaju

TradePoint

 

-----Original Message-----
From: powerh-l-bounces+vgoparaju=tradepointsystems.com at lists.sowder.com
[mailto:powerh-l-bounces+vgoparaju=tradepointsystems.com at lists.sowder.com]On
Behalf Of fernando.olmos at hpa.com.au
Sent: Wednesday, October 12, 2005 10:36 PM
To: powerh-l at lists.sowder.com
Subject: ORA-08177: error

 

Has anyone experienced this error when trying to ADD records from a subfile
into an Oracle table? 

ORA-08177: can't serialize access for this transaction 

We get this sometimes, and other times we don't. It's weird. 

Thanks 

Fernando Olmos 
M.I.S. 

HPA
Direct:  03 9217 5411
Mobile: 0410 382 857
Fax:     03 9217 5716 

 <file:///H:\Appdata\Microsoft\Signatures\www.hpa.com.au> www.hpa.com.au 

 

**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and
intended
solely for the use of the individual or entity to whom they are addressed.
If
you received this e-mail in error, please notify the HPA Postmaster,
postmaster at hpa.com.au,
then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For
more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************

STATEMENT OF CONFIDENTIALITY:
The information contained in this electronic message is intended for the
exclusive use of the addressee(s) and may contain confidential information.
If you are not the intended recipient of this email, be advised you have
received this message in error and that any use, dissemination, forwarding,
printing, or copying is strictly prohibited.  Please notify TradePoint
Systems LLC immediately at (603) 889-3200 and destroy all copies of this
message and any attachments.

**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and
intended
solely for the use of the individual or entity to whom they are addressed.
If
you received this e-mail in error, please notify the HPA Postmaster,
postmaster at hpa.com.au,
then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For
more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20051013/5d0e1c62/attachment.html