Infos:
- Used Zammad version: 5.3.0-1669364938.83ce4433.focal
- Installation method (source, package, …): Package
- Operating system: Ubuntu Server 20.4
- Database + version: postgresql-12
- Elasticsearch version:elasticsearch/stable,now 7.17.7
- Browser + version: Google Chrome 107.0.5304.107
OTRS 6 Version
6.0.3
Znuny4OTRS-Repo
6.0.76
Znuny4OTRS-ZammadMigrator
6.0.7
Expected behavior:
Importing OTRS 6 DATA into fresh Zammad Instance finishes withour error messages
Actual behavior:
Migration stops when it reaches priority that was created by end user with error code
/opt/zammad/vendor/bundle/ruby/3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/postgresql_adapter.rb:672:in
exec_params': PG::ForeignKeyViolation: ERROR: insert or update on table "ticket_priorities" violates foreign key constraint "fk_rails_7ba453ab6d" (ActiveRecord::InvalidForeignKey) DETAIL: Key (created_by_id)=(43) is not present in table "users". /opt/zammad/vendor/bundle/ruby/3.0.0/gems/activerecord-6.1.7/lib/active_record/connection_adapters/postgresql_adapter.rb:672:in
exec_params’: ERROR: insert or update on table “ticket_priorities” violates foreign key constraint “fk_rails_7ba453ab6d” (PG::ForeignKeyViolation)
DETAIL: Key (created_by_id)=(43) is not present in table “users”.
Steps to reproduce the behavior:
Create priority in OTRS 6 with user that is not root@localhost.
Start Migration in fresh Zammad instance