<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Message</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"C\!\000D\000A ourier New";
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle20
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>It could also be that the usual qtp
message isn’t working when attempting to add a duplicate with syntax ‘ADD’
only.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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.<o:p></o:p></span></font></p>
<div>
<p><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:navy'>Regards, Joe.</span></font><font color=navy><span
style='color:navy'> <o:p></o:p></span></font></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=3 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>fernando.olmos@hpa.com.au<br>
<b><span style='font-weight:bold'>Sent:</span></b> 13 October 2005 04:57<br>
<b><span style='font-weight:bold'>To:</span></b>
VGoparaju@tradepointsystems.com<br>
<b><span style='font-weight:bold'>Cc:</span></b> powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: ORA-08177: error</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Yeah, we figured that but it's too risky
without a good roll back.</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>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.</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>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.</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Cheers</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> VGoparaju@tradepointsystems.com
[mailto:VGoparaju@tradepointsystems.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, October 13, 2005
1:53 PM<br>
<b><span style='font-weight:bold'>To:</span></b> Fernando Olmos<br>
<b><span style='font-weight:bold'>Cc:</span></b> powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: ORA-08177: error</span></font><o:p></o:p></p>
<p class=MsoNormal><span class=EmailStyle20><font size=2 color=navy face=Arial><span
style='font-size:10.0pt'><!-- Converted from text/rtf format -->One of the
solutions is to use COMMIT AT <n transactions> could be COMMIT at 1000
transactions. <o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle20><font size=2 color=navy face=Arial><span
style='font-size:10.0pt'> <o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle20><font size=2 color=navy face=Arial><span
style='font-size:10.0pt'>Sagar Goparaju<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle20><font size=2 color=navy face=Arial><span
style='font-size:10.0pt'>TradePoint<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle20><font size=2 color=navy face=Arial><span
style='font-size:10.0pt'> <o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>-----Original
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
powerh-l-bounces+vgoparaju=tradepointsystems.com@lists.sowder.com
[mailto:powerh-l-bounces+vgoparaju=tradepointsystems.com@lists.sowder.com]<b><span
style='font-weight:bold'>On Behalf Of </span></b>fernando.olmos@hpa.com.au<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, October 12, 2005
10:36 PM<br>
<b><span style='font-weight:bold'>To:</span></b> powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> ORA-08177: error</span></font><o:p></o:p></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p style='margin-left:36.0pt'><font size=2 color=black face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:black'>Has anyone experienced
this error when trying to ADD records from a subfile into an Oracle table?</span></font><font
color=black><span style='color:black'> </span></font><o:p></o:p></p>
<p style='margin-left:36.0pt'><font size=2 color=black face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:black'>ORA-08177: can't
serialize access for this transaction</span></font><font color=black><span
style='color:black'> </span></font><o:p></o:p></p>
<p style='margin-left:36.0pt'><font size=2 color=black face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:black'>We get this sometimes,
and other times we don't. It's weird.</span></font><font color=black><span
style='color:black'> </span></font><o:p></o:p></p>
<p style='margin-left:36.0pt'><font size=2 color=black face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:black'>Thanks</span></font><font
color=black><span style='color:black'> </span></font><o:p></o:p></p>
<p style='margin-left:36.0pt'><i><font size=4 color=blue face=Arial><span
style='font-size:13.5pt;font-family:Arial;color:blue;font-style:italic'>Fernando
Olmos</span></font></i><font color=black><span style='color:black'> <br>
</span></font><b><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black;font-weight:bold'>M.I.S.</span></font></b><font
color=black><span style='color:black'> </span></font><o:p></o:p></p>
<p style='margin-left:36.0pt'><b><font size=2 color=blue face=Arial><span
lang=EN-AU style='font-size:10.0pt;font-family:Arial;color:blue;font-weight:
bold'>HPA</span></font></b><font color=black face=Arial><span style='font-family:
Arial;color:black'><br>
</span></font><font size=2 color=black face=Arial><span lang=EN-AU
style='font-size:10.0pt;font-family:Arial;color:black'>Direct: 03 9217
5411</span></font><font color=black><span style='color:black'><br>
</span></font><st1:City w:st="on"><st1:place w:st="on"><font size=2
color=black face=Arial><span lang=EN-AU style='font-size:10.0pt;font-family:
Arial;color:black'>Mobile</span></font></st1:place></st1:City><font size=2
color=black face=Arial><span lang=EN-AU style='font-size:10.0pt;font-family:
Arial;color:black'>: 0410 382 857</span></font><font color=black
face=Arial><span style='font-family:Arial;color:black'><br>
</span></font><font size=2 color=black face=Arial><span lang=EN-AU
style='font-size:10.0pt;font-family:Arial;color:black'>Fax:
03 9217 5716</span></font><font color=black><span lang=EN-AU style='color:black'>
</span></font><o:p></o:p></p>
<p style='margin-left:36.0pt'><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'><a
href="file:///H:\Appdata\Microsoft\Signatures\www.hpa.com.au"><b><font size=2
face=Arial><span lang=EN-AU style='font-size:10.0pt;font-family:Arial;
font-weight:bold'>www.hpa.com.au</span></font></b></a> </span></font><o:p></o:p></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;color:black'> </span></font><o:p></o:p></p>
<pre style='margin-left:36.0pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>**********************************************************************</span></font><o:p></o:p></pre><pre
style='margin-left:36.0pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>IMPORTANT</span></font><o:p></o:p></pre><pre
style='margin-left:36.0pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>The contents of this e-mail and its attachments are confidential and intended</span></font><o:p></o:p></pre><pre
style='margin-left:36.0pt'><font size=2 color=black face="C! ourier New"><span
style='font-size:10.0pt;font-family:"C\!\000D\000A ourier New";color:black'>solely for the use of the individual or entity to whom they are addressed. If</span></font><o:p></o:p></pre><pre
style='margin-left:36.0pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>you received this e-mail in error, please notify the HPA Postmaster, postmaster@hpa.com.au,</span></font><o:p></o:p></pre><pre
style='margin-left:36.0pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>then delete the e-mail.</span></font><o:p></o:p></pre><pre
style='margin-left:36.0pt'><font size=2 color=black face="Courier New" fac!
e="Courier New"><span style='font-size:10.0pt;color:black'>This footnote also confirms that this e-mail message has been swept for the</span></font><o:p></o:p></pre><pre
style='margin-left:36.0pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>presence of computer viruses by Ironport. Before opening or using any</span></font><o:p></o:p></pre><pre
style='margin-left:36.0pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>attachments, check them for viruses and defects.</span></font><o:p></o:p></pre><pre
style='margin-left:36.0pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>Our liability is limited to resupplying any affected attachments.</span></FON! T></font><o:p></o:p></pre><pre
style='margin-left:36.0pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>HPA collects personal information to provide and market our services. For more</span></font><o:p></o:p></pre><pre
style='margin-left:36.0pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>information about use, disclosure and access see our Privacy Policy at</span></font><o:p></o:p></pre><pre
style='margin-left:36.0pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;color:black'>www.hpa.com.au</span></font><o:p></o:p></pre><pre
style!="MARGIN-LEFT: 0.5in"><font size=2 color=black face="Courier New"><SPA N style="FONT-SIZE: 10pt; COLOR: black"><span
style='font-size:10.0pt;color:black'>**********************************************************************</span></font><o:p></o:p></pre>
<p align=center style='text-align:center'><font size=1 color=black face=Tahoma><!--[object_id=#tradepointsystems.com#]--><span
style='font-size:7.5pt;font-family:Tahoma;color:black'>STATEMENT OF
CONFIDENTIALITY:<br>
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.</span></font><font color=black><span
style='color:black'><o:p></o:p></span></font></p>
<pre><font size=2 color=black face="Courier New"><span style='font-size:10.0pt;
color:black'>**********************************************************************<o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;color:black'>IMPORTANT<o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;color:black'>The contents of this e-mail and its attachments are confidential and intended<o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;color:black'>solely for the use of the individual or entity to whom they are addressed. If<o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;color:black'>you received this e-mail in error, please notify the HPA Postmaster, postmaster@hpa.com.au,<o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;color:black'>then delete the e-mail.<o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;color:black'>This footnote also confirms that this e-mail message has been swept for the<o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;color:black'>presence of computer viruses by Ironport. Before opening or using any<o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;color:black'>attachments, check them for viruses and defects.<o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;color:black'>Our liability is limited to resupplying any affected attachments.<o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;color:black'>HPA collects personal information to provide and market our services. For more<o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;color:black'>information about use, disclosure and access see our Privacy Policy at<o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;color:black'>www.hpa.com.au<o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;color:black'>**********************************************************************<o:p></o:p></span></font></pre></div>
</body>
</html>