Here is my dbschema.cfg
<dbschema>
<group name="FILM" root-group="yes">
<attrmap>
<column name="ID" data-type="INTEGER" value-from-field="film" allows-null="no"/>
<column name="TITLE" data-type="VARCHAR2(256)" value-from-field="title" allows-null="yes"/>
<column name="DESCRIPTION" data-type="VARCHAR2(2000)" value-from-field="description" allows-null="yes"/>
<column name="SYNOPSIS" data-type="VARCHAR2(2000)" value-from-field="synopsis" allows-null="yes"/>
<column name="EDITORS_COMMENT" data-type="VARCHAR2(4000)" value-from-field="comment" allows-null="yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="ID"/>
</primary-key>
</keys>
</group>
</dbschema>
Here is my _dd.cfg
<data-deploy-configuration>
<data-deploy-elements filepath="/interwoven/iw-home/datadeploy/conf/database.xml" />
<client>
<deployment name="basearea">
<source>
<!-- Pull data tuples from TeamSite Templating DCR's -->
<teamsite-templating-records options="wide" area="$mybasearea">
<path name="$mytemplatepath" visit-directory="deep" />
</teamsite-templating-records>
</source>
<destinations>
<!-- Oracle 8i -->
<database use="FOURDOCS" update-type="base" state-field="state">
<dbschema>
<group name="T_FILM" table="S__FILM" root-group="yes">
<attrmap>
<column name="ID" data-type="INTEGER" value-from-field="film" allows-null="no"/>
<column name="TITLE" data-type="VARCHAR2(256)" value-from-field="title" allows-null="yes"/>
<column name="DESCRIPTION" data-type="VARCHAR2(2000)" value-from-field="description" allows-null="yes"/>
<column name="SYNOPSIS" data-type="VARCHAR2(2000)" value-from-field="synopsis" allows-null="yes"/>
<column name="EDITORS_COMMENT" data-type="VARCHAR2(4000)" value-from-field="comment" allows-null="yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="ID"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
<deployment name="deltagen">
<source>
<!-- Pull data tuples from TeamSite Templating DCR's -->
<teamsite-templating-records options="differential,wide" area="$myarea" base-area="$mybasearea">
<path name="$mytemplatepath" visit-directory="deep" />
</teamsite-templating-records>
</source>
<destinations>
<!-- Oracle 8i -->
<database use="FOURDOCS" update-type="delta" state-field="state">
<dbschema>
<group name="T_FILM" table="WA__FILM" base-table="S__FILM" root-group="yes">
<attrmap>
<column name="ID" data-type="INTEGER" value-from-field="film" allows-null="no"/>
<column name="TITLE" data-type="VARCHAR2(256)" value-from-field="title" allows-null="yes"/>
<column name="DESCRIPTION" data-type="VARCHAR2(2000)" value-from-field="description" allows-null="yes"/>
<column name="SYNOPSIS" data-type="VARCHAR2(2000)" value-from-field="synopsis" allows-null="yes"/>
<column name="EDITORS_COMMENT" data-type="VARCHAR2(4000)" value-from-field="comment" allows-null="yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="ID"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
<deployment name="deltaupdate">
<source>
<!-- Pull data tuples from TeamSite Templating DCR's -->
<teamsite-templating-records options="full,wide" area="$myarea" base-area="$mybasearea">
<path filelist="$myfilelist" visit-directory="deep" delete-after-use="yes" />
</teamsite-templating-records>
</source>
<destinations>
<!-- Oracle 8i -->
<database use="FOURDOCS" update-type="delta" state-field="state">
<dbschema>
<group name="T_FILM" table="WA__FILM" base-table="S__FILM" root-group="yes">
<attrmap>
<column name="ID" data-type="INTEGER" value-from-field="film" allows-null="no"/>
<column name="TITLE" data-type="VARCHAR2(256)" value-from-field="title" allows-null="yes"/>
<column name="DESCRIPTION" data-type="VARCHAR2(2000)" value-from-field="description" allows-null="yes"/>
<column name="SYNOPSIS" data-type="VARCHAR2(2000)" value-from-field="synopsis" allows-null="yes"/>
<column name="EDITORS_COMMENT" data-type="VARCHAR2(4000)" value-from-field="comment" allows-null="yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="ID"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
<deployment name="submitlist">
<source>
<!-- Pull data tuples from TeamSite Templating DCR's -->
<teamsite-templating-records options="full,wide" area="$myarea">
<path filelist="$mysubmitlist" format="submit-status" visit-directory="deep" delete-after-use="yes" />
</teamsite-templating-records>
</source>
<destinations>
<!-- Oracle 8i -->
<database use="FOURDOCS" update-type="base" state-field="state">
<dbschema>
<group name="T_FILM" table="WA__FILM" base-table="S__FILM" root-group="yes">
<attrmap>
<column name="ID" data-type="INTEGER" value-from-field="film" allows-null="no"/>
<column name="TITLE" data-type="VARCHAR2(256)" value-from-field="title" allows-null="yes"/>
<column name="DESCRIPTION" data-type="VARCHAR2(2000)" value-from-field="description" allows-null="yes"/>
<column name="SYNOPSIS" data-type="VARCHAR2(2000)" value-from-field="synopsis" allows-null="yes"/>
<column name="EDITORS_COMMENT" data-type="VARCHAR2(4000)" value-from-field="comment" allows-null="yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="ID"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>
And ON SAVE I get this error :
Database Vendor set to oracle
Max Identifier length set to 28 characters.
SQL datatype for column ID is INTEGER
SQL datatype for column TITLE is VARCHAR2(256)
SQL datatype for column DESCRIPTION is VARCHAR2(2000)
SQL datatype for column SYNOPSIS is VARCHAR2(2000)
SQL datatype for column EDITORS_COMMENT is VARCHAR2(4000)
# of columns: 5
# of primary key columns specified: 1
# of groups defined in <dbschema> element: 1
Area VPath:/default/main/Channel4/WEB/fourdocs/WORKAREA/Ravi_Swamy
Setting up TDbSchemaSynchronizer.
Validating cached connection...
Cached connection OK
Connected to [prod004:3000:ADMAN5N1]
SELECT * FROM USER_TABLES WHERE TABLE_NAME='WA__FILM'
Table [WA__FILM] exists.
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWTRACKER'
Table [iwtracker] exists.
S__FILM not registered
Error occured in TDbSchemaSynchronizer
ERROR:TDbSchemaSynchronizer create failure.
Rollback database [prod004:3000:ADMAN5N1]...
Deployment[deltaupdate]
-----------------------------------
DCRs inserted : 0
DCRs updated : 0
DCRs deleted : 0
DCRs failed : 0
DCRs rolled back : 0
DCRs skipped : 0
-----------------------------------
Started : Tue Jul 19 12:04:20 BST 2005
Finished: Tue Jul 19 12:04:20 BST 2005
### IWDataDeploy FAILED ###
Can anyone help ???
Thanx
