HI ,
I am using data deploy to deploy data to preview server's database and then to a staging server's database. When i update my dcr and use data deploy to deploy data , i don't get any error msg on deploying to preview server's database but the staging server's throw a duplicate data entry error.
I checkded my database.xml for both the servers and they both are mirror copy of each other except the server name. The dd configurations are same for both the server.
I am also including the error messege from the log.
F.Y.I:This duplicate field is the primary key for the table too.
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: Duplicate entry '/default/main/Enhanced/BKKRECI/WORKAREA/content/templatedata/Enh' for key 1
DBD: Vendor Error Code: 1062
DBD: SQL state: 23000
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: Duplicate entry 'abcde' for key 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1120)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:675)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1162)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1079)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1064)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1284)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsert(TDbSchemaGroupCfg.java:1160)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1072)
at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree(TDbSchemaCfg.java:456)
at com.interwoven.dd100.dd.TDbSchemaCfg.Insert(TDbSchemaCfg.java:409)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:475)
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:542)
at com.interwoven.dd100.dd.IWDataDeploy.run(IWDataDeploy.java:568)
at java.lang.Thread.run(Thread.java:534)
DBD: ERROR
oInsert() failed for group [ts_metadata].
DBD: -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
