<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
Hi Dirk:<BR>
<BR>
I would also try deleting one of those not deleted rows in SQLPLUS.<BR>
<BR>
Regards,<BR>
Peter Bateman <BR><BR><BR>
<HR>
<BR>
From: ken.langendock@rogers.com<BR>To: powerh-l@lists.sowder.com<BR>Subject: RE: [Bulk] RE: Not All Records Being Deleted<BR>Date: Fri, 29 Aug 2008 08:53:52 -0400<BR><BR><BR>
<META content="Microsoft SafeHTML" name=Generator>
<STYLE>
.ExternalClass .EC_shape
{;}
</STYLE>
<STYLE>
.ExternalClass p.EC_MsoNormal, .ExternalClass li.EC_MsoNormal, .ExternalClass div.EC_MsoNormal
{margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass a:link, .ExternalClass span.EC_MsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.EC_MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
.ExternalClass p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass p.EC_MsoListParagraph, .ExternalClass li.EC_MsoListParagraph, .ExternalClass div.EC_MsoListParagraph
{margin-right:0cm;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass p.EC_ecmsonormal, .ExternalClass li.EC_ecmsonormal, .ExternalClass div.EC_ecmsonormal
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass span.EC_ecmsohyperlink
{;}
.ExternalClass span.EC_ecmsohyperlinkfollowed
{;}
.ExternalClass span.EC_ecemailstyle17
{;}
.ExternalClass p.EC_ecmsonormal1, .ExternalClass li.EC_ecmsonormal1, .ExternalClass div.EC_ecmsonormal1
{margin-right:0cm;margin-bottom:0cm;margin-left:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass span.EC_ecmsohyperlink1
{color:blue;text-decoration:underline;}
.ExternalClass span.EC_ecmsohyperlinkfollowed1
{color:purple;text-decoration:underline;}
.ExternalClass span.EC_ecemailstyle171
{font-family:'Arial','sans-serif';color:windowtext;}
.ExternalClass span.EC_EmailStyle26
{font-family:'Calibri','sans-serif';color:#1F497D;}
.ExternalClass .EC_MsoChpDefault
{font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;}
.ExternalClass div.EC_Section1
{page:Section1;}
.ExternalClass ol
{margin-bottom:0cm;}
.ExternalClass ul
{margin-bottom:0cm;}
</STYLE>
<DIV class=EC_Section1>
<P class=EC_MsoListParagraph style="TEXT-INDENT: -18pt"><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><SPAN>1)<SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></SPAN></SPAN><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">I ran into this a long time ago right after converting from an HP system. The date fields actually did not contain the century, powerhouse was smart enough to add the century for you so I never saw it until I ascii(date_field) in quiz to see it in a raw form. Even though your select statement would handle this I would check the contents.</SPAN></P>
<P class=EC_MsoListParagraph style="TEXT-INDENT: -18pt"><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><SPAN>2)<SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></SPAN></SPAN><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Make sure there are no foreign key constraints against this table. Maybe the error message is not showing up in QTP. Maybe try deleting in QDESIGN and see of an error message shows up there.</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Ken</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<DIV>
<DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=EC_MsoNormal><B><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com [mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <B>On Behalf Of </B>Peter Bateman<BR><B>Sent:</B> August 28, 2008 8:17 PM<BR><B>To:</B> PowerHouse Listserver<BR><B>Subject:</B> [Bulk] RE: Not All Records Being Deleted</SPAN></P></DIV></DIV>
<P class=EC_MsoNormal> </P>
<P class=EC_MsoNormal style="MARGIN-BOTTOM: 12pt"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">Hi Dirk:<BR> <BR> I would try running your script with DBAUDIT=FULL option. It might give you a clue.<BR> <BR> From the DBAUDIT you should be able to see the SQL that PowerHouse is generating.<BR> <BR> Is possible that there is an insert trigger on one of the tables that being populated by<BR> the delete trigger? This insert trigger may be causing an insert on REC under certain conditions?<BR> i.e. circular trigger logic.<BR> <BR> Make sure you have the right Oracle client linked in with PowerHouse.<BR> <BR> Customer support should be able to help you with that.<BR> <BR> Good luck,<BR> <BR> Peter</SPAN></P>
<DIV class=EC_MsoNormal style="TEXT-ALIGN: center" align=center><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">
<HR align=center width="100%" SIZE=2>
</SPAN></DIV>
<P class=EC_MsoNormal style="MARGIN-BOTTOM: 12pt"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">Subject: Not All Records Being Deleted<BR>Date: Thu, 14 Aug 2008 10:56:49 -0700<BR>From: Dirk.Rohde@vpgroup.com<BR>To: powerh-l@lists.sowder.com<BR><BR></SPAN></P>
<DIV>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">We are running a little script to delete some records in an Oracle table “REC” as follows:</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'"> </SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'">Q T P (PowerHouse 8.43.D1)</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'">Copyright 2005 COGNOS INCORPORATED</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'">Licensed PH8-UNIX-RUNTIME for customer</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'"> </SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'">> access REC</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'">> select if REC_CREATE_DATE <= 20080715</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'">> subfile SAVE_REC keep include REC</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'">> output REC delete</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'">> go</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'"> </SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'">Executing request 1 ...</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'"> </SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'">Records read:</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'"> REC 3,473</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'"> </SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'">Transactions processed: 340</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'"> </SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'">Records processed: Added Updated Unchanged Deleted</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'"> REC 0 0 0 61</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'"> SAVE_REC 340 0 0 0</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'"> </SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'">Finished.</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'">> </SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'"> </SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">This is version 8.43.D1 running on HP-UX using an Oracle 10.2 database. REC_CREATE_DATE is a date (with century included) field. There is a delete trigger on REC but it is only used to generate some data in another Oracle table. When we tried to delete just the remaining 279 records using the same code, it still would not delete the records, yet it selected them for the subfile. Has anyone seen this sort of thing happen before or have any thoughts as to why it cannot delete some of the records (without reporting an error)?</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'"> </SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P>
<TABLE class=EC_MsoNormalTable style="WIDTH: 100%" cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD style="PADDING-RIGHT: 0cm; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm">
<P class=EC_MsoNormal><SPAN lang=EN-CA style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Dirk Rohde<BR>VantagePoint Systems, Inc.<BR>T: 604-685-4209 x 239 <BR>F: 604-685-4186<BR></SPAN><SPAN lang=EN-CA> </SPAN></P></TD></TR>
<TR>
<TD style="PADDING-RIGHT: 0cm; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm">
<P class=EC_MsoNormal><SPAN lang=EN-CA><A href="http://www.vpgroup.com/" target=_blank><SPAN style="TEXT-DECORATION: none"><IMG id=EC_EC__x005f_x0000_i1025 height=105 src="cid:image001.gif@01C909B2.A9533100" width=672 border=0></SPAN></A></SPAN></P></TD></TR></TBODY></TABLE>
<P class=EC_MsoNormal><SPAN lang=EN-CA> </SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"></SPAN></P></DIV>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"><BR>This email may contain information that is privileged, confidential, or otherwise exempt from disclosure under applicable laws. Unauthorized use, reproduction or dissemination of this email is strictly prohibited. If you have received this e-mail in error please inform the sender and delete it from your mailbox or any other storage mechanism. VantagePoint Systems, Inc. cannot accept liability for any statements made which are clearly the sender's own and not expressly made on behalf of VantagePoint Systems, Inc. or one of its agents. </SPAN></P>
<DIV class=EC_MsoNormal style="TEXT-ALIGN: center" align=center><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">
<HR align=center width="100%" SIZE=2>
</SPAN></DIV>
<P class=EC_MsoNormal> </P>
<SPAN style="FONT-SIZE: 10pt">No virus found in this incoming message.<BR>Checked by AVG.<BR>Version: 7.5.524 / Virus Database: 270.6.13/1641 - Release Date: 29/08/2008 7:07 AM</SPAN><BR></DIV><BR>
<FONT size=2>No virus found in this outgoing message.<BR>Checked by AVG.<BR>Version: 7.5.524 / Virus Database: 270.6.13/1641 - Release Date: 29/08/2008 7:07 AM<BR></FONT><BR>
<FONT face=Arial size=2></FONT><BR><br /><hr /> <a href='' target='_new'></a></body>
</html>