nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

violation of primary key issue

maverick83

hi

we are facing this issue ,actually DD is successful for the first time when we deploy it but when i again run DD

without changing anything et all ,i get the below error:-

[php]
DBD: TUPLE={white_paper/0/Metadata/0/standard_metadata/0=, white_paper/0/White_paper_assoc/0/product_node_id/2/product=AP_WA21, white_paper/0/White_paper_assoc/0/industry=6, white_paper/0/retired_white_paper=y, white_paper/0/White_paper_assoc/0/product_node_id/1/product=AC-MSCFEE, white_paper/0/Metadata/0=, white_paper/0/pdf_link=, state=Original, white_paper/0/Metadata/0/standard_metadata/0/standard_metadata/0/description=, white_paper/0/teaser=, white_paper/0=, white_paper/0/White_paper_assoc/0/service_category=2, white_paper/0/Metadata/0/standard_metadata/0/standard_metadata/0/keywords=, white_paper/0/White_paper_assoc/0/service_family=9, path=templatedata/learning/white_paper/data/wp_checking, white_paper/0/White_paper_assoc/0/service_node_id=33, white_paper/0/comments=, white_paper/0/alt_name=, white_paper/0/White_paper_assoc/0/product_category=8, white_paper/0/Metadata/0/standard_metadata/0/standard_metadata/0=, white_paper/0/White_paper_assoc/0/product_node_id/0/product=aarf-01, white_paper/0/White_paper_assoc/0=, white_paper/0/Metadata/0/standard_metadata/0/standard_metadata/0/page_title=testing, white_paper/0/White_paper_assoc/0/product_node_id=aarf-01, AC-MSCFEE, AP_WA21, white_paper/0/thumb_nail_image=, white_paper/0/publish_date=, white_paper/0/White_paper_assoc/0/product_family=2, IWOV_PROC_FLAG=true, white_paper/0/White_paper_assoc/0/solution_name=2}
DBD: RowsExistForPath Smiley Frustrated

ELECT COUNT(*) FROM Document11_DD WHERE DCRPath = ?
DBD: INSERT:INSERT INTO Docprod11_US(DCRPath,CountryCode,ProductNodeId) VALUES (?,?,?)
DBD: Column: DCRPath, field: path, Index: 1,Converting 'templatedata/learning/white_paper/data/wp_checking' to VARCHAR
DBD: Column: CountryCode, literal: us, Index: 2,Converting 'us' to CHAR
DBD: Column: ProductNodeId, field: white_paper/0/White_paper_assoc/0/product_node_id/0/product, Index: 3,Converting 'aarf-01' to VARCHAR
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: [USEVTCLSQL2A\IN00]Violation of PRIMARY KEY constraint 'Docprod11_US_key'. Cannot insert duplicate key in object 'Docprod11_US'.
DBD: Vendor Error Code: 2627
DBD: SQL state: 23000
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: [USEVTCLSQL2A\IN00]Violation of PRIMARY KEY constraint 'Docprod11_US_key'. Cannot insert duplicate key in object 'Docprod11_US'.
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.b.new(Unknown Source)
at com.inet.tds.b.executeUpdate(Unknown Source)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1289)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.InsertForSingleReplicant(TDbSchemaGroupCfg.java:1528)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformReplicantInsert(TDbSchemaGroupCfg.java:1344)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1140)
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:477)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
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:1008)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:502)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:289)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:178)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

DBD: ERROR Smiley Very Happy

oInsert() failed for group [Docprod11_US].
DBD: -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source templatedata/learning/white_paper/data
DBD: ERROR:deployment [wp-to-db] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DBD: Stat for group [Document11-DD]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 1
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Stat for group [Docprod11_US]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 0
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Rollback database [192.168.225.150:1150?database=iwovdev1]...
DBD: Deployment[wp-to-db]
DBD: -----------------------------------
DBD: DCRs inserted : 0
DBD: DCRs updated : 0
DBD: DCRs deleted : 0
DBD: DCRs failed : 0
DBD: DCRs rolled back : 0
DBD: DCRs skipped : 0
DBD: -----------------------------------
DBD: Started : Mon Mar 30 13:40:15 CST 2009
DBD: Shutting down DDD PublisherThread
DBD: Finished: Mon Mar 30 13:40:16 CST 2009
DBD:
### IWDataDeploy FAILED ###

DBD:
### Sending result ###

ENG: 2009-03-30 13:40:16 CST GMT-06:00 Database deployment execution returned 1

ENG: 2009-03-30 13:40:16 CST GMT-06:00 <<< Completed database deployment Invocation>>>

ENG: 2009-03-30 13:40:16 CST GMT-06:00 Manifest path is E:/Interwoven/OpenDeployNG/log/db/iwovdev/src.iwovdev1-whitep-US.wp-to-db.USCEDWS04.to.database.log.mf

ENG: 2009-03-30 13:40:16 CST GMT-06:00 Got Manifest object com.interwoven.od.adapter.delivery.base.IWODManifest@1b77c94

ENG: 2009-03-30 13:40:16 CST GMT-06:00 fHasFailedItems is set to true

ENG: 2009-03-30 13:40:16 CST GMT-06:00 Published leg event depUuid=[977d10d0-1d62-11de-9dfc-8a037d01334e] legLabel=[database] nextUuid=[null] nextDep=[null]
ENG: 2009-03-30 13:40:16 CST GMT-06:00 Job ID=m360 Deployment leg=database Elapsed Time=984 ms <<<
ENG: 2009-03-30 13:40:16 CST GMT-06:00 End logfile [E:\Interwoven\OpenDeployNG\log\db/iwovdev\src.iwovdev1-whitep-US.wp-to-db.USCEDWS04.to.database.log]

[/php]

the DD config file is attached below ,

please guide if you have any idea regarding this issue

thanks in advance

regards,
mav

Find more posts tagged with

Comments

merry

Hi,
As I have replied to the another thread raised by you "deletion of corresponding record from DB after deletion of dcr", I would again suggest to try changing "source" of config file as [html] rather than [/html]
I have used it in my config files and it worked fine for me.
Hope this helps you.

Thanks.