Hi,
i'm trying to rename and delete a DCR but the deleted or renamed DCR could not be processed.
Does anybody know a reason for that?
I'm using TS5.5.2 and DD5.5.2.
db-schema:
<group name="VARIANTEN" table="VM_DETAIL_VARIANTE_WA" root-group="yes">
<attrmap>
<column name="ID" data-type="NUMBER" value-from-field="V_ID" allows-null="no" is-url="no" is-replicant="no"/>
<column name="NAME" data-type="VARCHAR(1000)" value-from-field="V_NAME" allows-null="no" is-url="no" is-replicant="no"/>
<column name="GEBUEHR" data-type="VARCHAR(300)" value-from-field="V_ID" allows-null="yes" is-url="no" is-replicant="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="ID" />
</primary-key>
</keys>
</group>
<group name="GEBUEHREN" table="VM_GEBUEHRENART_WA" root-group="no">
<attrmap>
<column name="ID" data-type="NUMBER" value-from-field="V_ID" allows-null="no" is-url="no" is-replicant="no"/>
<column name="GEBUEHR_NAME1" data-type="VARCHAR(100)" value-from-field="V_GEB/0/V_GEBUEHREN/0/V_GEB_NAME" allows-null="yes" is-url="no" is-replicant="no"/>
<column name="GEBUEHR_HOEHE1" data-type="VARCHAR(100)" value-from-field="V_GEB/0/V_GEBUEHREN/0/V_GEB_WERT" allows-null="yes" is-url="no" is-replicant="no"/>
<column name="WAEHRUNG" data-type="NUMBER" value-from-field="V_WAEHRUNG" allows-null="no" is-url="no" is-replicant="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="ID" />
</primary-key>
<foreign-key parent-group="VARIANTEN">
<column-pair parent-column="GEBUEHR" child-column="ID"></column-pair>
</foreign-key>
</keys>
</group>
log-file:
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWDELTRACKER'
SELECT * FROM USER_TABLES WHERE TABLE_NAME='VM_DETAIL_VARIANTE_WA'
Table [VM_DETAIL_VARIANTE_WA] exists.
SELECT * FROM USER_TABLES WHERE TABLE_NAME='VM_GEBUEHRENART_WA'
Table [VM_GEBUEHRENART_WA] exists.
Running deployment [preview]
extraction type=default
tuple mode=wide
area=/default/main/dekabank-lu/WORKAREA/dev-deka
filelist=[/data1/iw-home/local/logs/lu1/files2211.txt]
/default/main/dekabank-lu/WORKAREA/dev-deka/templatedata/lu1_produkte/varianten/data/de/produkte/sdd/SDD-Chance
Generate DirectoryContents start:Wed Nov 05 11:30:06 CET 2003
Generate DirectoryContents end :Wed Nov 05 11:30:06 CET 2003
Generate TDCRTupleProducer start:Wed Nov 05 11:30:06 CET 2003
Generate TDCRTupleProducer end :Wed Nov 05 11:30:06 CET 2003
Path not found -- interpret as 'NotPresent'
Building replicant order column information.
Building replicant order column information... Done.
TUPLE={state=NotPresent, path=templatedata/lu1_produkte/varianten/data/de/produkte/sdd/SDD-Chance}
Starting SchemaHelper Cache Cleanup Thread...
TTableSchemaHelper not found in cache for [VM_DETAIL_VARIANTE_WA]. Creating new.
SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
1 PK values retrieved from iwdeltracker for templatedata/lu1_produkte/varianten/data/de/produkte/sdd/SDD-Chance, /default/main/dekabank-lu/WORKAREA/dev-deka
TTableSchemaHelper object for [VM_DETAIL_VARIANTE_WA] found in cache.
TTableSchemaHelper not found in cache for [VM_GEBUEHRENART_WA]. Creating new.
SELECT
ELECT VM_GEBUEHRENART_WA.ID FROM VM_GEBUEHRENART_WA,VM_DETAIL_VARIANTE_WA WHERE VM_GEBUEHRENART_WA.ID = VM_DETAIL_VARIANTE_WA.GEBUEHR AND VM_DETAIL_VARIANTE_WA.GEBUEHR IN (?)
ERROR:Exception occured: null
ERROR:WriteTuple failure to consumer[0]
ERROR:Unable to process TeamSite source templatedata/lu1_produkte/varianten/data/de/produkte/sdd/SDD-Chance, obtained from ilelist=/data1/iw-home/local/logs/lu1/files2211.txt
Filelist walk done
Filelist /data1/iw-home/local/logs/lu1/files2211.txt deleted
ERROR:deployment [preview] FAILED
Error occured in area outside TDbAgent consumer (explicit rollback initiated)
Stat for group [VARIANTEN]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [GEBUEHREN]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Rollback database [cmsdev2:1521
RCL]...
Deployment[preview]
-----------------------------------
DCRs inserted : 0
DCRs updated : 0
DCRs deleted : 0
DCRs failed : 0
DCRs rolled back : 0
DCRs skipped : 0
-----------------------------------
Started : Wed Nov 05 11:30:02 CET 2003
Finished: Wed Nov 05 11:30:06 CET 2003
### IWDataDeploy FAILED ###
-- Jens
