Hello all, im going nuts here. this is the first time weve attempted to deploy nested replicants to a database, and we are having major issues. things work fine when the user creates a new DCR and does a submit-direct (writing it to our staging tables)
im attching our dbchema.cfg file and a snippet from the iwddd.log.
however, if the user updates the DCR and moves replicants around and or deletes some, i get oracle constraint errors when they try to stage again. it appears instead of deleting the modified rows on staging, its trying to reinsert them first!
INSERT INTO IWT_109ECFD18D19(Path,rep_order,audience_category,audience_firm,ad_target_web_ad,ad_target_web_ad_right,which_homepage,which_homepage_pos,publish_date,expiration_date,image_key,content_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)
Column: Path, field: path, Index: 1,Converting 'templatedata\common\ad\data\CN_PLZWORK_13288_NoProjectNameFound.xml' to VARCHAR
Column: rep_order, field: ad_type/1/web_ad/0/ad_loc/0/rep_order, Index: 2,Converting '15274777' to DECIMAL
Column: audience_category, field: ad_type/1/web_ad/0/ad_loc/0/audience_category, Index: 3,Converting 'unregistered_webuser, proftrust, profplanner, profindbroker, profbroker, profbankbroker, insttpa, instins, instdefcon, instdefben, instcpa, instconslt, instcashman, instadfeeonly, instadfee, instadcom' to VARCHAR
Column: audience_firm, field: ad_type/1/web_ad/0/ad_loc/0/audience_firm, Index: 4,Converting 'hibernia, huntington_national, manufacturer_traders, riggs, us_trust, wesbanco' to VARCHAR
Column: ad_target_web_ad, field: ad_type/1/web_ad/0/ad_loc/0/ad_target_web_ad, Index: 5,Converting 'smoochies' to VARCHAR
Column: ad_target_web_ad_right, field: ad_type/1/web_ad/0/ad_loc/0/ad_target_web_ad_right, Index: 6,Converting '' to VARCHAR
Column: which_homepage, field: ad_type/1/web_ad/0/ad_loc/0/which_homepage, Index: 7,Converting 'Sales Resources' to VARCHAR
Column: which_homepage_pos, field: ad_type/1/web_ad/0/ad_loc/0/which_homepage_pos, Index: 8,Converting 'Middle - Left Column' to VARCHAR
Column: publish_date, field: ad_type/1/web_ad/0/ad_loc/0/publish_date, Index: 9,Converting '10-23-2004' to TIMESTAMP
Column: expiration_date, field: ad_type/1/web_ad/0/ad_loc/0/expiration_date, Index: 10,Converting '' to TIMESTAMP
Column: image_key, field: ad_type/1/web_ad/0/image_key, Index: 11,Converting 'Test Adgifad529Gifting170x70gif' to VARCHAR
Column: content_id, field: content_id, Index: 12,Converting '13288' to DECIMAL
*******************************************************
SQLException occured in TDbSchemaGroupCfg
Exception Message: ORA-00001: unique constraint (METADATA.IWT_109ECFD18D19_KEY) violated
Vendor Error Code: 1
SQL state: 23000
*******************************************************
*******STACK TRACE*************
java.sql.SQLException: ORA-00001: unique constraint (METADATA.IWT_109ECFD18D19_KEY) violated
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1846)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1771)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2361)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.InsertOneRow(TDbSchemaUpdateHelper.java:1106)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.DoUpdate(TDbSchemaUpdateHelper.java:689)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate(TDbSchemaGroupCfg.java:800)
at com.interwoven.dd100.dd.TDbSchemaCfg.RealUpdateWithGroupTree(TDbSchemaCfg.java:942)
at com.interwoven.dd100.dd.TDbSchemaCfg.RealUpdate(TDbSchemaCfg.java:922)
at com.interwoven.dd100.dd.TDbSchemaSynchronizer.DoMod(TDbSchemaSynchronizer.java:601)
at com.interwoven.dd100.dd.TDbSchemaSynchronizer.WriteTupleInternal(TDbSchemaSynchronizer.java:238)
at com.interwoven.dd100.dd.TDbSchemaSynchronizer.WriteTuple(TDbSchemaSynchronizer.java:178)
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:961)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:569)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:529)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:474)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:256)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:188)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:487)
at com.interwoven.dd100.dd.TWorkItem.DoIt(TWorkItem.java:149)
at com.interwoven.dd100.dd.TLonelyWorker.run(TLonelyWorker.java:32)
at java.lang.Thread.run(Thread.java:484)
ERROR
oRealUpdate() failed for group [ad_loc].
ERROR:TSynchronizer.DoMod failed at dbSchema.RealUpdate
ERROR:WriteTuple failure to consumer[0]
ERROR:Unable to process TeamSite source templatedata/common/ad/data/CN_PLZWORK_13288_NoProjectNameFound.xml Modified, obtained from filelist=C:\IWTemp\ddt17404.tmp
Filelist walk done
Filelist C:\IWTemp\ddt17404.tmp deleted
ERROR:deployment [submitlist] FAILED
Error occured in area outside TDbAgent consumer (explicit rollback initiated)
Stat for group [ad]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 1
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [ad_type]:
-----------------------------------
Rows inserted : 1
Rows updated : 0
Rows deleted : 3
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [ad_loc]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 3
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Rollback database [srvspdsql01:1521:ext]...
Deployment[submitlist]
-----------------------------------
DCRs inserted : 0
DCRs updated : 0
DCRs deleted : 0
DCRs failed : 0
DCRs rolled back : 0
DCRs skipped : 0
-----------------------------------
Started : Fri Oct 22 14:42:34 EDT 2004
Finished: Fri Oct 22 14:42:43 EDT 2004
### IWDataDeploy FAILED ###
In Por YlemJoin the most popular player-run UO shard
