Migration from OTRS 7

Lobby
1

Hi,

I want to migrate from OTRS 7 to Zammad, unfortunately Migrator plugin is only for OTRS 6, it can not be installed on OTRS 7. Is there any way I can migrate my database from OTRS 7 to Zammad ?

Thanks

2

OTRS 7 is closed source and we do not provide a migration path as of now.
However, if this is crucial for you you can always contact our sales team for a custom migration.

sales [at] zammad [dot] com

3

i migrated my database to znuny (otrs 6). now i can use the plugin. But this is aborted with the following error. Users are imported, but when tickets import starts, comes the following error and after that is canceled. can you tell me how I can correct that ?

hread#7: PARAMS: {:Subaction=>"Export", :Object=>"Ticket", :Limit=>20, :Offset=>120, :Diff=>0, :Action=>"ZammadMigrator", :Key=>"c1M79N7bqSs4lcFShBp8qAbclaSkBG59otpIZkG6"}
thread#1: update Ticket.find_by(id: 1)
thread#1: update Ticket::Article.find_by(id: 1)
thread#1: add Ticket.find_by(id: 2)
#<Thread:0x0000559e91fae580@/opt/zammad/vendor/bundle/ruby/2.6.0/gems/logging-2.2.2/lib/logging/diagnostic_context.rb:471 run> terminated with exception (report_on_exception is true):
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql_adapter.rb:611:in `async_exec': PG::ForeignKeyViolation: ERROR:  insert or update on table "tickets" violates foreign key constraint "fk_rails_f39559d6d6" (ActiveRecord::InvalidForeignKey)
DETAIL:  Key (group_id)=(6) is not present in table "groups".
: INSERT INTO "tickets" ("id", "group_id", "priority_id", "state_id", "number", "title", "owner_id", "customer_id", "first_response_at", "close_at", "updated_by_id", "created_by_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) RETURNING "id"
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql_adapter.rb:611:in `block (2 levels) in exec_no_cache'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql_adapter.rb:610:in `block in exec_no_cache'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
	from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql_adapter.rb:609:in `exec_no_cache'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in `execute_and_clear'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:81:in `exec_query'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/database_statements.rb:130:in `exec_insert'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:115:in `exec_insert'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/composite_primary_keys-11.2.0/lib/composite_primary_keys/connection_adapters/abstract/database_statements.rb:6:in `insert'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/query_cache.rb:21:in `insert'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/persistence.rb:187:in `_insert_record'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/composite_primary_keys-11.2.0/lib/composite_primary_keys/persistence.rb:64:in `_create_record'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/counter_cache.rb:184:in `_create_record'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/locking/optimistic.rb:70:in `_create_record'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/attribute_methods/dirty.rb:140:in `_create_record'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/callbacks.rb:346:in `block in _create_record'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/callbacks.rb:132:in `run_callbacks'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/callbacks.rb:816:in `_run_create_callbacks'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/callbacks.rb:346:in `_create_record'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/timestamp.rb:102:in `_create_record'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/persistence.rb:705:in `create_or_update'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/callbacks.rb:342:in `block in create_or_update'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/callbacks.rb:132:in `run_callbacks'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/callbacks.rb:816:in `_run_save_callbacks'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/callbacks.rb:342:in `create_or_update'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/persistence.rb:275:in `save'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/validations.rb:46:in `save'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:310:in `block (2 levels) in save'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:387:in `block in with_transaction_returning_status'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `block in transaction'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction'
	from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `transaction'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:212:in `transaction'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:385:in `with_transaction_returning_status'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:310:in `block in save'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:325:in `rollback_active_record_state!'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:309:in `save'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/suppressor.rb:44:in `save'
	from /opt/zammad/lib/import/otrs/ticket.rb:63:in `create'
	from /opt/zammad/lib/import/otrs/ticket.rb:47:in `create_or_update'
	from /opt/zammad/lib/import/otrs/ticket.rb:38:in `import'
	from /opt/zammad/lib/import/otrs/ticket.rb:30:in `initialize'
	from /opt/zammad/lib/import/base_factory.rb:34:in `new'
	from /opt/zammad/lib/import/base_factory.rb:34:in `create_instance'
	from /opt/zammad/lib/import/base_factory.rb:10:in `block in import_action'
	from /opt/zammad/lib/import/base_factory.rb:38:in `each'
	from /opt/zammad/lib/import/base_factory.rb:38:in `import_loop'
	from /opt/zammad/lib/import/base_factory.rb:7:in `import_action'
	from /opt/zammad/lib/import/otrs.rb:155:in `import_action'
	from /opt/zammad/lib/import/otrs.rb:144:in `imported?'
	from /opt/zammad/lib/import/otrs.rb:108:in `block (3 levels) in threaded_import'
	from /opt/zammad/lib/import/otrs.rb:102:in `loop'
	from /opt/zammad/lib/import/otrs.rb:102:in `block (2 levels) in threaded_import'
	from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/logging-2.2.2/lib/logging/diagnostic_context.rb:474:in `block in create_with_logging_context'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql_adapter.rb:611:in `async_exec': ERROR:  insert or update on table "tickets" violates foreign key constraint "fk_rails_f39559d6d6" (PG::ForeignKeyViolation)
DETAIL:  Key (group_id)=(6) is not present in table "groups".
4

This topic was automatically closed 41 days after the last reply. New replies are no longer allowed.