EXCEPTION: Violation of UNIQUE KEY constraint 'IX_cs_Sections_Validation'. Cannot insert duplicate key in object 'dbo.cs_Sections'.
Table cs_Sections lists all our current Forum and Blog sections. Column SectionID (Int. Index/Key) 51 unique rows 1 through 70 with a few gaps. Only one Section IsActive=0, the remainder all active.
Is the CS upgrade attempting to insert a new SectionID row which already exists?
Any ideas folks?
NIick
"If I have seen further it is by standing on the shoulders of Giants" Sir Isaac Newton 1676
Bump.
Anyone?
cs_Sections contains a list of Forums, Blogs, Groups and a bunch of related Post/Poster/Recent data.
The upgrade script is failing with the following error:
Anyone else having the same issue?
Hi Nick, im experiencing the same issue while upgrading from CS2008.sp1 to 2008.5:
10/29/2008 12:09:04 PM -- EXCEPTION: Violation of UNIQUE KEY constraint 'IX_cs_Sections_Validation'. Cannot insert duplicate key in object 'dbo.cs_Sections'.The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at CommunityServer.Upgrader.FileUpgrader.MergeGalleries() at CommunityServer.Upgrader.Part4.MoveFilesToCfs()
Have you found a solution?
Lunarmedia.com
New website coming: A marketplace for Linguistic jobs (Translations/Proofreading/Transcriptions).
Anders. I dealt with this problem of Nicks' through the ticketign system and the problem was that he had a file gallery and a media gallery with the same application key. When CS tried to migrate these to media galeries, CS tried to insert duplicate application keys for the same application type into cs_sections which SQL didn't like.
if you're upgrading from CS2008 SP1 to CS2008.5, there still shouldn't be any file galleries or photo galleries to migrate. Have a look through cs_sections and see if you have any udplicate applicationkeys that may be causing problems. If you're still having troubles, export the cs_sections table and send it to me in a conversation and I'll have a look at it for you.
Community Server Documentation
Nintendo Wiikly
Thanks Alex, there were 4 duplicate appkeys, now renamed and its working, cheers!
duplicate appkeys shouldn't in themselves be a problem - it's duplicate appkeys in the same application type.
N.B. changing the appkeys may change hte url depending on what application type they were for so you may need to set up some rewriting rules to work around the url change.
Copyright© 2008 Telligent Systems Inc. All rights reserved CommunityServer.com • Telligent.com