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 Update/Delete without Tracker

WillyRocks

Hi!

Maybe someone can point us in the right direction here...
We're having a similar issue to this post where we can add records to a DB, but fail when it comes to updating or deleting, with the exception that we're only using 1 table instead of multiple related tables. TS 6.0 Solaris8 w/ DD 5.6, Not using DAS.

From what I can gather, we are not using the delete tracker, instead we are using the path & state columns to emulate the updates- which I'm also having trouble with DD using these as it should, but I'm a little unclear on how the fixes in the aforementioned post that mention foreign key relations would help us, being that it's a single table. Any thoughts?

Any help would be appreciated! Smiley Happy

- Will

Find more posts tagged with

Comments

clogan

Do you have a column in your table that maps to the path variable? I usually use the deltracker table, but I think if you don't, you need it in your root group.

Posting your config file might help us find your problem.

Dwayne

Is it possible to post your dd deployment config file? That might go a long way toward tracking down the problem.

--

Current project: TS 5.5.2/6.1 W2K

WillyRocks

Thanks for the expediaent response, everyone! Smiley Happy

Here is our DD config:
----------------------------------------------------

<?xml version='1.0'?>
<data-deploy-configuration>
<data-deploy-elements filepath="$ddhome/conf/database.xml" />
<client>

<deployment name="DCR-TO-DB">
<source>

<teamsite-templating-records
options = "wide"
area = "$area">
<path filelist="$filelist" />
</teamsite-templating-records>
</source>

<substitution>
<field name='path'
match='(.*)data[\\/]([0-9]*)(||[^0-9].*)$'
replace='$2'
/>
</substitution>

<destinations>

<database use = "$server" update-type = "standalone">
<dbschema>
<group name="RSSPANNOUNCEMENTS" table="RSSP_ANNOUNCEMENTS" root-group="yes">
<attrmap>
<column name="ANNID" data-type="NUMBER" value-from-field="announcement_id" is-replicant="no" allows-null="no" />
<column name="ANNTYPE" data-type="VARCHAR(30)" value-from-field="announcement_type" is-replicant="no" allows-null="yes" />
<column name="PUBDATE" data-type="DATE" data-format="yyyy-mm-dd" value-from-field="publish_date" is-replicant="no" allows-null="yes" />
<column name="EXPDATE" data-type="DATE" data-format="yyyy-mm-dd" value-from-field="expiration_date" is-replicant="no" allows-null="yes" />
<column name="ANNTITLE" data-type="VARCHAR(150)" value-from-field="announcement_title" is-replicant="no" allows-null="yes" />
<column name="FILNAME" data-type="VARCHAR(150)" value-from-field="file_name" is-replicant="no" allows-null="yes" />

</attrmap>

<keys>
<primary-key>
<key-column name="ANNID"/>
</primary-key>
</keys>

</group>
</dbschema>
</database>
</destinations>
</deployment>



<deployment name="DCR-TO-INDEX">
<source>

<teamsite-templating-records
options = "wide"
area = "$area">
<path filelist="$filelist" />
</teamsite-templating-records>
</source>
<substitution>
<field name='path'
match='(.*)data[\\/]([0-9]*)(||[^0-9].*)$'
replace='$2'
/>
</substitution>

<destinations>
<database use = "$server" update-type = "standalone">
<dbschema>
<group name="RSSPANNOUNCEMENTS" table="IWOV_RSPANNOUNCEMENTSINDEX" root-group="yes">
<attrmap>
<column name="PATH" data-type="VARCHAR(40)" value-from-field="path" is-replicant="no" allows-null="no" />
<column name="STATE" data-type="VARCHAR(40)" value="$val" is-replicant="no" allows-null="yes" />
<column name="NAME" data-type="VARCHAR(40)" value-from-field="offer_name" allows-null="yes" />
<column name="PUBDATE" data-type="DATE" value="$date" data-format='yyyy-MM-dd' allows-null="yes" />
<column name="TITLE" data-type="VARCHAR(80)" value-from-field="content_title" allows-null="yes" />
</attrmap>

<keys>
<primary-key>
<key-column name="PATH"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>

<deployment name="INDEXXML">
<source>
<database use = "$server" table="IWOV_RSPANNOUNCEMENTSINDEX">
<fields>
<field name='path' column='PATH'/>
<field name='state' column='STATE'/>
<field name='name' column='NAME'/>
</fields>
</database>
</source>

<destinations>
<xml-formatted-data file="$filelist" options='wide'>
</xml-formatted-data>
</destinations>
</deployment


</client>
</data-deploy-configuration>

clogan

Have you tried the deployment without the substitution on the path field?