[Urgent]Error while deploying default.site

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 Smiley Frustrated

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_la st_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.ma keFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.ge tNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStat ement.doExecutePreparedStatement(SQLServerPrepared Statement.java:390)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStat ement$PrepStmtExecCmd.doExecute(SQLServerPreparedS tatement.java:340)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IO Buffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.e xecuteCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.ex ecuteCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.ex ecuteStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStat ement.executeUpdate(SQLServerPreparedStatement.jav a:308)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.Inse rtOneRow(TDbSchemaUpdateHelper.java:1188)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.DoUp date(TDbSchemaUpdateHelper.java:773)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUp date(TDbSchemaGroupCfg.java:846)
at com.interwoven.dd100.dd.TDbSchemaCfg.RealUpdateWit hGroupTree(TDbSchemaCfg.java:955)
at com.interwoven.dd100.dd.TDbSchemaCfg.RealUpdate(TD bSchemaCfg.java:935)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteT uple(TDbSchemaAgent.java:441)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple( TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TTuplePreProcessor.WriteTu ple(TTuplePreProcessor.java:40)
at com.interwoven.dd100.dd.TPredicateEvaluator.WriteT uple(TPredicateEvaluator.java:116)
at com.interwoven.dd100.dd.TConsumerManager.WriteCons umerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteCons umers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSite Source(TAgentClient.java:1083)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFil eList(TAgentClient.java:637)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileLi st(TAgentClient.java:594)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSou rces(TAgentClient.java:539)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployme nt(TAgentClient.java:290)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClie nt.java:181)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDepl oy.java:601)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDA SThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread. java:128)

DBD: ERRORoRealUpdate() 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\workf low\htwz84dh\SiteMetadata.htwz84dhhtwz84di.filelis t
DBD: Filelist walk done
DBD: ERROR:deployment [SiteMetadata] FAILED

Find more posts tagged with

Comments

Rick Poulin

This is saying that you're trying to insert a duplicate record into that table. Since I'm assuming you haven't messed with the OOTB mapping, you probably did mess with the IWDELTRACKER table to clear the mapping between the file and the table row, or you did something fun with the IDs..

Note that if you don't actually use the LSDS DB, you can just turn all of this off (which is true in most cases now when LSCS is part of your solution)

nipper

To follow up on Rick's post:

Turning off DB in content.properties is likely the best approach

You can use SQL to remove the offending key and push it out again. I have done that before, however you may be messing with your prod server which can cost someone their job.

Finally, you can call support. That will take the longest and you will end up doing one of the other two anyways

arunkumar4

Thanks Rick and Nipper for responding.

Well seems like its OFF only, below the values of content.properties

#
# content.properties.template
#
# LiveSite Content Services connection information for SitePublisher.
#
# NOTE: This file uses UTF-8 character encoding. If manually modified, make sure to save in UTF-8 format.
#

# Whether to connect to LSCS
lscs.enabled=false

# IP address or host name where LSCS is installed.
lscs.host=localhost
# Port which LSCS listens for requests
lscs.port=8080
# Context path where LSCS listens for requests
lscs.context.path=lscs
# Protocol Version
lscs.version=v1

# Local path to the LSCS home (if available)
lscs.home=E:/Interwoven/LiveSiteCSAuth

#
# HTTP Properties
#
# The following are defaults which can be overridden.
# Please consult Autonomy Interwoven support for information.
#
#http.user.agent=LSCS Java Library
#http.connection.timeout=50000
#http.socket.timeout=50000
#http.max.connections.host=8
#http.max.connections.total=20

#
# LSCS Rules Engine Properties
#

# Whether to enable rule execution and rule management features
lscs.rules.enabled=false

NOTE: this is happening on Devlopment env where We have moved all content from PROD to Dev teamsite workarea and trying to deploy files from Dev teamsite

while deploying default.site, i am getting that error. other files are getting deployed correctly , only issue is with default.site

if only you looked in the correct file. Look at the files in the same folder and think about which one might be used to configure the database