Data Deploy rollback not happening

Bill Klish

TeamSite 6.5 SP1
Solaris 2.9
OpenDeploy 6.0.2

Errors are happening during a standalone DataDeploy, and the log says it is rolling back, but the rows that were inserted/updated prior to the failure are committed. Why would this be happening?

Log snippet:
DD : ERROR:Value(s) for PK column [sequence] missing in [templatedata/EnhancedProperty/GuestRooms/data/LONCHCI].
DD : ERROR:Exception occured: Value(s) for PK column [sequence] missing in [templatedata/EnhancedProperty/GuestRooms/data/LONCHCI].
com.interwoven.dd100.dd.InvalidSourceTupleException: Value(s) for PK column [sequence] missing in [templatedata/EnhancedProperty/GuestRooms/da
ta/LONCHCI].
at com.interwoven.dd100.dd.TDeleteTracker.SetPKColNameValues(TDeleteTracker.java:428)
at com.interwoven.dd100.dd.TDeleteTracker.SetPKColNameValues(TDeleteTracker.java:328)
at com.interwoven.dd100.dd.TDbSchemaAgent.UpdateDeleteTracker(TDbSchemaAgent.java:558)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:483)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:334)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:398)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:387)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:974)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:581)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:538)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:483)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:261)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:194)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:545)
at com.interwoven.dd100.dd.IWDataDeploy.run(IWDataDeploy.java:576)
DD : ERROR:WriteTuple failure to consumer[0]
DD : ERROR:Unable to process TeamSite source templatedata/EnhancedProperty/GuestRooms/data/LONCHCI, obtained from filelist=/opt/iw-home/OpenDe
ployNG/hilton/temp/108670_dd_files.txt
DD : Filelist walk done
DD : ERROR:deployment [EnhancedProperty-GuestRooms] FAILED
DD : Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DD : Stat for group [ts_metadata]:
DD : -----------------------------------
DD : Rows inserted : 1
DD : Rows updated : 0
DD : Rows deleted : 0
DD : Rows failed : 0
DD : Rows rolled back : 0
DD : Rows skipped : 0
DD : -----------------------------------
DD : Stat for group [ts_guest_rooms]:
DD : -----------------------------------
DD : Rows inserted : 1
DD : Rows updated : 0
DD : Rows deleted : 0
DD : Rows failed : 0
DD : Rows rolled back : 0
DD : Rows skipped : 0
DD : -----------------------------------
DD : Stat for group [ts_guest_rooms_details]:
DD : -----------------------------------
DD : Rows inserted : 1
DD : Rows updated : 0
DD : Rows deleted : 0
DD : Rows failed : 0
DD : Rows rolled back : 0
DD : Rows skipped : 0
DD : -----------------------------------
DD : Stat for group [ts_guest_rooms_fp_images]:
DD : -----------------------------------
DD : Rows inserted : 0
DD : Rows updated : 0
DD : Rows deleted : 0
DD : Rows failed : 0
DD : Rows rolled back : 0
DD : Rows skipped : 0
DD : -----------------------------------
DD : Stat for group [ts_guest_rooms_pt_images]:
DD : -----------------------------------
DD : Rows inserted : 2
DD : Rows updated : 0
DD : Rows deleted : 0
DD : Rows failed : 0
DD : Rows rolled back : 0
DD : Rows skipped : 0
DD : -----------------------------------
DD : Rollback database [XXXXXXX.****.****:3306/webdb]...
DD : Deployment[EnhancedProperty-GuestRooms]
DD : -----------------------------------
DD : DCRs inserted : 0
DD : DCRs updated : 0
DD : DCRs deleted : 0
DD : DCRs failed : 0
DD : DCRs rolled back : 0
DD : DCRs skipped : 0
DD : -----------------------------------
DD : Started : Fri Nov 25 12:55:06 CST 2005
DD : Finished: Fri Nov 25 12:55:15 CST 2005

Migrateduser

Have you set commit-batch-size?

Mariam