Datadeploy not inserting data

TS version: 6.5, OD: 6.0.2, DCR-Type: iwov
I have a very simple deploy config file that has only one group with one to one row mapping. The deployment log shows success, but it does not update the IWDELTRACKER table or the HEADER_FOOTER table.

Here's the DD config file:
<deployment name = "dd_utilityLinks">
<source>

<teamsite-templating-records
options = "differential,wide"
area = "/default/main/DealerApplication_English/STAGING"
base-area = "/default/main/DealerApplication_English/EDITION/ed.20061106072637">
<path name = "templatedata/Setup/UtilityLinks/data" visit-directory = "deep" />
</teamsite-templating-records>
</source>
<destinations>
<database use = "IWUI"
update-type = "standalone"
delete-tracker = "yes"
log-level = "3"
real-update = "no">
<dbschema>
<group name="headerFooter" table="HEADER_FOOTER" root-group="yes">
<attrmap>
<column name="LANG_ID" data-type="VARCHAR2(4)" value-from-field="utilityLinks/0/language"/>
<column name="COUNTRY_ID" data-type="VARCHAR2(3)" list-to-replicant="yes" list-field="utilityLinks/0/siteInfo/0/country" value-from-field="utilityLinks/0/siteInfo/0/country/[0-25]/country" is-replicant="yes"/>
<column> name="DEALER_TYPE_ID" data-type="NUMBER" list-to-replicant="yes" list-field="utilityLinks/0/siteInfo/0/dealerType" value-from-field="utilityLinks/0/siteInfo/0/dealerType/[0-25]/dealerType" is-replicant="yes"/>

<column> name="BACKGROUND_IMAGE_PATH" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/headerImage/0/backgroundImageSource" />
<column> name="SIGN_OUT_LABEL" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/signOut/0/label" />
<column> name="IMAGE_GALLERY_LABEL" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/imageGallery/0/linkName" />
<column> name="IMAGE_GALLERY_LINK" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/imageGallery/0/link" />
<column> name="IMAGE_GALLERY_SORT_ORDER" data-type="NUMBER" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/imageGallery/0/sortOrder" />
<column> name="RESOURCE_LIBRARY_LABEL" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/resourceLibrary/0/linkName" />
<column> name="RESOURCE_LIBRARY_LINK" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/resourceLibrary/0/link" />
<column> name="RESOURCE_LIBRARY_SORT_ORDER" data-type="NUMBER" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/resourceLibrary/0/sortOrder" />
<column> name="AD_KITS_LABEL" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/adKits/0/linkName" />
<column> name="AD_KITS_LINK" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/adKits/0/link" />
<column> name="AD_KITS_SORT_ORDER" data-type="NUMBER" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/adKits/0/sortOrder" />
<column> name="PRODUCTS_LABEL" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/products/0/linkName" />
<column> name="PRODUCTS_LINK" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/products/0/link" />
<column> name="PRODUCTS_SORT_ORDER" data-type="NUMBER" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/products/0/sortOrder" />
<column> name="COMMENTS_LABEL" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/comments/0/linkName" />
<column> name="COMMENTS_LINK" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/comments/0/link" />
<column> name="COMMENTS_SORT_ORDER" data-type="NUMBER" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/comments/0/sortOrder" />
<column> name="CONTACTS_LABEL" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/contacts/0/linkName" />
<column> name="CONTACTS_LINK" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/contacts/0/link" />
<column> name="CONTACTS_SORT_ORDER" data-type="NUMBER" value-from-field="utilityLinks/0/siteInfo/0/headerUtilityLinks/0/contacts/0/sortOrder" />
<column> name="COPYRIGHT_SYMBOL" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/footer/0/copyright/0/linkName" />
<column> name="COPYRIGHT_LABEL" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/footer/0/copyright/0/contacts/0/copyrightStatement" />
<column> name="COPYRIGHT_LINK" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/footer/0/copyright/0/contacts/0/link" />
<column> name="TRADEMARK_LABEL" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/footer/0/trademark/0/linkName" />
<column> name="TRADEMARK_LINK" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/footer/0/trademark/0/link" />
<column> name="PRIVACY_POLICY_NAME" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/footer/0/privacyPolicy/0/linkName" />
<column> name="PRIVACY_POLICY_LINK" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/footer/0/privacyPolicy/0/link" />
<column> name="LINK_POLICY_NAME" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/footer/0/linkPolicy/0/linkName" />
<column> name="LINK_POLICY_LINK" data-type="VARCHAR2(512)" value-from-field="utilityLinks/0/siteInfo/0/footer/0/linkPolicy/0/link" />
</attrmap>
<keys>
<primary-key>
<key-column name="LANG_ID"/>
<key-column name="COUNTRY_ID"/>
<key-column name="DEALER_TYPE_ID"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>

