DD unable to update

gnair

Hi ,Am trying to update a DCR -getting the error below and works well for the first time

erialDaemon dispatch

msg [cfg=/appl/iwov/datadeploy/conf/cmidev/contentAPI_common_ddconfig.cfg deployment="Common_Deploy" need-result="yes" logfile="/appl/iwov/datadeploy/log/iwddd.log" target="chhhdd.****.****..com:1234sxxx" usrname="user_name" pswd="password" tblname="API_CONTENT" grpname="API_CONTENT" iwovid="CONTENT_ID" path="/default/main/xxxx/Content/WORKAREA/workarea_default" filelist=DeploymentList_22062.iwv" ]
id=13 fDdArgs[0]=[cfg=/appl/iwov/datadeploy/conf/cmidev/contentAPI_common_ddconfig.cfg]
id=13 fDdArgs[1]=[deployment="Common_Deploy"]
id=13 fDdArgs[2]=[need-result="yes"]
id=13 fDdArgs[3]=[logfile="/appl/iwov/datadeploy/log/iwddd.log"]
id=13 fDdArgs[4]=[target="hhd101.txx.com:1234sxxx"]
id=13 fDdArgs[5]=[usrname="gen_app"]
id=13 fDdArgs[6]=[pswd="cm1dev"]
id=13 fDdArgs[7]=[tblname="API_CONTENT"]
id=13 fDdArgs[8]=[grpname="API_CONTENT"]
id=13 fDdArgs[9]=[iwovid="CONTENT_ID"]
id=13 fDdArgs[10]=[path="/default/main/xxxx/Content/WORKAREA/workarea_default"]
id=13 fDdArgs[11]=[filelist="DeploymentList_22062.iwv"]
Database Vendor set to oracle
ERROR:Unable to build the query for group API_CONTENT_TYPE
ERROR:Error occured while trying to delete before update
ERROR:WriteTuple failure to consumer[0]
ERROR:Unable to process TeamSite source templatedata/CMIDEV_Content/test/data/Jan3_testing_4, obtained from filelist=/tmp/DeploymentList_22062.iwv
ERROR:deployment [Common_Deploy] FAILED

The cfg file is is below .


<destinations>
<database
db="$target^"
user="$usrname^"
password="$pswd^"
vendor="oracle"
update-type="standalone"
state-field="state"
delete-tracker="yes"
real-update="no"
enforce-ri="no"
log-level="1">

<dbschema>
<group name="API_CONTENT" table="API_CONTENT" root-group="yes">
<attrmap>
<column name="CONTENT_ID" data-type="DECIMAL(22)" value-from-field="CONTENT_ID" allows-null="no" is-url="no"/>
<column name="TAXONOMY_TYPE_ID" data-type="DECIMAL(22)" value-from-field="TAXONOMY_TYPE_ID" allows-null="no" is-url="no"/>
<column name="TITLE" data-type="VARCHAR2(250)" value-from-field="TITLE" allows-null="no" is-url="no"/>
<column name="EDIT_URL" data-type="VARCHAR2(500)" value-from-field="EDIT_URL" allows-null="no" is-url="no"/>
<column name="LAUNCH_DATE" data-type="DATE" data-format="MM/dd/yyyy" value-from-field="LAUNCH_DATE" allows-null="yes" is-url="no"/>
<column name="DELETED" data-type="DECIMAL(22)" value-from-field="DELETED" allows-null="no" is-url="no"/>
<column name="DESCRIPTION" data-type="VARCHAR2(1000)" value-from-field="DESCRIPTION" allows-null="yes" is-url="no"/>
<column name="KEYWORDS" data-type="VARCHAR2(1000)" value-from-field="KEYWORDS" allows-null="yes" is-url="no"/>
<column name="CONTENT_FIELD" data-type="CLOB" value-from-field="Content_Replicant/[0-100]/CONTENT_FIELD" is-replicant="yes" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="CONTENT_ID"/>
</primary-key>
</keys>
</group>
<group name="API_TAXONOMY_TYPE" table="API_TAXONOMY_TYPE" root-group="no">
<attrmap>
<column name="TAXONOMY_TYPE_ID" data-type="DECIMAL(22)" value-from-field="TAXONOMY_TYPE_ID" is-replicant="no" allows-null="no" is-url="no"/>
<column name="TAXONOMY_TYPE_NAME" data-type="DECIMAL(22)" value-from-field="TAXONOMY_TYPE_NAME" is-replicant="no" allows-null="no" is-url="no"/>
<column name="CONTENT_TYPE_ID" data-type="DECIMAL(22)" value-from-field="CONTENT_TYPE_ID" is-replicant="no" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="TAXONOMY_TYPE_ID" />
</primary-key>
<foreign-key parent-group="API_CONTENT">
<column-pair parent-column="TAXONOMY_TYPE_ID" child-column="TAXONOMY_TYPE_ID" />
</foreign-key>
</keys>
</group>
<group name="API_CONTENT_TYPE" table="API_CONTENT_TYPE" root-group="no">
<attrmap>
<column name="CONTENT_TYPE_ID" data-type="DECIMAL(22)" value-from-field="CONTENT_TYPE_ID" is-replicant="no" allows-null="no" is-url="no"/>
<column name="TEAMSITE_PATH" data-type="DECIMAL(22)" value-from-field="TEAMSITE_PATH" is-replicant="no" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="CONTENT_TYPE_ID" />
</primary-key>
<foreign-key parent-group="API_TAXONOMY_TYPE">
<column-pair parent-column="CONTENT_TYPE_ID" child-column="CONTENT_TYPE_ID" />
</foreign-key>
</keys>
</group>
</dbschema>

not sure what is wrong here .Can some one please look into this .Thank you
Giri

Migrateduser

Were the row or rows pertaining to the DCR updated outside DD or for some reason not there in the table anymore? When real-update=no, DD deletes the row for the DCR before inserting the new row (this is how DD updates the rows for the DCR ... it's called delete + insert)

Since you are not enforcing referential integrity (enforce-ri=no), try setting real-update=yes (this tells DD to execute SQL UPDATE instead of doing a delete + insert) ... see what happens.

Mariam