Datadeploy not removing deleted DCR for DB

Jeremy

TeamSite 7.3

OD 7.3.2

 

Hi,

 

I've trimmed down my DD conf file to the very basics of 4 columns.

I create a DCR.

Submit the DCR to STAGING.

Run OD from the command line to fire the deployment.

DCR is in Database - This is a differential deployment of Staging and a previous EDITION.

 

Delete DCR from Workarea, and Submit the deleted DCR.

 

Run OD from teh command line again.

 

This should delete the DCR from the database but the record is still there.

 

I run an iwcmp on the STAGING area and the EDITION and it shows the DCR has been deleted in STAGING, so I would expect this DCR to be deleted from the DB.

 

See the DD config file below.

 

<data-deploy-configuration>
<data-deploy-elements filepath="/iwenv/iw-home/opendeploy/OpenDeployNG/etc/database.xml" /> 

<client>
 <deployment name="frontend_BEE">
		<source>
			<teamsite-templating-records options="differential"
			area="/default/main/prd/intranet/thematics/th_b2e/tp11_testcv_migr/tp1101_jmtestmigr/STAGING" custom="yes" include-extended-attributes="no" base-area="/default/main/prd/intranet/thematics/th_b2e/tp11_testcv_migr/tp1101_jmtestmigr/EDITION/Frontend Deployment 2015-11-27_07:50">
			<path name="templatedata/pages/StandardPage/data" visit-directory="deep" />
			</teamsite-templating-records>
		</source>
		<destinations>			
			<database  log-level="3" use="BEE" delete-tracker="yes" enforce-ri="yes" real-update="no">
				<dbschema>
				   <group name="PAGE" root-group="yes" table="PAGE_TEST">
				      <attrmap>
				      	<column name="path" data-type="VARCHAR2(255)" value-from-field="path" allows-null="no"/>	
				      	 <column name="ID" data-type="VARCHAR2(256)" value-from-element="root/0/common/0/PageName/0" allows-null="no" is-url="no"/>
				         <column name="BRANCH_ID" data-type="VARCHAR2(4000)" value="path_for_id_test" allows-null="no" is-url="no"/>
				         <column name="TYPE" data-type="CHAR(1)"  value="S" allows-null="no" is-url="no"/>
				      </attrmap>
				      <keys>
				         <primary-key>
				            <key-column name="path"/>
				            <key-column name="ID"/>
				            <key-column name="BRANCH_ID"/>
				            <key-column name="TYPE"/>
				         </primary-key>
				      </keys>
				   </group>
				</dbschema>
			</database>
		</destinations>
	</deployment>
    </client>
</data-deploy-configuration>

Please note - I cannot use clear-tables="yes" as this table is used by multiple different DD deployments.

 

Any ideas where I'm going wrong, or could someone try replicate the same so I can tell if this is a me error, or a TeamSite error.

 

Thanks.

 

Jeremy

 

 

 

Rick Poulin

Has OD identified that the file should be deleted from the DB? You'll have to provide the micro log if you want any assistance on this.