November Happy Hour will be moved to Thursday December 5th.

Migrating database from version 4.4 to 5.0

Vote:
 

The migration completes with errors.

transaction log:

BEGIN TRANSACTION TransactionMigration
@bitMigrateCommunity: 0
@bitMigrateMail: 1
@bitEPiServerCommonSourceExists: 1
@bitEPiServerCommonTargetExists: 1
@bitCommunitySourceExists: 0
@bitCommunityTargetExists: 0
@bitEPiMailSourceExists: 1
@bitEPiMailTargetExists: 1
@bitEPiServerCommonTablesEmpty: 1
@bitEPiServerCommunityTablesEmpty: 1
@bitEPiMailTablesEmpty: 1
Data migration started
Truncate tables
Copy globalization keys
Copy Common Framework data to destination
Retrieving Object type IDs...

Object type IDs
--------------------
Calendar = 3
CalendarEvent = 4
ForumReply = 6
ForumTopic = 7
ForumRoom = 5
Video = 8
VideoGallery = 9
VideoComment = 10
Image = 11
ImageComment = 13
ImageGallery = 12
Blog = 14
BlogEntry = 15
EntryComment = 16
User = 1
Club = 17
UserAuthor = 18
AnonymousAuthor = 19
GuestAuthor = 20
ReportCase = 21
ContactContainer = 22
DocumentArchive = 23
Forum = 24
Poll = 25
Campaign = 26
NewsFeed = 27
MyPage = 28
--------------------

Copy EPiServerMail data
Msg 512, Level 16, State 1, Line 1
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
Msg 512, Level 16, State 1, Line 1
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_tblEPiServerCommonCategory_tblEPiServerCommonCategory_Parent". The conflict occurred in database "EPiServerMailDBDev", table "dbo.tblEPiServerCommonCategory", column 'intID'.
The statement has been terminated.
COMMIT TRANSACTION TransactionMigration
 
When investigating and comparing tables between the databases the target got corrupted tables.
 
Migration setup:
-- Set global variables
SET @strSourceDB = '[EpiServerMailDBTestData]'
SET @strTargetDB = '[EPiServerMailDBDev]'
SET @bitMigrateCommunity = 0
SET @bitMigrateMail = 1
SET @bitDebug = 1
SET @bitRestoreRelatePlusData = 0
 

 Any idea why or did i miss something ?

#55615
Dec 09, 2011 9:32
Vote:
 

Ofcourse i realize that it returns several results instead of 1 but i dont get that foreign key error. And where can i change the select phrase in order to correct these errors?

#55618
Dec 09, 2011 10:07
This thread is locked and should be used for reference only. Please use the Legacy add-ons forum to open new discussions.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.