Urgent: DataDeploy help

GoldenState

Here is configuration file:
*****************************************
<data-deploy-configuration>
<client>
<deployment name="basearea">
<source>
<teamsite-templating-records
options = "wide"
area = "/default/main/efpDevelopment/STAGING">
<path name = "templatedata/eFP_proj/WebPage/data/FIAI"
visit-directory = "no" />
</teamsite-templating-records>
</source>
<destinations>
<database name="mytest"
db = "SMBEFP0T"
user="smbefp00"
password="efpsmb00"
table="TMSTE_CTNT"
vendor = "ibm"
use-db2-app-driver="yes"
timeout = "45"
real-update = "yes">
<select>
<column name="CTNT_ID"
data-type="INTEGER NOT NULL"
value-from-field="Content ID" />
</select>
<update>
<column name="CINT_HTML_TXT"
data-type="varchar(1070)"
value-from-field="Body" />
<column name="BRWSR_PAGE_TTL_TXT"
data-type="varchar(250) NOT NULL"
value-from-field="Page Title" />
</update>
<sql action="show">
select * from TMSTE_CTNT
</sql>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>
****************************************************

Here is result:

##############################
Setting up consumer TDbAgent
>>> Loading drivers <<<
Loading COM.ibm.db2.jdbc.app.DB2Driver ..
url : SMBEFP0T
login : smbefp00
login timeout=45
Connecting to the database...
Try connecting using jdbc:db2MBEFP0T...

Connected to jdbc:db2MBEFP0T
Driver IBM DB2 JDBC 2.0 Type 2
Version 07.02.0005
Connected to [SMBEFP0T]
SELECT * FROM SYSIBM.SYSTABLES WHERE NAME = 'IWOV_IDMAPS'
Building mappings cache...
Built mapping cache(s) successfully.
# column mappings: 0
# table mappings: 0
# view mappings: 0
# constraint mappings: 1
SELECT * FROM SYSIBM.SYSTABLES WHERE NAME = 'TMSTE_CTNT'
Table <TMSTE_CTNT> exists.
Running deployment [basearea]
extraction type=default
tuple mode=wide
area=/default/main/efpDevelopment/STAGING
/default/main/efpDevelopment/STAGING/templatedata/eFP_proj/WebPage/data/FIA
Generate TDCRTupleProducer start:Mon Oct 13 10:15:53 CDT 2003
Generate TDCRTupleProducer end :Mon Oct 13 10:15:54 CDT 2003
TUPLE={Conent ID=6543, TeamSite/Templating/DCR/Type=eFP_proj/WebPage, Sectio
, Section/0/Body=asdasdasdasd, Section/0/Body Header=asdasd, state=Original,
e Title=TEST, path=templatedata\eFP_proj\WebPage\Data\FIA}
TTableSchemaHelper not found in cache for [TMSTE_CTNT]. Creating new.
SELECT NAME, COLTYPE, LENGTH, NULLS FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = ?
SELECT CTNT_ID, CINT_HTML_TXT,BRWSR_PAGE_TTL_TXT FROM TMSTE_CTNT WHERE CTNT_

TTableSchemaHelper object for [TMSTE_CTNT] found in cache.
ERROR:Value for key column (CTNT_ID) is NULL
Error occured in NarrowInsertUpdate: Select() returned null ResultSet
-- Failed
ERROR:WriteTuple failure to consumer[0]
ERROR:Unable to process TeamSite source templatedata/eFP_proj/WebPage/data/F
ERROR:deployment [basearea] FAILED
Error occured in area outside TDbAgent consumer (explicit rollback initiated
Rollback database [SMBEFP0T]...
Deployment[basearea] Table[TMSTE_CTNT]
-----------------------------------
Tuples inserted : 0
Tuples updated : 0
Tuples deleted : 0
Tuples failed : 0
Tuples rolled back : 0
Tuples skipped : 0
-----------------------------------
Started : Mon Oct 13 10:15:53 CDT 2003
Finished: Mon Oct 13 10:15:54 CDT 2003

### IWDataDeploy FAILED ###

######################################

Michael

It looks like your PK column which you identify as not null
<column name="CTNT_ID"
data-type="INTEGER NOT NULL"
value-from-field="Content ID" />
</select>

has nulls in it.
ERROR:Value for key column (CTNT_ID) is NULL

That generally isn't a good thing

Cheers
Michael