I am trying to deploy metadata of a dcr to database using datadeploy and I am getting this error.
===========================================================================
Database Vendor set to oracle
Max Identifier length set to 28 characters.
SQL datatype for column Title is VARCHAR(100)
SQL datatype for column Keywords is VARCHAR(100)
SQL datatype for column Description is VARCHAR(100)
SQL datatype for column Business_Unit is VARCHAR(100)
SQL datatype for column Creation_Date is DATE
SQL datatype for column Expiration_Date is DATE
# of columns: 6
# of primary key columns specified: 1
WARNING:Assuming group name as the table name for [Master].
# of groups defined in <dbschema> element: 1
Area VPath:/default/main/Safari/WORKAREA/work
Setting up TDbSchemaAgent.
>>> Loading drivers <<<
url : delmrraman:1521:CMSPOC
login : dev
login timeout=3
Connecting to the database...
Try connecting using jdbc
racle:thin:
@delmrraman:1521:CMSPOC...
Connected to jdbc
racle:thin:
@delmrraman:1521:CMSPOC
Driver Oracle JDBC driver
Version 9.0.1.1.0
Connected to [delmrraman:1521:CMSPOC]
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWOV_IDMAPS'
Building mappings cache...
Built mapping cache(s) successfully.
# column mappings: 0
# table mappings: 0
# view mappings: 0
# constraint mappings: 0
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWDELTRACKER'
SELECT * FROM USER_TABLES WHERE TABLE_NAME='MASTER'
Table [Master] exists.
Running deployment [eauds]
extraction type=default
tuple mode=narrow
area=/default/main/Safari/WORKAREA/work
/default/main/Safari/WORKAREA/work/templatedata/Safari/News/data/vivektest
Generate DirectoryContents start
at Oct 30 14:11:39 IST 2004
Generate DirectoryContents end
at Oct 30 14:11:39 IST 2004
Generate TFullEAExtractor start
at Oct 30 14:11:39 IST 2004
Generate TFullEAExtractor end
at Oct 30 14:11:39 IST 2004
Building replicant order column information.
Building replicant order column information... Done.
TUPLE={key=TeamSite/Metadata/Business Unit, IWOV_PROC_FLAG=true, state=Original, value=Admin, path=templatedata\Safari\News\data\vivektest}
ERROR:Values for PK column [Title] missing in [templatedata\Safari\News\data\vivektest].
ERROR:Exception occured: Values for PK column [Title] missing in [templatedata\Safari\News\data\vivektest].
com.interwoven.dd100.dd.InvalidSourceTupleException: Values for PK column [Title] missing in [templatedata\Safari\News\data\vivektest].
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.BuildSelectStmtForExistCheck(TDbSchemaGroupCfg.java:2083)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.RowsExistForTuple(TDbSchemaGroupCfg.java:2002)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExistForTuple(TDbSchemaCfg.java:1052)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExist(TDbSchemaCfg.java:1031)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:411)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:331)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:398)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:387)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:961)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:464)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:256)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:188)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:487)
at com.interwoven.dd100.dd.IWDataDeploy.runDeploy(IWDataDeploy.java:527)
at com.interwoven.dd100.dd.IWDataDeploy.main(IWDataDeploy.java:508)
ERROR:WriteTuple failure to consumer[0]
ERROR:Unable to process TeamSite source templatedata/Safari/News/data/vivektest
ERROR:deployment [eauds] FAILED
Error occured in area outside TDbAgent consumer (explicit rollback initiated)
Stat for group [Master]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Rollback database [delmrraman:1521:CMSPOC]...
Deployment[eauds]
-----------------------------------
Files with EAs inserted : 0
Files with EAs updated : 0
Files with EAs deleted : 0
Files with EAs failed : 0
Files with EAs rolled back : 0
Files with EAs skipped : 0
-----------------------------------
Started : Sat Oct 30 14:11:39 IST 2004
Finished: Sat Oct 30 14:11:39 IST 2004
### IWDataDeploy FAILED ###
===========================================================================
My database xml looks like this
===========================================================================
<?xml version="1.0" encoding="UTF-8"?>
<data-deploy-elements>
<database name="oracle8_db"
db="delmrraman:1521:CMSPOC"
user="dev"
password="dev"
vendor = "oracle"
max-id-length = "28">
</database>
</data-deploy-elements>
===========================================================================
and my configuration file looks like this
===========================================================================
<data-deploy-configuration>
<data-deploy-elements filepath="C:/iw-home/DataDeploy/conf/database.xml"/>
<client>
<deployment name="eauds">
<source>
<teamsite-extended-attributes option="wide"
area="/default/main/Safari/WORKAREA/work">
<path name = "templatedata/Safari/News/data/vivektest"
/>
</teamsite-extended-attributes>
</source>
<destinations>
<database use="oracle8_db" update-type="standalone" state-field="state" delete-tracker="yes">
<dbschema>
<group name="Master" root-group="yes">
<attrmap>
<column name="Title" data-type="VARCHAR(100)" value-from-field="TeamSite/Metadata/Title" allows-null="no"/>
<column name="Keywords" data-type="VARCHAR(100)" value-from-field="TeamSite/Metadata/Keywords" allows-null="yes"/>
<column name="Description" data-type="VARCHAR(100)" value-from-field="TeamSite/Metadata/Description" allows-null="yes"/>
<column name="Business_Unit" data-type="VARCHAR(100)" value-from-field="TeamSite/Metadata/Business Unit" allows-null="yes"/>
<column name="Creation_Date" data-type="DATE" value-from-field="TeamSite/Metadata/Creation Date" data-format="yyyy-MM-dd" allows-null="yes"/>
<column name="Expiration_Date" data-type="DATE" value-from-field="TeamSite/Metadata/Expiration Date" data-format="yyyy-MM-dd" allows-null="yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="Title"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>
===========================================================================
If I look at the extended attributes, I can see all the values set
C:\iw-home\bin>iwextattr.exe -l /default/main/Safari/WORKAREA/work/templatedata/
Safari/News/data/vivektest
TeamSite/Metadata/Business Unit=Admin
TeamSite/Metadata/Business Unit/Admin=y
TeamSite/Metadata/Creation Date=2004-12-12
TeamSite/Metadata/Description=Vivek Description
TeamSite/Metadata/Expiration Date=2005-12-12
TeamSite/Metadata/Keywords=Vivek Keyword
TeamSite/Metadata/Title=Vivek
TeamSite/Templating/DCR/Type=Safari/News
numberOfChunks=1
subjectMetadata0=<?xml version="1.0" encoding="UTF-8" ?> <metadata></metadata>
================================================================================
Please let me know what I am missing that I am getting this error.
