Data Deploy error.

rksonti

I am trying to simple data deployment. I created a table with 3 columns and a dcr with 3 fields.I am getting following error while running Data Deploy. Would any one help me to resolve this error. Find the DataDeploy config file in the attachment.
All the table columns have mappings in DD Config.


DBD: Deployment : dd_UTF
DBD: Database Vendor set to oracle
DBD: SQL datatype for column PRODUCT_ID is INTEGER
DBD: SQL datatype for column PRODUCT_NAME is VARCHAR2(500)
DBD: SQL datatype for column DISCRIPTION is VARCHAR2(4000)
DBD: # of columns: 3
DBD: # of primary key columns specified: 1
DBD: # of groups defined in element: 1
DBD: [Tue Jul 21 15:35:06 CDT 2009] Begin executing dd_UTF
DBD: Area VPath:/default/main/Mktg_US/STAGING
DBD: Setting up TDbSchemaAgent.
DBD: Validating cached connection...
DBD: Cached connection OK
DBD: Connected to [dlel05.eps.ti.com:1532:dktan]
DBD: SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWDELTRACKER'
DBD: SELECT * FROM USER_TABLES WHERE TABLE_NAME='UTF8TEST'
DBD: Table [UTF8TEST] exists.
DBD: Running deployment [dd_UTF]
DBD: extraction type=differential
DBD: tuple mode=wide-diff
DBD: area=/default/main/Mktg_US/STAGING
DBD: base area=/default/main/Mktg_US/EDITION/ed.20090707112602
DBD: /default/main/Mktg_US/STAGING/templatedata/Content/UTFTemplate/data
DBD: Generate ChangedDirectoryContents start:Tue Jul 21 15:35:07 CDT 2009
DBD: Generate ChangedDirectoryContents end :Tue Jul 21 15:35:07 CDT 2009
DBD: Generate TCustomDCRTupleProducer start:Tue Jul 21 15:35:07 CDT 2009
DBD: Generate TCustomDCRTupleProducer end :Tue Jul 21 15:35:07 CDT 2009
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD: TUPLE={UTFTemplate/0=

, UTFTemplate/0/Product/0/ProductDisc/0=Testing, IWOV_PROC_FLAG=true, state=Original, UTFTemplate/0/Product/0/ProductID/0=10, TeamSite/Templating/DCR/Type=Content/UTFTemplate, UTFTemplate/0/Product/0/ProductName/0=TI-83 Plus, UTFTemplate/0/Product/0=



, path=templatedata/Content/UTFTemplate/data/utf1.dcr}
DBD: ERROR:Exception occured: null
DBD: ERROR:
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.GetColum nValuesFromTuple(TDbSchemaGroupCfg.java:2208)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.BuildSel ectStmtForExistCheck(TDbSchemaGroupCfg.java:2164)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.RowsExis tForTuple(TDbSchemaGroupCfg.java:2082)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExistForT uple(TDbSchemaCfg.java:1065)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExist(TDb SchemaCfg.java:1044)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteT uple(TDbSchemaAgent.java:421)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple( TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TConsumerManager.WriteCons umerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteCons umers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSite Source(TAgentClient.java:1033)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSou rces(TAgentClient.java:517)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployme nt(TAgentClient.java:289)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClie nt.java:178)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDepl oy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDA SThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread. java:128)


DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source templatedata/Content/UTFTemplate/data
DBD: ERROR:deployment [dd_UTF] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DBD: Stat for group [UTF8TEST]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 0
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Rollback database [dlel05.eps.ti.com:1532:dktan]...
DBD: Deployment[dd_UTF]
DBD: -----------------------------------
DBD: DCRs inserted : 0
DBD: DCRs updated : 0
DBD: DCRs deleted : 0
DBD: DCRs failed : 0
DBD: DCRs rolled back : 0
DBD: DCRs skipped : 0
DBD: -----------------------------------
DBD: Started : Tue Jul 21 15:35:06 CDT 2009
DBD: Finished: Tue Jul 21 15:35:07 CDT 2009
DBD:
### IWDataDeploy FAILED ###

DBD:
### Sending result ###

ENG: 2009-07-21 15:35:07 CDT GMT-05:00 Database deployment execution returned 1

ENG: 2009-07-21 15:35:07 CDT GMT-05:00 <<< Completed database deployment Invocation>>>

ENG: 2009-07-21 15:35:07 CDT GMT-05:00 Job ID=m506 Deployment leg=database Elapsed Time=145 ms <<<
ENG: 2009-07-21 15:35:07 CDT GMT-05:00 End logfile [/opt/opendeploy6/OpenDeployNG/log/src.dd_UTFTemplate.dd_UTF.dlel58.to.database.log]


ENG: 2009-07-21 15:37:08 CDT GMT-05:00 Begin logfile [/opt/opendeploy6/OpenDeployNG/log/src.dd_UTFTemplate.dd_UTF.dlel58.to.database.log] ---------
ENG: 2009-07-21 15:37:08 CDT GMT-05:00 Job ID=m508 Deployment=dd_UTFTemplate
ENG: 2009-07-21 15:37:08 CDT GMT-05:00 DataDeploy Version is 6.2.1.0.0
ENG: 2009-07-21 15:37:08 CDT GMT-05:00 Owner started the deployment is iwui
ENG: 2009-07-21 15:37:08 CDT GMT-05:00 DD args iwdd="dd_UTF" mydbname="dktan" mytemplatepath="templatedata/Content/UTFTemplate/data" myoptions="differential wide" mybasearea="/default/main/Mktg_US/EDITION/ed.20090707112602" myarea="/default/main/Mktg_US/STAGING" cfg=/opt/opendeploy6/OpenDeployNG/conf/dd_UTFTemplate.xml need-result=yes depuuid=42540e10-7636-11de-bcf0-e6319b8331a3 leglabel=database


Regards,
Sonti

rksonti

Problem solved. There was some error in the DD config file.