Need help with an Update Transformation..

[PoppaRex]

Hi all. I have an update transformation that works for all but one record. No error messages are produced. the log file says:
WRT_8041 Updated rows - Requested: 10 Applied: 10 Rejected: 0 Affected: 9

As you see it looks like it rejected one but it simply did not update with no error/warning produced. In debug mode, it shows the records as being an update. Key looks fine. It appears to apply correctly but doesn't.

Some facts about the process.
I am processing a transaction file against the DB. A join is done against some fields and when a match is found, i send it to the update trans. The key fields for the update are taken from the DB and passed through the entire mapping as is. Key fields consist of an identity field (int) and two date/timestamps. All records sent to the update get updated with the exception of this one.
Again, no errors are displayed. (using verbose showed nothing unusual)
The single symptom (other than not getting updated) is the message that shows 9 Affected vs. 10 Applied.

Any thoughts?
Thanks!

 

[PoppaRex]

Some additional info:
In an attempt to debug, I copied the transaction record that does not update and edited one of the join fields so that it would bre recognized as an insert rather than an update. This worked and inserted a new record with identical data to the existing record that will not update, with the exception of the identitiy field.

I then modified the new record on the DB so that when i reran the trx the new trx i created should now run as an update. The darn thing updates fine. so the only difference between the one that updates and one that doesn't is the identity field.

The message now reads: WRT_8041 Updated rows - Requested: 11 Applied: 11 Rejected: 0 Affected: 10

The only other diference is the position of the records. The record not getting updated is the first row on the DB. Anything in powermart that says skip the first row??

Trx are on a table as is the update table.
Running on SQL server 2000.
Running powermart ver 5.1.1

Thanks Again!
Rob

 

[PoppaRex]

Nevermind... DOH!