HELP!!! - Deletion Problems using DataDeploy v5.2

jbyork

Windows 2000 Server
TeamSite 5.0.1 SP2
TeamSite Templating 5.0.1 SP2
DataDeploy 5.2 SP1
Oracle 8i

We are experiencing problems with DataDeploy and database deletions. We're using a very basic DCT and Metadata
template (actually, in the proof of concept, we're just using the out-of-the-box metadata example and auction DCT). Using the new
DataDeploy UI, we can successful create and map a db schema. For the first deployment, the new tables are created successfully. Inserts
and updates to database record work fine, but all deletions fail. When there are deletions, the datadeploy fails and causes a database
rollback.

Here's the error message:

DataDeploy Version 5.2.0 Build 5249 Interwoven 20011209
Database Vendor set to oracle
SQL datatype for column Item is VARCHAR(100)
SQL datatype for column Description is VARCHAR(255)
SQL datatype for column Start_Date is DATE
SQL datatype for column Seller_Location is VARCHAR(100)
SQL datatype for column Seller is VARCHAR(40)
SQL datatype for column Seller_E_Mail is VARCHAR(60)
SQL datatype for column Minimum_Bid_Amount is INT
SQL datatype for column Auction_Type is CHAR(1)
SQL datatype for column Quantity is INT
# of columns: 9
# of primary key columns specified: 1
# of groups defined in <dbschema> element: 1
Area VPath:/default/main/poc/WORKAREA/poc
Setting up TDbSchemaAgent.
>>> Loading drivers <<<
url : cepheus.sw.org:1522web
login : datadeploy
login timeout=3
Connecting to the database...
Try connecting using jdbcracle:thin:@cepheus.sw.org:1522web...

Connected to jdbcracle:thin:@cepheus.sw.org:1522web
Driver Oracle JDBC driver
Version 8.1.7.0.0
Connected to [cepheus.sw.org:1522web]
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='AUCTION'
Table [AUCTION] exists.
Running deployment [basearea]
extraction type=default
tuple mode=wide
area=/default/main/poc/WORKAREA/poc
//localhost/default/main/poc/WORKAREA/poc/templatedata/internet/auctio
n/data
Generate TDCRTupleProducer start:Wed Jan 30 10:25:59 CST 2002
Generate TDCRTupleProducer end :Wed Jan 30 10:25:59 CST 2002
TUPLE={Description=Really neat
tiffany-style lamp., Auction Type=R, IWOV_PROC_FLAG=true, Quantity=1,
state=Original, Start Date=2002-01-25, Minimum Bid Amount=10,
Item=Lamp, TeamSite/Templating/DCR/Type=internet/auction, Seller
Location=Arizona, Seller E-Mail=joe@lamps.com, Seller=Joe,
path=templatedata\internet\auction\data\lamp}
TDbSchemaGroupCfg:RowsExistForTupleELECT COUNT(*) FROM AUCTION
WHERE Item IN ( ? )
Starting SchemaHelper Cache Cleanup Thread...
TTableSchemaHelper not found in cache for [AUCTION]. Creating new.
Performing delete+insert
Only one group is defined. Skipping delete for update.
TTableSchemaHelper object for [AUCTION] found in cache.
TTableSchemaHelper object for [AUCTION] found in cache.
SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ?
AND AREA = ?
ERROR:Exception occured: null
ERROR:WriteTuple failure to consumer[0]
ERROR:Unable to process TeamSite source
templatedata/internet/auction/data
ERROR:deployment [basearea] FAILED
Error occured in area outside TDbAgent consumer (explicit rollback
initiated)
Stat for group [auction]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
-----------------------------------
Rollback database [cepheus.sw.org:1522web]...
Deployment[basearea]
-----------------------------------
DCRs inserted : 0
DCRs updated : 0
DCRs deleted : 0
DCRs failed : 0
DCRs rolled back : 0
-----------------------------------
Started : Wed Jan 30 10:25:58 CST 2002
Finished: Wed Jan 30 10:25:59 CST 2002

### IWDataDeploy FAILED ###

java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbDataTypes.convertForDataType
(TDbDataTypes.java:471)
at com.interwoven.dd100.dd.TDeleteTracker.GetPKColValues
(TDeleteTracker.java:167)
at
com.interwoven.dd100.dd.TDbSchemaUpdateHelper.SelectCurrentRows
(TDbSchemaUpdateHelper.java:182)
at
com.interwoven.dd100.dd.TDbSchemaUpdateHelper.GetOperationRequired
(TDbSchemaUpdateHelper.java:113)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate
(TDbSchemaGroupCfg.java:644)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoUpdate
(TDbSchemaGroupCfg.java:676)
at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree
(TDbSchemaCfg.java:333)
at com.interwoven.dd100.dd.TDbSchemaCfg.Insert
(TDbSchemaCfg.java:302)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple
(TDbSchemaAgent.java:399)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple
(TDbSchemaAgent.java:293)
at
com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal
(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers
(TConsumerManager.java:377)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource
(TAgentClient.java:779)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources
(TAgentClient.java:413)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment
(TAgentClient.java:237)
at com.interwoven.dd100.dd.TAgentClient.Go
(TAgentClient.java:173)
at com.interwoven.dd100.dd.IWDataDeploy.Go
(IWDataDeploy.java:355)
at com.interwoven.dd100.dd.IWDataDeploy.main
(IWDataDeploy.java:376)