DCR not getting deleted through DataDeploy

Hi,

We've set up DD to insert and update DCR's to Oracle 8i. Deleting DCR's dont work. Can anyone help? Have seen the rest of the posts on this but it hasn't helped.

- Dcr's are deleted from the workarea
-modified files are submitted to staging
-datadeploy is run

- have checked the filelist deployment option on Standalone deployment
-set up rest of config.
-here's the saved config file:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<data-deploy-configuration>
<client>
<deployment name="basearea">
<source>
<teamsite-templating-records custom="yes" options="wide" area="/default/main/JC/WORKAREA/ContentCreator">
<path filelist="Y://default/main/JC/WORKAREA/ContentCreator/templatedata/phonedirectory/phone/data"/>
</teamsite-templating-records>
</source>
<destinations>
<database db="x:x:x" user="x" password="x" vendor="oracle" update-type="standalone" state-field="state" delete-tracker="yes" enforce-ri="no">

<dbschema>
<group name="phone" root-group="yes">
<attrmap>
<column name="Phone_Number" data-type="VARCHAR(100)" value-from-field="Phone Number" allows-null="no" is-url="no"/>
<column name="Associated_Process" data-type="VARCHAR(100)" value-from-field="Associated Process" allows-null="no" is-url="no"/>
<column name="Department" data-type="VARCHAR(100)" value-from-field="Department" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="Phone_Number"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>

-on execution, its says failed..

Pls help!!!

Find more posts tagged with

Comments

Migrateduser

The filelist attribute should refer to a file which contains a list of files. In your case Is the filelist attribute path to a file or a directory?
Can you also post a copy of the iwdd.ipl output or redirect it to a logfile
iwdd.ipl cfg=mycfg.cfg deployment=depname logfile=mylogs.out.

<path filelist="Y://default/main/JC/WORKAREA/ContentCreator/templatedata/phonedirectory/phone/data"/>

Tina

you're right-I've currently configured it to a directory...but I'm not sure I really comprehend when you say it should refer to a 'File that contains a list of files'..could you please help me understand this better?

For eg:. the templatedata directory contains a list of files. (and so does the EDITION for that matter) Would this qualify and why? For configuring differential deployment, what is the significance of the Filelist?

Also, the mylogs.out file says:

ERROR:Config file [mycfg.cfg] not found.

### IWDataDeploy FAILED ###

Now I'm really lost!

sunil_j

Hey Tina,

Sunil Jagnani Here.

Don't use a FileList option, Instead on the previous Screen select a Directory from the Drop down and point it to the "data" Folder.

I hope that Will solve your problem.

C u soon
Sunil

Tina

Hey Sunil,

Directory works fine for deploying DCR inserts and updates...Am trying the Filelist option for differential deployment...(to delete DCRs)..

psanks: I've tried pointing to the filelist.jsp in the Datadeploy bin....attaching the output log...its says DONE and says its deleted 31 DCR's (!!) but this doesn't reflect in my sql query to the oracle table..

Migrateduser

When I said use filelist in the path element you need to specify the path to a file which contains the files you want to deploy
Eg: myfilelist.txt could contain
templatedata/metadata/a.xml
templatedata/metadata/a.xml
...
And your path element should look like this

area = "/default/main/branch/WORKAREA/testwa"
<path filelist = "c:/temp/foo.txt" />

Another option is to run a differential deployment between two areas, please refer to manual for more information on differential deployments:

To configure an incremental deployment, set the <teamsite-extended-attributes> or
<teamsite-templating-records> elements as follows. The result is a delta table containing
the differences between vpath1 and vpath2.
<teamsite-extended-attributes
options="differential"
area="vpath1"
base-area="vpath2"
...additional subelements if necessary...
</teamsite-extended attributes>