im getting some weird errors using replicant order as a primary key in my database tables, deployments fail sometimes but not others! is this allowed or not? i read some posts that seem to say its ok while another said no. please advise! we are on Version: 5.6.0 14707 20021211
*******************************************************
SQLException occured in TDbSchemaGroupCfg
Exception Message: ORA-00001: unique constraint (METADATA.IWT_109E683056CA_KEY) violated
Vendor Error Code: 1
SQL state: 23000
*******************************************************
*******STACK TRACE*************
java.sql.SQLException: ORA-00001: unique constraint (METADATA.IWT_109E683056CA_KEY) violated
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1614)
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1225)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1338)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1694)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1619)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2137)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:404)
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_SueEmAds_20206_31301.xml Modified, obtained from filelist=C:\DOCUME~1\wsplocal\LOCALS~1\Temp\ddt41066.tmp
Filelist walk done
In Por YlemJoin the most popular player-run UO shard