Error during DD process

HI,
DD process return me an error only in Delete+Insert not in insert statement.
How ca I manage this?

DBSCHEMA
______________________________________________
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

<data-deploy-configuration>
<data-deploy-elements filepath="E:\iw\apps\bpm-dev\config\DBConn.cfg"/>
<client>
<deployment name="deploy">
<source>
<teamsite-templating-records options="wide" area="$workarea">
<path name="$dcr" visit-directory="no"/>
</teamsite-templating-records>
</source>
<destinations>
<database use="$dbname">
<dbschema>
<group name="PRODOTTI" table="PRODOTTI" root-group="yes">
<attrmap>
<column name="pr_num_pdo" data-type="INTEGER" value-from-field="idprodotto"/>
<column name="pr_num_cat" data-type="INTEGER" value-from-field="idcategoriaprodotto"/>
<column name="pr_dcr_pdo" data-type="CHAR(200)" value-from-field="path"/>
<column name="pr_sts_pdo" data-type="CHAR(20)" value-from-field="state"/>
<column name="pr_flg_pdo" data-type="SMALLINT" value-from-field="flgvisibile"/>
</attrmap>
<keys>
<primary-key>
<key-column name="pr_num_pdo"/>
</primary-key>
</keys>
</group>
<group name="SCHEDE" table="SCHEDE" root-group="no">
<attrmap>
<column name="sc_num_sda" data-type="INTEGER" value-from-field="idschedaprodotto"/>
<column name="sc_num_pdo" data-type="INTEGER" value-from-field="idprodotto"/>
<column name="sc_nom_pdo" data-type="VARCHAR(255)" value-from-field="nomeprodotto"/>
<column name="sc_dsc_pdo" data-type="VARCHAR(255)" value-from-field="descrizioneprodotto"/>
<column name="sc_gif_pdo" data-type="VARCHAR(255)" value-from-field="immagine"/>
<column name="sc_url_pdo" data-type="VARCHAR(255)" value-from-field="urlscheda"/>
<column name="sc_cod_lin" data-type="INTEGER" value-from-field="codicelingua"/>
</attrmap>
<keys>
<primary-key>
<key-column name="sc_num_sda"/>
</primary-key>
<foreign-key parent-group="PRODOTTI">
<column-pair parent-column="pr_num_pdo" child-column="sc_num_pdo"/>
</foreign-key>
</keys>
</group>
<group name="CROSSREFERENCE" table="CROSSREFERENCE" root-group="no">
<attrmap>
<column name="cr_num_pdo" data-type="INTEGER" value-from-field="idprodotto" is-replicant="no"/>
<column name="cr_num_ute" data-type="INTEGER" value-from-field="chiaviricerca/[0-5]/idutente" is-replicant="yes" />
<column name="cr_num_atb" data-type="INTEGER" value-from-field="chiaviricerca/[0-5]/idattributo" is-replicant="yes" />
<column name="cr_num_val" data-type="INTEGER" value-from-field="chiaviricerca/[0-5]/idvalore" is-replicant="yes"/>
<column name="cr_num_mac" data-type="INTEGER" value-from-field="chiaviricerca/[0-5]/idmacrobisogno" is-replicant="yes"/>
<column name="cr_num_mic" data-type="INTEGER" value-from-field="chiaviricerca/[0-5]/idmicrobisogno" is-replicant="yes" />
</attrmap>
<keys>
<primary-key>
<key-column name="cr_num_cro"/>
</primary-key>
<foreign-key parent-group="PRODOTTI">
<column-pair parent-column="pr_num_pdo" child-column="cr_num_pdo"/>
</foreign-key>
</keys>
</group>
</dbschema>

</database>

</destinations>
</deployment>
</client>
</data-deploy-configuration>

ERROR LOG
_______________________________________________-

