Data Deploy Issue - Child table content getting removed itself

satyambansal

HI,

I am trying to update 2 tables using 7.3.2v DataDeploy with groups attribute.

We need to achieve :

When new DCR e.g. DCR1.xml is created, its content should go in Parent Table.
When DCR1.xml is updated, its content should go in Parent table as well as Child Table (have only updated values).

Following are the key datadeploy attributes.

real-update="yes" delete-tracker="yes" enforce-ri="no"

DD -> standalone

Both the flows works fine using data deploy , but error comes after some time (around 10-15 mins), data is automatically removed from child table, but not from Parent table.

We need content to be persistent in both the table.

Please tell me how to get this fixed?

I have attached my sample deployment descriptor.

Thnaks in Advance.

Find more posts tagged with

Comments

satyambansal

adding my insert sample deployment descriptor also.

Rick Poulin

Your data model seems very strange, so I'd suggest rethinking that first.

Either way, if you're saying the data disappears 15 minutes after a deployment, and you're sure that there have been no other deployments in that time span, then it's not DataDeploy doing the delete. Something on your database side (or some other process connecting to it) must be responsible. Ask your DBAs to check the activity logs.

praveen t n

It's probably not a DD issue. You can check whether the foreign key mappings are correct in DB tables as well.

regards,

Praveen

satyambansal

Thanks for reply .

Praveen foreign key mapping is correct as we tested in some dummy table too. Will check with DBA from database side.

satyambansal

There was DB issue . it worked smooth now . Thanks.