Import problem

Richard A
Member since: 2007


Im doing exports from one EpiServer instance, but when I try to import it into another instance, I get the following exception. The episerver instance Im trying to import to, is pretty empty (yes, I have tried this in many ways), but still I get the same problem. It very much seems like it get stuck when it gets to an instance of specific pagetyp.

Does anyone have an idea what I can do to succeed with this import ?

Is it possible to do an  import in another way, or what ?

Very thankful for any advice

The exception message from the Log:

2008-12-11 12:30:37,631 ERROR [5] EPiServer.Core.Transfer.TransferLogger.Error - 10.5.3 Export/import error: Exception: Violation of PRIMARY KEY constraint 'PK_tblWorkProperty'. Cannot insert duplicate key in object 'dbo.tblWorkProperty'.[]
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_tblWorkProperty'. Cannot insert duplicate key in object 'dbo.tblWorkProperty'.
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 EPiServer.DataAccess.AbstractCommand.ExecuteNonQuery()
at EPiServer.DataAccess.PageSaveDB.CreatePageVersion(String currentUser)
at EPiServer.DataAccess.PageSaveDB.CreateAndSave(SaveAction action, String currentUser)
at EPiServer.DataAccess.PageSaveDB.Save(PageData page, SaveAction action, String currentUser)
at EPiServer.LocalPageProvider.Save(PageData page, SaveAction action)
at EPiServer.DataFactory.Save(PageData page, SaveAction action, AccessLevel access)
at EPiServer.Core.Transfer.PageTransfer.ImportPageLanguage(PageReference destinationLink, RawPage page, AccessLevel requiredDestinationAccess)
at EPiServer.Core.Transfer.PageTransfer.Import(ITransferPageData page, AccessLevel requiredDestinationAccess)
at EPiServer.Enterprise.DataImporter.ImportPages(XmlTextReader reader, ZipPackage package)
at EPiServer.Enterprise.DataImporter.ImportRaw(ZipPackage package)
at EPiServer.Enterprise.DataImporter.Import()

#26562 Dec 11, 2008 12:36
  • Johan Björnfot
    Member since: 2004

    There is a bug in R2 release that can occour if a imported page exist in more than two languages and it has language specific properties. The stacktrace for that error looks like the one you describe.

    That is fixed and will be available in CMS 5 R2 SP1 which should be available soon (hopefully january)

    #26609 Dec 12, 2008 13:46
  • Falted
    Member since: 2004
    #34674 Edited, Nov 11, 2009 16:35