Datadeploy delete record with DCR update

Hi,
I have an issue with the data deploy. When I create DCR and deploy it. The records get inserted correctly in table 'LABEL'.
But, if I update the DCR and deploy it, datadeploy inserts and deletes the record.
There are three groups that insert record in one table 'LABEL'.
After update of DCR, it will only keep any one record and delete the other two.

I am attaching the log file, config and DCR.
Any pointer here is appreciated.

TS 7.2.1, OD 7.2.1 on solaris

Thanks,
Amit

Find more posts tagged with

Comments

sheikh1

There are three groups that insert record in one table 'LABEL'.
After update of DCR, it will only keep any one record and delete the other two.

One observation is at first group for table 'label' this field doesn't exists in DCR "navItem/0/localeItem/[0-10]/navItem/0"

second you are using same primary keys for all three groups, so it depends on how contraints were created in db schema, try using one unique column as primary key in your dd config as long as your db accepts those values.

itsamb

Hi sheikh,
Thanks for the response.
I checked the field does not exist. But the datadeply does not throw any issue rather inserts null value in place of that field.

I did not understand your second option correctly. Can you pls elaborate?

Snap 2016-01-08 at 16.19.28.png

praveen t n

After update of DCR, it will only keep any one record and delete the other two.

Amit

When delete-tracker option is set to yes, DataDeploy creates a table called IWDELTRACKER to track primary key values for the root group in order to retrieve, update or delete rows that represent a single data content record.

In root group you have navItemId as the primary key. And for the 3 groups you have ContentId as one of the primary key.

Add navItemId as the foreign key. Also keep unique values for ContentId for the three groups.

regards