ORA-08177: error

Peter Bateman pfbcs at hotmail.com
Sat Oct 15 15:20:43 CDT 2005 

If you look on page 106 of the 4.3 PDL Reference Manual.
Transaction      Access              Isolation-level             PH program
-----------------------------------------------------------------------------------------------
Consistency     read/write          SERIALIZABLE            QDESIGN, QTP

Update          read/write           READ  COMMITTED     QDESIGN, QTP
My guess is that:- QTP is switching to the transaction UPDATE  when we add 
UPDATE
to the output statement.

But you don't need to try a whole bunch of fake reads unless you want to 
ignore duplicates.
Say X is the logical name of your database.
In PDL

DATABASE X_RC ....

TRANSACTION QTP_CONSISTENCY &
   DATABASE X_RC READ COMMITTED

In QTP
ACCESS *SUB
OUTPUT Y IN X_RC ADD

Caution:- When we downgrade our isolation level from SERIALIZABLE to READ 
COMMITTED
we are saying what we don't care when something was committed just that it 
has been
committed. This can create timing issues when triggers , stored procedures 
and functions
are involved.



>It could also be that the usual qtp message isn't working when attempting 
>to
>add a duplicate with syntax 'ADD' only.
>
>
>
>You could try adding 'on error report' to the output statement in order to
>see if the fatal error stops; and enabling the run to complete.
>
>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
>**********************************************************************


>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.

_________________________________________________________________
Take charge with a pop-up guard built on patented Microsoft® SmartScreen 
Technology  
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.

More information about the powerh-l mailing list