[Bulk] RE: Not All Records Being Deleted

[Ken Langendock]

1)      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.

2)      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.

 

Ken

 

 

 

From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Peter Bateman
Sent: August 28, 2008 8:17 PM
To: PowerHouse Listserver
Subject: [Bulk] RE: Not All Records Being Deleted

 

Hi Dirk:
 
   I would try running your script with DBAUDIT=FULL option. It might give
you a clue.
   
   From the DBAUDIT you should be able to see the SQL that PowerHouse is
generating.
 
   Is possible that there is an insert  trigger on one of the tables that
being populated by
   the delete trigger? This insert trigger may be causing an insert on REC
under certain conditions?
   i.e. circular trigger logic.
 
   Make sure you have the right Oracle client linked in with PowerHouse.
 
   Customer support should be able to help you with that.
 
   Good luck,
 
   Peter

   _____  

Subject: Not All Records Being Deleted
Date: Thu, 14 Aug 2008 10:56:49 -0700
From: Dirk.Rohde at vpgroup.com
To: powerh-l at lists.sowder.com



We are running a little script to delete some records in an Oracle table
“REC” as follows:

 

Q T P   (PowerHouse  8.43.D1)

Copyright 2005 COGNOS INCORPORATED

Licensed PH8-UNIX-RUNTIME for customer

 

> access REC

> select if REC_CREATE_DATE <= 20080715

> subfile SAVE_REC keep include REC

> output REC delete

> go

 

Executing request 1 ...

 

Records read:

  REC                                  3,473

 

Transactions processed:                  340

 

Records processed:                     Added    Updated  Unchanged
Deleted

  REC                                      0          0          0
61

  SAVE_REC                               340          0          0
0

 

Finished.

> 

 

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)?

 


Dirk Rohde
VantagePoint Systems, Inc.
T: 604-685-4209 x 239 
F: 604-685-4186
  


HYPERLINK "http://www.vpgroup.com/" \n

 


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. 

   _____  

 

No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.6.13/1641 - Release Date: 29/08/2008
7:07 AM


No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 270.6.13/1641 - Release Date: 29/08/2008
7:07 AM
 
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20080829/f5b7202c/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 9443 bytes
Desc: not available
Url : http://lists.sowder.com/pipermail/powerh-l/attachments/20080829/f5b7202c/attachment-0001.gif