nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data Deploy | Overwritting the data in the table

jeendru

Hi,

I am using datadeploy to deploy the dcrs to database.
I am trying to insert the multiple replicant values in to DB but while inserting the data in to table it was deleting the precious level of the data.

Please find the attached files.

Ex Level 1 --> Product
Level 2 --> Cooling System
Level 3 --> Parts

in the table first inserting the "Product" but while inserting the Cooling System it was deleting the Product & while inserting the "Parts" it was deleting the "Cooling SYstem"

Thanks
Jeendru

Find more posts tagged with

Comments

jagadesh

Please post your Datadeploy logs.

sridharg

Hi,

Looking through your datacapture the UniqueID is runtime generated from "marine_poc_get_unique_id.cgi". Can you verify if this cgi is not generating the same id for these three levels. If the Unique ID is same across - then it would overwrite Products with Cooling Systems and so on.
Since UniqueID is the only primarykey set in the configs, the iwdeltracker may not distinguish them while the values are from the same DCR.

pammi

Hi,

I didn't see in your configutation foreign-key setup on your dependant table to the primary table.

Thanks

sridharg

Is this fixed? Would you mind sharing the fix?

jeendru

Hi,

Looking through your datacapture the UniqueID is runtime generated from "marine_poc_get_unique_id.cgi". Can you verify if this cgi is not generating the same id for these three levels. If the Unique ID is same across - then it would overwrite Products with Cooling Systems and so on.
Since UniqueID is the only primarykey set in the configs, the iwdeltracker may not distinguish them while the values are from the same DCR.

I am getting the next seq value from DB using the marine_poc_get_unique_id.cgi so Uniqueid is not same accross.

Sample.rptdesign

jagadesh

I am getting the next seq value from DB using the marine_poc_get_unique_id.cgi so Uniqueid is not same accross.

Check your log files how tuples got generated. or share them