Infos:
- Used Zammad version: 2.4.0
- Used Zammad installation source: package
- Operating system: CentOS 7
- Browser + version: Not used
Expected behavior:
After Import::OTRS.start command, data migration exected to occur
Actual behavior:
Data migration starts according to log, but stops at some point:
…
thread#-: add Ticket::State.find_by(id: 46)
thread#-: add Ticket::State.find_by(id: 47)
thread#-: add Ticket::State.find_by(id: 48)
thread#-: add Ticket::State.find_by(id: 49)
thread#-: update Ticket::State.find_by(id: 5)
thread#-: add Ticket::State.find_by(id: 50)
thread#-: add Ticket::State.find_by(id: 51)
thread#-: add Ticket::State.find_by(id: 52)
thread#-: add Ticket::State.find_by(id: 53)
thread#-: add Ticket::State.find_by(id: 54)
thread#-: add Ticket::State.find_by(id: 55)
thread#-: add Ticket::State.find_by(id: 56)
thread#-: update Ticket::State.find_by(id: 6)
thread#-: update Ticket::State.find_by(id: 7)
thread#-: add Ticket::State.find_by(id: 8)
thread#-: add Ticket::State.find_by(id: 9)
ActiveRecord::ValueTooLong: PG::StringDataRightTruncation: ERROR: value too long for type character varying(2000)
: UPDATE “object_manager_attributes” SET “data_option” = $1, “screens” = $2, “updated_at” = $3 WHERE “object_manager_attributes”.“id” = $4
from app/models/object_manager/attribute.rb:313:in add' from app/models/concerns/can_seed.rb:15:inload’
from app/models/concerns/can_seed.rb:15:in block in seed' from lib/user_info.rb:16:inensure_current_user_id’
from app/models/concerns/can_seed.rb:14:in seed' from lib/import/otrs/state_factory.rb:133:inreseed_dependent_objects’
from lib/import/otrs/state_factory.rb:63:in update_ticket_attributes' from lib/import/otrs/state_factory.rb:30:inupdate_attribute_settings’
from lib/import/otrs/state_factory.rb:23:in import_loop' from lib/import/base_factory.rb:9:inimport_action’
from lib/import/transaction_factory.rb:10:in block in import' from lib/import/transaction_factory.rb:9:inimport’
from lib/import/otrs.rb:147:in import_action' from lib/import/otrs.rb:73:inimport’
from lib/import/otrs.rb:161:in updateable_objects' from lib/import/otrs.rb:43:instart’
from (irb):4
irb(main):005:0>
Steps to reproduce the behavior:
On Zammad freshly installed instance:
service zammad stop
zammad run rails c
Setting.set('import_otrs_endpoint', 'http://URL/otrs/public.pl?Action=ZammadMigrator')
Setting.set('import_otrs_endpoint_key', 'KEY')
Setting.set('import_mode', true)
Import::OTRS.start