E:\IW\TeamSite\iw-perl\bin>perl e:\iw\datadeploy\bin\iwdd.ipl cfg=Y:\default\ma
n\BPM-Dev\Bpm\WORKAREA\ccicognini\templatedata\privati\scheda_prodotto/dbschema
cfg deployment=deploy workarea=main/BPM-Dev/Bpm/WORKAREA/ccicognini dcr=templa
edata/privati/scheda_prodotto/data/prima_scheda dbname=Sviluppo
dd_appclass=com.interwoven.dd100.dd.IWDataDeploy
DataDeploy Version 5.5.2 Build 9275 Interwoven 20020617
TeamSite_Templating data_root is set to templatedata
Database Vendor set to ibm
SQL datatype for column pr_num_pdo is INTEGER
SQL datatype for column pr_num_cat is INTEGER
SQL datatype for column pr_dcr_pdo is CHAR(200)
SQL datatype for column pr_sts_pdo is CHAR(20)
SQL datatype for column pr_flg_pdo is SMALLINT
# of columns: 5
# of primary key columns specified: 1
SQL datatype for column sc_num_sda is INTEGER
SQL datatype for column sc_num_pdo is INTEGER
SQL datatype for column sc_nom_pdo is VARCHAR(255)
SQL datatype for column sc_dsc_pdo is VARCHAR(255)
SQL datatype for column sc_gif_pdo is VARCHAR(255)
SQL datatype for column sc_url_pdo is VARCHAR(255)
SQL datatype for column sc_cod_lin is INTEGER
# of columns: 7
# of primary key columns specified: 1
# of foreign key columns specified: 1
SQL datatype for column cr_num_pdo is INTEGER
SQL datatype for column cr_num_ute is INTEGER
SQL datatype for column cr_num_atb is INTEGER
SQL datatype for column cr_num_val is INTEGER
SQL datatype for column cr_num_mac is INTEGER
SQL datatype for column cr_num_mic is INTEGER
# of columns: 6
# of primary key columns specified: 1
# of foreign key columns specified: 1
# of groups defined in <dbschema> element: 3
Area VPath:main/BPM-Dev/Bpm/WORKAREA/ccicognini
Setting up TDbSchemaAgent.
>>> Loading drivers <<<
url : //sviudb01:6789/MCP
login : prova
login timeout=3
Connecting to the database...
Try connecting using jdbc:db2://sviudb01:6789/MCP...