Here's the log:

DBD: Performing delete+insert
DBD: Only one group is defined. Skipping delete for update.
DBD: TTableSchemaHelper object for [HEADER_FOOTER] found in cache.
DBD: TTableSchemaHelper object for [HEADER_FOOTER] found in cache.
DBD: SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'LANG_ID','COUNTRY_ID','DEALER_TYPE_ID')
DBD: 3 PK values retrieved from iwdeltracker for templatedata/Setup/UtilityLinks/data/test.dcr, /default/main/DealerApplication_English/STAGING
DBD: TTableSchemaHelper object for [HEADER_FOOTER] found in cache.
DBD: TTableSchemaHelper object for [HEADER_FOOTER] found in cache.
DBD: SelectCurrentRows Smiley Frustrated

ELECT BACKGROUND_IMAGE_PATH,SIGN_OUT_LABEL,IMAGE_GALLERY_LABEL,IMAGE_GALLERY_LINK,IMAGE_GALLERY_SORT_ORDER,RESOURCE_LIBRARY_LABEL,RESOURCE_LIBRARY_L
INK,RESOURCE_LIBRARY_SORT_ORDER,AD_KITS_LABEL,AD_KITS_LINK,AD_KITS_SORT_ORDER,PRODUCTS_LABEL,PRODUCTS_LINK,PRODUCTS_SORT_ORDER,COMMENTS_LABEL,COMMENTS_LINK,COMMENTS_SORT_OR
DER,CONTACTS_LABEL,CONTACTS_LINK,CONTACTS_SORT_ORDER,COPYRIGHT_SYMBOL,COPYRIGHT_LABEL,COPYRIGHT_LINK,TRADEMARK_LABEL,TRADEMARK_LINK,PRIVACY_POLICY_NAME,PRIVACY_POLICY_LINK,
LINK_POLICY_NAME,LINK_POLICY_LINK,LANG_ID,COUNTRY_ID,DEALER_TYPE_ID FROM HEADER_FOOTER WHERE LANG_ID IN (? ) AND COUNTRY_ID IN (? ) AND DEALER_TYPE_ID IN (? ) ORDER BY
LANG_ID,COUNTRY_ID,DEALER_TYPE_ID
DBD: Index: 1, value: EN
DBD: Index: 2, value: CA
DBD: Index: 3, value: 2
DBD: SelectCurrentRows: 0 rows selected.
DBD: DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
DBD: 3 rows inserted into iwdeltracker for templatedata/Setup/UtilityLinks/data/test.dcr, /default/main/DealerApplication_English/STAGING
DBD: -- Updated
DBD: Stat for group [headerFooter]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 0
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Committing database [dlel82.eps.ti.com:1521:webd]...
DBD: Deployment[dd_utilityLinks]
DBD: -----------------------------------
DBD: DCRs inserted : 0
DBD: DCRs updated : 1
DBD: DCRs deleted : 0
DBD: DCRs failed : 0
DBD: DCRs rolled back : 0
DBD: DCRs skipped : 0
DBD: -----------------------------------
DBD: Started : Mon Nov 06 08:31:40 CST 2006
DBD: Finished: Mon Nov 06 08:31:41 CST 2006
DBD:
### IWDataDeploy DONE ###

Did anybody experience this before?

Thanks in advance!!

Find more posts tagged with

Comments

cliffhanger

Okay, I found some clue to the mystery..

siteInfo is a container, so the actual syntax for the value-from-field for all these columns are:
value-from-field="utilityLinks/0/siteInfo/[0-8]/

I was initially trying without the replicant for simplicity sake only.
The posted configuration works great with or without the replicant index if the first three columns are not defined as "list-to-replicant".

I am using "iwov" type dcrs, so nested replication should not be a problem, but apparently it is...Any idea or explanation?

Thanks
-cliff

cliffhanger

This has been identified as a bug by the IW engineers. Nested replicants and list-to-replicants in the same group does not work properly(OD version: 6.0.2)

Bug ID# 69491

-cliff