DataDeploy Version 5.6.0 Build 19499 Interwoven 20030506
Database Vendor set to oracle
TS 6.1SP2 Sol 9
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
I'm seeing an issue where CLOB fields are set correctly from my DCR on insert, but when I data deploy after the DCR updates, the CLOB fields are erased. All other non CLOB fields are preserved.
The DCR contains the CLOB data. The size of the field is currently less than 100 chars (but will get much bigger, thus the need for a CLOB).
No errors appear in the dd command output. 1 DCR updates successfully.
My dd config:
<data-deploy-configuration>
<data-deploy-elements filepath="/cms/iw-home/dd-home/datadeploy/conf/database.xml" />
<client>
<!-- database.xml contains all the parameters used to connect to Oracle database -->
<!-- This deployment is synchronizing JOB DCR's to the JOB table structure in Oracle -->
<!-- deployment name is used to deploy at iwdd.ipl -->
<deployment name="irc_job">
<source>
<teamsite-templating-records options ="wide" area = "/default/main/CCMC/WORKAREA/development" custom="yes">
<path name = "$dcr_to_deploy" visit-directory = "deep" />
</teamsite-templating-records>
</source>
<!-- custom="yes" indicates that this is a customised dd config file. It is a very important parameter. The info about other parameters such as Path Name, and Visit Direcotry can be found in DataDeploy 5.6 manual -->
<destinations>
<database use ="ccmc_dev" update-type = "standalone" delete-tracker="yes">
<dbschema>
<group name="Job" table="Job" root-group="yes">
<attrmap>
<column name="ProjectID" data-type="varchar2(10)" value-from-field="job/0/ProjectID/0" data-format="04yyyynnnn" allows-null="no" />
<column name="StatementOfWork" data-type="CLOB" value-from-field="job/0/StatementOfWork/0" />
</attrmap>
<keys>
<primary-key >
<key-column name="ProjectID" />
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
</data-deploy-configuration>
