Data Deploy not deleting records from Database

illusions

Hi,

Through Data deploy i am able to insert DCRs into multiple tables with out any problem, it is also updating the tables when any modifications are done in the DCR but when i delete a DCR it is not removing that corresponding record from database(multiple tables) can anyone help me on this issue.

In database tag we are using :
update-type = "standalone"
state-field = "state"
delete-tracker = "yes"
enforce-ri = "no"
real-update = "yes"

tried with enforce-ri ="yes" also but no use

Server details :
T.S 6.7.1 sp1 on Unix
OD 6.1

Adam Stoller

You have to carefully look through the entire deployment log to try to figure out what queries DD is running against which table (yours or the IWDELTRACKER table) when attempting to delete the file - and what the results of those queries are, and potentially what steps occur after those queries.

In other words - you need to spend time debugging it.

One thing to keep track of is the path used when deploying the data vs. the path used when attempting to deploy the deletion - e.g. if you deploy all your data from the staging area but the deletion is deployed from the workarea (or vice-versa) then the path information won't match up in the IWDELTRACKER table and the deletion request won't be propagated to the actual database schema.