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

deletion of corresponding record from DB after deletion of dcr

maverick83

hi

the req is that if we delete a dcr from workarea ,the corresponding record should also get deleted from DB,updating /insertion
is happening perfectly

i did some search in pdf and forums and inserted below lines in my DD config file

[php]

update-type="standalone"
delete-tracker="yes"
state-field="state">
[/php]

but it still doenst work ,some thing like "filelist" deployment came up in forums but it is not described properly in pdf

any pointers regarding this?

regards,
mav

Find more posts tagged with

Comments

vikasp

Filelist is related to Opendeploy & Datadeploy too

Migrateduser

Filelist is related to Opendeploy not DataDeploy.

that is incorrect, DataDeploy uses filelist deployments just as does OpenDeploy does..

as for deletions, if delete-tracker is turned on (or the path attributed is used in the root table), and your DD config is correctly setup, it should handle your deletes should work.. you would need to post your DD logs (on insert and deleting deployments), your DD config, sample DCR etc.. if you really want any help.

Otherwise, it's read the manual and/or get some DataDeploy training.

maverick83

please find attached my DD config file and sample DCR ,

shall i post DD logs ,the size seems bit big for attachement

please provide some poitners regarding deletion issue?

regards.
mav

grid-size2.JPG

BlueWhale

Hello Maverick,

As per the DD admin guide:

[left]

[/left]

delete-tracker - indicates whether OpenDeploy should create an internal system

table called IWDELTRACKER. This table is used to track primary key values which is

necessary when OpenDeploy retrieves, updates, or deletes rows.

The delete-tracker attribute value is no if you have defined a column named Path

in your tables. When OpenDeploy sees a column named Path it will insert the path

of the file as the value of the column. Since file paths are always unique, a path

value can serve as a primary key for a table. So in this case, the IWDELTRACKER table

is not necessary.

The delete-tracker attribute is set to yes in this example, since our schema does

not have a column named Path.

So, you don't need to turn on delete-tracker for this. Also, I think having the DCRPath column in the tables is playing the main role in causing the Primay Key validation issue that you posted in other thread. Just play with this to see any result.

merry

Hi Maverick,

I have a questions regarding your dd config file. It shows :
[html]

[/html]

But, if the deployment is from Teamsite to database source (as per the pdf) should look something like:
[html]

[/html]
Is there any specific reason, that u r doing it this way?

Thanks.

maverick83

thanks for ur reply ,

i replaced xml-source with templating ...... but nothing really changed ,i also turned off delete-tracker coz i am using path value

i am attaching my log file ,i deleted a dcr del_check ,i have just copied some messages realted to del_check in this log file i am not sure how much it ll help

pls reply if u got any idea regarding this ,

regards,
mav

Migrateduser

thanks for ur reply ,

i replaced xml-source with templating ...... but nothing really changed ,i also turned off delete-tracker coz i am using path value

i am attaching my log file ,i deleted a dcr del_check ,i have just copied some messages realted to del_check in this log file i am not sure how much it ll help

pls reply if u got any idea regarding this ,

regards,
mav

check your areapath.. it might be that your deploying from staging, but deleting from your workarea, or that the cached mount is not really removing it yet, so it can still find it..