Hello, 

I am running a migration process of an OTRS 5.0.30 to OTRS 6.0.12 on CentOS 7 with MariaDB and during DB-Migrate-to-6 execution I get the following error. The first time I ran, it told me there were some orphaned articles and some orphaned tags and asked to delete them. 

I tried reloading the original Database and those orphaned messages disappeared but It keeps giving the error. 


 Step 29 of 42: Post changes on article related tables ...
[Fri Nov  2 21:07:29 2018] DBUpdate-to-6.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`otrs`.`#sql-955_4c109`, CONSTRAINT `FK_article_data_mime_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`)) at /opt/otrs/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-1 Perl: 5.16.3 OS: linux Time: Fri Nov  2 21:07:29 2018

 Message: Cannot add or update a child row: a foreign key constraint fails (`otrs`.`#sql-955_4c109`, CONSTRAINT `FK_article_data_mime_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`)), SQL: 'EXECUTE FKStatement'

 Traceback (123074): 
   Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 394
   Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 342
   Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::_UpdateArticleDataMimeTable Line: 286
   Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::Run Line: 52
   Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
   Module: scripts::DBUpdateTo6::Run Line: 69
   Module: scripts/DBUpdate-to-6.pl Line: 87


ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-1 Perl: 5.16.3 OS: linux Time: Fri Nov  2 21:07:29 2018

 Message: Error during execution of 'EXECUTE FKStatement'!

 Traceback (123074): 
   Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 397
   Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 342
   Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::_UpdateArticleDataMimeTable Line: 286
   Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::Run Line: 52
   Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
   Module: scripts::DBUpdateTo6::Run Line: 69
   Module: scripts/DBUpdate-to-6.pl Line: 87




 Not possible to complete migration, check previous messages for more information. 



--
Alvaro Cordero Retana
Consultor de Tecnologias
Tel: 22585757 ext 123