deployment never deletes rows, only updates

koryakm

i have a pretty standard deployment: 1 root group, 1 primary key. Use can add or delete rows by using a replicant on the DCR, when user deletes a replicant, the change is not reflected in the DB.

i have:
DataDeploy Version is 6.1.1.0.0
Teamsite 6.5 SP2

I am including the log file and the DD config file

hitc

There is multiple choices here. You could use the clear-table option wich always clear the table before inserting in it.This only work if you always deploy the full content.

You could put back the column Path
column name="Path" value-from-field="path" />
This column is used by teamsite to update records,without it,TS has a hard time retrieving his stuff.

maybe you should turn of the delete tracker if you are not using path like this:
delete-tracker = "no" ignore-delete-tracker = "yes"

there is also the sql command before the deploy:
sql user-action = "clean-table" type = "query">
![CDATA[
DELETE FROM TABLE_**** WHERE mycolumn= 'blabla'
SELECT COUNT (*) FROM TABLE_**** (the sql command always have to send a value back...this is mandatory)
]]>
/sql>