Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
DataDeploy 5.2 : delete-tracker="no" FAILS
Michael
I want to perform a data deployment from an XML file to a database. I don't need to perform deletes on this table.
I have followed the instructions in the DD Admin Guide regarding the delete-tracker attribute - I have a column in my dbschema mapped to the path value and shouldn't require delete-tracker="yes" (config file below).
I then receive this error when I attempt to run the deployment: ERROR:delete-tracker attribute is not set or set to "no". Deletions may not be possible. Refer to DataDeploy manual.
ERROR:TDbSchemaAgent create failure.
Started : Wed Sep 18 08:47:32 EST 2002
Finished: Wed Sep 18 08:47:33 EST 2002
### IWDataDeploy FAILED ###
Is there a problem with my configuration file?
DATA DEPLOY CONFIGURATION FILE
------------------------------
<data-deploy-configuration>
<data-deploy-elements filepath="c:/dd-home/conf/database.xml" />
<client>
<deployment name="metadata_dd">
<source>
<xml-formatted-data file="$xmlFile" />
</source>
<destinations>
<database use="$targetDB" delete-tracker="yes">
<dbschema>
<group name="document_metadata" root-group="yes" table="DOCUMENT_METADATA">
<attrmap>
<column name="ID"
value-from-field="path"
allows-null="no" />
<column name="NAME"
data-type="VARCHAR(240)"
value-from-field="key"
allows-null="no" />
<column name="STATE"
data-type="VARCHAR(50)"
value-from-field="state"
allows-null="yes" />
<column name="VALUE"
data-type="VARCHAR(2000)"
value-from-field="value"
allows-null="yes" />
</attrmap>
<keys>
<primary-key>
<key-column name="ID" />
<key-column name="NAME" />
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>
------------------------------
If I change delete-tracker to ="yes" my deployment will run, however I end up getting a java.lang.NullPointerException at com.interwoven.dd100.dd.TDbSchemaGroupInfoNode.DoDelete(TDbSchemaGroupInfoNode.java:545). Hopefully I shouldn't need to worry about this error though if I can a turn delete-tracker off for this table/deployment?
Thanks for any help you can provide!
Cheers
Michael
PS: Environment details are: DataDeploy Version 5.2.1 Build 7003 Interwoven 20020311 Running on NT Deploying to an Oracle 8i database
Find more posts tagged with
Comments
Migrateduser
Try to upgrade to DD521.
bscott1
We have the same DD build and tried it both ways (set to yes and no) and got the same error with delete tracker set to no. We tried everything including opening a case and never got a fix for it. As it doesn't hurt anything (except create another iwdeltracker table in the DB) we just left it set to yes. You may want to raise this as a case.
Michael
Thanks! Nice to know someone else has had the same problem - and I'm not going mad
.
The response from support was that:
xml-formatted-data to
database deployment does not officially support User Defined Schema.
Please use wide table and test it again. It should work for wide table.
And it does appear to work for wide-table as they suggest. My worry is that I originally did it as a wide-table but for a good reason I changed it. If only I could remember what that reason was!!!!!!