Hi,
Getting below error while deploying default.site using autonomy provided LiveSite/SiteMetadata.xml conf file.
Teamsite/OD Version : 7.3.1
Anyone any idea how to resovle the issue. Looks like Primary key constraint issue.
Plaese help..
DBD: DoesRowExist
ELECT COUNT(*) FROM iw_asset WHERE ast_id = ? AND ast_locale = ? AND ast_branch = ? AND ast_relative_path = ? AND ast_creation_date = ? AND ast_expiration_date is null AND ast_last_modified_date = ? AND ast_last_modified_user = ?
DBD: Column: ast_id, field: TeamSite/LiveSite/Id, Index: 1,Converting '1340630203251' to VARCHAR
DBD: Column: ast_locale, field: TeamSite/Metadata/Locale, Index: 2,Converting 'en_US' to VARCHAR
DBD: Column: ast_branch, field: TupleProcessor/BranchVpath, Index: 3,Converting '/default/main/us-russell-com' to VARCHAR
DBD: Column: ast_relative_path, field: TupleProcessor/AreaRelativePath, Index: 4,Converting 'sites/us/default.site' to VARCHAR
DBD: Column: ast_creation_date, field: TeamSite/Metadata/CreationDate, Index: 5,Converting '2012-06-27 11:27:22' to TIMESTAMP
DBD: Column: ast_last_modified_date, field: TupleProcessor/LastModifiedDate, Index: 6,Converting '2014-04-15 00:43:53' to TIMESTAMP
DBD: Column: ast_last_modified_user, literal: prod\axkuma, Index: 7,Converting 'prod\axkuma' to VARCHAR
DBD: INSERT INTO iw_asset(ast_id,ast_locale,ast_branch,ast_relative_path,ast_creation_date,ast_expiration_date,ast_last_modified_date,ast_last_modified_user) VALUES (?,?,?,?,?,?,?,?)
DBD: Column: ast_id, field: TeamSite/LiveSite/Id, Index: 1,Converting '1340630203251' to VARCHAR
DBD: Column: ast_locale, field: TeamSite/Metadata/Locale, Index: 2,Converting 'en_US' to VARCHAR
DBD: Column: ast_branch, field: TupleProcessor/BranchVpath, Index: 3,Converting '/default/main/us-russell-com' to VARCHAR
DBD: Column: ast_relative_path, field: TupleProcessor/AreaRelativePath, Index: 4,Converting 'sites/us/default.site' to VARCHAR
DBD: Column: ast_creation_date, field: TeamSite/Metadata/CreationDate, Index: 5,Converting '2012-06-27 11:27:22' to TIMESTAMP
DBD: Column: ast_expiration_date, field: TeamSite/Metadata/ExpirationDate, Index: 6,null
DBD: Column: ast_last_modified_date, field: TupleProcessor/LastModifiedDate, Index: 7,Converting '2014-04-15 00:43:53' to TIMESTAMP
DBD: Column: ast_last_modified_user, literal: prod\test, Index: 8,Converting 'prod\test' to VARCHAR
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: Violation of PRIMARY KEY constraint 'PK__iw_asset__21F1148100551192'. Cannot insert duplicate key in object 'dbo.iw_asset'. The duplicate key value is (1340630203251).
DBD: Vendor Error Code: 2627
DBD: SQL state: 23000
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__iw_asset__21F1148100551192'. Cannot insert duplicate key in object 'dbo.iw_asset'. The duplicate key value is (1340630203251).
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.InsertOneRow(TDbSchemaUpdateHelper.java:1188)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.DoUpdate(TDbSchemaUpdateHelper.java:773)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate(TDbSchemaGroupCfg.java:846)
at com.interwoven.dd100.dd.TDbSchemaCfg.RealUpdateWithGroupTree(TDbSchemaCfg.java:955)
at com.interwoven.dd100.dd.TDbSchemaCfg.RealUpdate(TDbSchemaCfg.java:935)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:441)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TTuplePreProcessor.WriteTuple(TTuplePreProcessor.java:40)
at com.interwoven.dd100.dd.TPredicateEvaluator.WriteTuple(TPredicateEvaluator.java:116)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:1083)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:637)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:594)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:539)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:290)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:181)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:601)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)
DBD: ERROR
oRealUpdate() failed for group [teamsite_asset].
DBD: -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source sites/us/default.site, obtained from filelist=E:\Interwoven\TeamSite\tmp\LiveSite\workflow\htwz84dh\SiteMetadata.htwz84dhhtwz84di.filelist
DBD: Filelist walk done
DBD: ERROR:deployment [SiteMetadata] FAILED
