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; } } }

DataDeploy-Insert

System

Hi,

I am able deploy to all tables first time. When i updated record and deploy second time it is not updating properly.

For example. In my attached config it is deleted all the records in models and first record in related_files.

pssank suggested me to add delete-tracker="yes" and update-type="standalone" but still it not updating properly

Thanx in advance

Find more posts tagged with

Comments

Migrateduser

can you post your logfiles please.

Migrateduser

Thanx for your reply

Pls. check attachment for my log.

Migrateduser

The behavior seems to be ok. You have one field called fileid in your dcr and its been used as a primary key in table related_files. Since you are changing the key value DD is deleting the existing value related to fileid 1 and replacing it with the changed value which is zero.
After the update does the content in your table reflect that in the dcr?

Migrateduser

Thanx for your reply.

U r right. I have a file id which generating based on replicant number and it is primary key.

Second time i am not changing file id at all bcz i am generated file id when ever i added new file?

Another question product_models table also not updating it deleting the existing records ?

Could pls explain below question.

After the update does the content in your table reflect that in the dcr?

Thanx

Migrateduser

Hi,

Pls. check my xml file .Even through it has has data in xml file second time when i update any thing in dcr it is not saving all the data into tables

Thanx in advance

Migrateduser

how are you generating the file id?

After the update does the content in your table reflect that in the dcr?

What I mean is does the content in the db same as that in the dcr?

Migrateduser

Hi,

Thanx for your reply. I am generating the file id in itemchange event.

in my db schema i have file id 0 and 1 but in my database it is inserting only one??

Thanx once again for your reply

Migrateduser

There is one more problem in your config file , you cannot use the same table names for multiple groups. (Eg. content_models)

Migrateduser

Hi,

Just now only i realized that i can't use same table name in multiple groups. Thanx for your help in this issue.

Now i decided to use different tables for Models,Accessories and consumables.

for example : for models -MODELS
consumables-CONSUMABLES
accessories -ACCESSORIES

using stored procedure i want to me all these table content into my original table CONTENT_MODELS so that from front end we no need change any thing.

Could pls. suggest is it possible in the above way.Could pls. point me to some example how to get it done in the above way.

Thanx in advance

Migrateduser

Hi,

If i use stored procedure using <sql> </sql>

does it will fire after all groups completed ?

bcz i want to push content three diff. tables after that i want to run stored procedures which inserts three tables data into one table ?

Thanx in advance

Migrateduser

No you would have to run the procedure in a separate deployment. Another option is to add a insert/update trigger on the table which will invoke the stored procedure.

runtime_txt.png

HAL

did you get it completed ..?
if so ..don't hesitate to post some explanation

thanks

Migrateduser

Hi,

I used separate table for each group then in i used trigger on the table level .

Thanx in advance

HAL

why trigger and not store procedure ..?

Docbroker.Docbroker.log

repo120.log

Migrateduser

Hi,

I don't have strong reason for that.My DBA suggested he will use trigger so we used.

Thanx in advance

HAL

OK
thanks for all