Connected to jdbc:db2://sviudb01:6789/MCP
Driver IBM DB2 JDBC 2.0 Type 3
Version 07.02.0004
Connected to [//sviudb01:6789/MCP]
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: 0
SELECT * FROM SYSIBM.SYSTABLES WHERE NAME = 'IWDELTRACKER'
SELECT * FROM SYSIBM.SYSTABLES WHERE NAME = 'PRODOTTI'
Table [PRODOTTI] exists.
SELECT * FROM SYSIBM.SYSTABLES WHERE NAME = 'SCHEDE'
Table [SCHEDE] exists.
SELECT * FROM SYSIBM.SYSTABLES WHERE NAME = 'CROSSREFERENCE'
Table [CROSSREFERENCE] exists.
Running deployment [deploy]
extraction type=default
tuple mode=wide
area=main/BPM-Dev/Bpm/WORKAREA/ccicognini
/default/main/BPM-Dev/Bpm/WORKAREA/ccicognini/templatedata/privati/scheda_prodo
to/data/prima_scheda
Generate TDCRTupleProducer start:Wed Feb 26 17:19:46 CET 2003
Generate TDCRTupleProducer end :Wed Feb 26 17:19:46 CET 2003
Building replicant order column information.
Building replicant order column information... Done.
TUPLE={chiaviricerca/1/desvalore=pensionati

, chia
iricerca/1=, chiaviricerca/1/desmicrobisogno=Desidero risparmiare per i miei pr
getti futuri

, chiaviricerca/0=, chiaviricerca/1/idmicrobisogno=29, chiaviricerca/0/idu
ente=2, chiaviricerca/0/idmicrobisogno=15, idcategoriaprodotto=2, chiaviricerca
1/chk=OK, IWOV_PROC_FLAG=true, chiaviricerca/0/idvalore=4, opz=0, jollyprodotto
asdsadasd, immagine=asdasd, chiaviricerca/0/desmicrobisogno=Devo ristrutturare
acquistare una casa

, chiaviricerca/1/idattributo=2, chiaviricerca/1/idutente=2
linkcontattaci=/privati/main_privati.jsp, idprodotto=1046268542, nomeprodotto=
ipop, idlingua=1, chiaviricerca/1/idvalore=5, chiaviricerca/0/chk=OK, descrizio
eprodotto=asdasdas, altimmagine=asdasd, chiaviricerca/0/desvalore=singles e fam
glie

, chiaviricerca/1/desmacrobisogno=Valorizzare i propr
risparmi

, chiaviricerca/1/idmacrobisogno=14, idschedaprodotto=10462
8543, chiaviricerca/0/idattributo=2, chiaviricerca/0/idmacrobisogno=8, flgvisib
le=1, path=templatedata\privati\scheda_prodotto\data\prima_scheda, linkelenco=/
rivati/main_privati.jsp, chiaviricerca/0/desmacrobisogno=Finanziare i progetti

, TeamSite/Templating/DCR/Type=privati/scheda_prodotto, linknu
verde=/homepage/defalut.jsp, state=Original}
RowsExistForPath Smiley Frustrated

ELECT COUNT(*) FROM PRODOTTI WHERE pr_dcr_pdo = ?
Performing delete+insert
Starting SchemaHelper Cache Cleanup Thread...
TTableSchemaHelper not found in cache for [PRODOTTI]. Creating new.
SELECT NAME, COLTYPE, LENGTH, NULLS FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = ?
SELECT Smiley Frustrated

ELECT pr_num_cat,pr_dcr_pdo,pr_sts_pdo,pr_flg_pdo,pr_num_pdo FROM PRODO
TI WHERE pr_dcr_pdo = 'templatedata\privati\scheda_prodotto\data\prima_scheda'
BuildTuples:executeQuery returned valid result set
TTableSchemaHelper object for [PRODOTTI] found in cache.
BuildTuples:BuildRows returned: true
TTableSchemaHelper object for [PRODOTTI] found in cache.
TTableSchemaHelper not found in cache for [SCHEDE]. Creating new.
SELECT NAME, COLTYPE, LENGTH, NULLS FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = ?
SELECT Smiley Frustrated

ELECT SCHEDE.sc_num_sda FROM SCHEDE,PRODOTTI WHERE SCHEDE.sc_num_pdo =
RODOTTI.pr_num_pdo AND PRODOTTI.pr_num_pdo IN (?)
Recurse select: pIndex = 0, value = 1046268542
BuildTuples:executeQuery returned valid result set
TTableSchemaHelper object for [SCHEDE] found in cache.
BuildTuples:BuildRows returned: true
TTableSchemaHelper object for [PRODOTTI] found in cache.
TTableSchemaHelper not found in cache for [CROSSREFERENCE]. Creating new.
SELECT NAME, COLTYPE, LENGTH, NULLS FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = ?
ERROR:Exception occured: null
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaUtils.BuildColumnListFromVector(TDb
chemaUtils.java:346)
at com.interwoven.dd100.dd.TDbSchemaGroupInfoNode.BuildSelectCriteria(T
bSchemaGroupInfoNode.java:390)
at com.interwoven.dd100.dd.TDbSchemaGroupInfo.RecurseSelect(TDbSchemaGr
upInfo.java:166)
at com.interwoven.dd100.dd.TDbSchemaGroupInfo.PrepareForDelete(TDbSchem
GroupInfo.java:75)
at com.interwoven.dd100.dd.TDbSchemaCfg.BuildGroupInfo(TDbSchemaCfg.jav
:584)
at com.interwoven.dd100.dd.TDbSchemaCfg.DeleteUsingPathColumnInRootGrou
(TDbSchemaCfg.java:493)
at com.interwoven.dd100.dd.TDbSchemaCfg.Delete(TDbSchemaCfg.java:454)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgen
.java:415)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.jav
:314)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TCons
merManager.java:393)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerMan
ger.java:382)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClien
.java:834)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.
ava:423)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.ja
a:246)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:179)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:385)
at com.interwoven.dd100.dd.IWDataDeploy.runDeploy(IWDataDeploy.java:409

at com.interwoven.dd100.dd.IWDataDeploy.main(IWDataDeploy.java:401)
ERROR:WriteTuple failure to consumer[0]
ERROR:Unable to process TeamSite source templatedata/privati/scheda_prodotto/da
a/prima_scheda
ERROR:deployment [deploy] FAILED
Error occured in area outside TDbAgent consumer (explicit rollback initiated)
Stat for group [PRODOTTI]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [SCHEDE]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [CROSSREFERENCE]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Rollback database [//sviudb01:6789/MCP]...
Deployment[deploy]
-----------------------------------
DCRs inserted : 0
DCRs updated : 0
DCRs deleted : 0
DCRs failed : 0
DCRs rolled back : 0
DCRs skipped : 0
-----------------------------------
Started : Wed Feb 26 17:19:45 CET 2003
Finished: Wed Feb 26 17:19:47 CET 2003

### IWDataDeploy FAILED ###

Edited by carletto on 02/26/03 10:59 AM (server time).

Find more posts tagged with

Comments

Migrateduser

Can you send a sample DCR to reproduce the problem. BTW what platform/version of DB2 are you using ?

carletto

I solved in this way.
I added a primary key in crossreference table.

DBSCHEMA
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

<data-deploy-configuration>
<data-deploy-elements filepath="E:\iw\apps\bpm-dev\config\DBConn.cfg"/>
<client>
<deployment name="deploy">
<source>
<teamsite-templating-records options="wide" area="$workarea">
<path name="$dcr" visit-directory="no"/>
</teamsite-templating-records>
</source>
<destinations>
<database use="$dbname">
<dbschema>
<group name="PRODOTTI" table="PRODOTTI" root-group="yes">
<attrmap>
<column name="pr_num_pdo" data-type="INTEGER" value-from-field="idprodotto" is-replicant="no" allows-null="yes"/>
<column name="pr_num_cat" data-type="INTEGER" value-from-field="idcategoriaprodotto" is-replicant="no" allows-null="yes"/>
<column name="pr_dcr_pdo" data-type="CHAR(200)" value-from-field="path" is-replicant="no" allows-null="yes"/>
<column name="pr_sts_pdo" data-type="CHAR(20)" value-from-field="state" is-replicant="no" allows-null="yes"/>
<column name="pr_flg_pdo" data-type="SMALLINT" value-from-field="flgvisibile" is-replicant="no" allows-null="yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="pr_num_pdo"/>
</primary-key>
</keys>
</group>
<group name="SCHEDE" table="SCHEDE" root-group="no">
<attrmap>
<column name="sc_num_sda" data-type="INTEGER" value-from-field="idschedaprodotto" is-replicant="no" allows-null="yes"/>
<column name="sc_num_pdo" data-type="INTEGER" value-from-field="idprodotto" is-replicant="no" allows-null="yes"/>
<column name="sc_nom_pdo" data-type="VARCHAR(255)" value-from-field="nomeprodotto" is-replicant="no" allows-null="yes"/>
<column name="sc_dsc_pdo" data-type="VARCHAR(255)" value-from-field="descrizioneprodotto" is-replicant="no" allows-null="yes"/>
<column name="sc_gif_pdo" data-type="VARCHAR(255)" value-from-field="immagine" is-replicant="no" allows-null="yes"/>
<column name="sc_url_pdo" data-type="VARCHAR(255)" value-from-field="urlprodotto" is-replicant="no" allows-null="yes"/>
<column name="sc_cod_lin" data-type="INTEGER" value-from-field="codicelingua" is-replicant="no" allows-null="yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="sc_num_sda"/>
</primary-key>
<foreign-key parent-group="PRODOTTI">
<column-pair parent-column="pr_num_pdo" child-column="sc_num_pdo"/>
</foreign-key>
</keys>
</group>
<group name="CROSSREFERENCE" table="CROSSREFERENCE" root-group="no">
<attrmap>
<column name="cr_num_cro" data-type="INTEGER" value-from-field="chiaviricerca/[0-5]/idreplicant" is-replicant="yes" allows-null="no"/>
<column name="cr_num_pdo" data-type="INTEGER" value-from-field="idprodotto" is-replicant="no" allows-null="no"/>
<column name="cr_num_ute" data-type="INTEGER" value-from-field="chiaviricerca/[0-5]/idutente" is-replicant="yes" allows-null="yes" />
<column name="cr_num_atb" data-type="INTEGER" value-from-field="chiaviricerca/[0-5]/idattributo" is-replicant="yes" allows-null="yes"/>
<column name="cr_num_val" data-type="INTEGER" value-from-field="chiaviricerca/[0-5]/idvalore" is-replicant="yes" allows-null="yes"/>
<column name="cr_num_mac" data-type="INTEGER" value-from-field="chiaviricerca/[0-5]/idmacrobisogno" is-replicant="yes" allows-null="yes"/>
<column name="cr_num_mic" data-type="INTEGER" value-from-field="chiaviricerca/[0-5]/idmicrobisogno" is-replicant="yes" allows-null="yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="cr_num_cro"/>
</primary-key>
<foreign-key parent-group="PRODOTTI">
<column-pair parent-column="pr_num_pdo" child-column="cr_num_pdo"/>
</foreign-key>
</keys>
</group>
</dbschema>

</database>

</destinations>
</deployment>
</client>
</data-deploy-configuration>