Infos:
Important:
If you are a Zammad Support or hosted customer and experience a technical issue, please refer to: support@zammad.com using your zammad-hostname / or company contract.
Used Zammad version: 2.5.x
Used Zammad installation source: ubuntu-package
Operating system: ubuntu 16.04
Browser + version: safari desktop latest
Expected behavior:
when importing from Zendesk all tickets should be imported
Actual behavior:
import stops with the following error message:
Problem with ObjectManager Attribute 'XY?': Only letters from a-z, numbers from 0-9, and _ are allowed
the attribute is a checkbox
disabling the attribute doesn’t help.
Steps to reproduce the behavior:
create a additional ticket field with attribute “checkbox” and try to import the tickets.
OK, I’m now at the point where I can say that it is the attribute name wich has an question mark but I can’t change it in Zendesk. Could someone give me a hint where I could remove the question mark for only this attribute?
I would do a little dirty hack -> something like
if $name == 'attributename?'
$name = 'attributename'
end
edit1:
ok, got it working by changing the attribute-name in Zendesk. head -> table.
now I got another error after importing 170 of 2569 tickets:
SSL_connect SYSCALL returned=5 errno=0 state=unknown state
any idea? I think It might be my browser. Is there a way to start the import from command-line? I only found informations for OTRS.
edit2:
OK. got it working. The importer seems to have a problem with Safari. With Chrome it works. But now I have another problem:
My Tickets don’t get imported in full length. Here ist the Error Message from Log:
WARNING: cut string because of database length Ticket.note(250 but is 3249:
Thanks for keeping us updated.
You filled in a issue on github regarding the import problem:
opened 12:11PM - 09 Aug 18 UTC
closed 10:27AM - 11 Feb 19 UTC
bug
import
verified
<!--
Hi there - thanks for filing an issue. Please ensure the following things … before creating an issue - thank you! 🤓
Since november 15th we handle all requests, except real bugs, at our community board.
Full explanation: https://community.zammad.org/t/major-change-regarding-github-issues-community-board/21
Please post:
- Feature requests
- Development questions
- Technical questions
on the board -> https://community.zammad.org !
If you think you hit a bug, please continue:
- Search existing issues and the CHANGELOG.md for your issue - there might be a solution already
- Make sure to use the latest version of Zammad if possible
- Add the `log/production.log` file from your system. Attention: Make sure no confidential data is in it!
- Please write the issue in english
- Don't remove the template - otherwise we will close the issue without further comments
- Ask questions about Zammad configuration and usage at our mailinglist. See: https://zammad.org/participate
Note: We always do our best. Unfortunately, sometimes there are too many requests and we can't handle everything at once. If you want to prioritize/escalate your issue, you can do so by means of a support contract (see https://zammad.com/pricing#selfhosted).
* The upper textblock will be removed automatically when you submit your issue *
-->
### Infos:
* Used Zammad version: 2.5
* Installation method (source, package, ..): DEB
* Operating system: Ubuntu 16.04
* Database + version: 9.5
* Elasticsearch version: 5.6.10
* Browser + version: chrome 67.0.3396.99
### Expected behavior:
* import all data without error
### Actual behavior:
* zammad imports only the first 250 characters with error:
`WARNING: cut string because of database length Ticket.note(250 but is 2780:`
* after 523 tickets the import stops with the following error message:
```
E, [2018-08-09T13:09:52.192645 #11035] ERROR -- : #<Net::OpenTimeout: execution expired>
I, [2018-08-09T13:09:52.193324 #11035] INFO -- : Sequence 'Sequencer::Sequence::Import::Zendesk::Ticket::Comment::Attachment' Unit 'Sequencer::Unit::Import::Zendesk::Ticket::Comment::Attachment::Request' (index: 0) finished.
I, [2018-08-09T13:09:52.193738 #11035] INFO -- : State cleanup of Unit Sequencer::Unit::Import::Zendesk::Ticket::Comment::Attachment::Request (index: 0) started.
I, [2018-08-09T13:09:52.194007 #11035] INFO -- : State cleanup of Unit Sequencer::Unit::Import::Zendesk::Ticket::Comment::Attachment::Request (index: 0) finished.
I, [2018-08-09T13:09:52.194321 #11035] INFO -- : Sequence 'Sequencer::Sequence::Import::Zendesk::Ticket::Comment::Attachment' Unit 'Sequencer::Unit::Import::Zendesk::Ticket::Comment::Attachment::Add' (index: 1) started.
E, [2018-08-09T13:09:52.195032 #11035] ERROR -- : undefined method 'body' for nil:NilClass (NoMethodError)
/opt/zammad/lib/sequencer/unit/import/zendesk/ticket/comment/attachment/add.rb:20:in 'process'
/opt/zammad/lib/sequencer/unit/import/common/model/mixin/skip/action.rb:45:in 'process'
/opt/zammad/lib/sequencer/unit/base.rb:200:in 'process'
/opt/zammad/lib/sequencer.rb:65:in 'block (4 levels) in process'
/opt/zammad/lib/mixin/start_finish_logger.rb:7:in 'log_start_finish'
/opt/zammad/lib/sequencer.rb:64:in 'block (3 levels) in process'
/opt/zammad/lib/sequencer/state.rb:149:in 'process'
/opt/zammad/lib/sequencer.rb:62:in 'block (2 levels) in process'
/opt/zammad/lib/sequencer/units.rb:29:in 'block in each'
/opt/zammad/lib/sequencer/units.rb:28:in 'each'
/opt/zammad/lib/sequencer/units.rb:28:in 'each'
/opt/zammad/lib/sequencer.rb:60:in 'each_with_index'
/opt/zammad/lib/sequencer.rb:60:in 'block in process'
/opt/zammad/lib/mixin/start_finish_logger.rb:7:in 'log_start_finish'
/opt/zammad/lib/sequencer.rb:58:in 'process'
/opt/zammad/lib/sequencer.rb:25:in 'process'
/opt/zammad/lib/sequencer/unit/import/zendesk/sub_sequence/sub_object.rb:14:in 'block in process'
/opt/zammad/lib/sequencer/unit/import/zendesk/sub_sequence/base.rb:41:in 'each'
/opt/zammad/lib/sequencer/unit/import/zendesk/sub_sequence/base.rb:41:in 'public_send'
/opt/zammad/lib/sequencer/unit/import/zendesk/sub_sequence/base.rb:41:in 'resource_iteration'
/opt/zammad/lib/sequencer/unit/import/zendesk/sub_sequence/sub_object.rb:12:in 'process'
/opt/zammad/lib/sequencer/unit/import/zendesk/ticket/comment/attachments.rb:13:in 'process'
/opt/zammad/lib/sequencer/unit/base.rb:200:in 'process'
/opt/zammad/lib/sequencer.rb:65:in 'block (4 levels) in process'
/opt/zammad/lib/mixin/start_finish_logger.rb:7:in 'log_start_finish'
/opt/zammad/lib/sequencer.rb:64:in 'block (3 levels) in process'
/opt/zammad/lib/sequencer/state.rb:149:in 'process'
/opt/zammad/lib/sequencer.rb:62:in 'block (2 levels) in process'
/opt/zammad/lib/sequencer/units.rb:29:in 'block in each'
/opt/zammad/lib/sequencer/units.rb:28:in 'each'
/opt/zammad/lib/sequencer/units.rb:28:in 'each'
/opt/zammad/lib/sequencer.rb:60:in 'each_with_index'
/opt/zammad/lib/sequencer.rb:60:in 'block in process'
/opt/zammad/lib/mixin/start_finish_logger.rb:7:in 'log_start_finish'
/opt/zammad/lib/sequencer.rb:58:in 'process'
/opt/zammad/lib/sequencer.rb:25:in 'process'
/opt/zammad/lib/sequencer/unit/import/zendesk/sub_sequence/sub_object.rb:14:in 'block in process'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/zendesk_api-1.16.0/lib/zendesk_api/collection.rb:349:in 'block in _all'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/zendesk_api-1.16.0/lib/zendesk_api/collection.rb:457:in 'each'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/zendesk_api-1.16.0/lib/zendesk_api/collection.rb:457:in 'public_send'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/zendesk_api-1.16.0/lib/zendesk_api/collection.rb:457:in 'array_method'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/zendesk_api-1.16.0/lib/zendesk_api/collection.rb:298:in 'method_missing'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/zendesk_api-1.16.0/lib/zendesk_api/collection.rb:342:in '_all'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/zendesk_api-1.16.0/lib/zendesk_api/collection.rb:216:in 'all!'
/opt/zammad/lib/sequencer/unit/import/zendesk/sub_sequence/base.rb:41:in 'public_send'
/opt/zammad/lib/sequencer/unit/import/zendesk/sub_sequence/base.rb:41:in 'resource_iteration'
/opt/zammad/lib/sequencer/unit/import/zendesk/tickets.rb:21:in 'resource_iteration'
/opt/zammad/lib/sequencer/unit/import/zendesk/sub_sequence/mapped.rb:45:in 'process_sub_sequence'
/opt/zammad/lib/sequencer/unit/import/zendesk/sub_sequence/mapped.rb:29:in 'block in process'
/opt/zammad/lib/sequencer/state.rb:45:in 'provide'
/opt/zammad/lib/sequencer/unit/import/zendesk/sub_sequence/mapped.rb:28:in 'process'
/opt/zammad/lib/sequencer/unit/base.rb:200:in 'process'
/opt/zammad/lib/sequencer.rb:65:in 'block (4 levels) in process'
/opt/zammad/lib/mixin/start_finish_logger.rb:7:in 'log_start_finish'
/opt/zammad/lib/sequencer.rb:64:in 'block (3 levels) in process'
/opt/zammad/lib/sequencer/state.rb:149:in 'process'
/opt/zammad/lib/sequencer.rb:62:in 'block (2 levels) in process'
/opt/zammad/lib/sequencer/units.rb:29:in 'block in each'
/opt/zammad/lib/sequencer/units.rb:28:in 'each'
/opt/zammad/lib/sequencer/units.rb:28:in 'each'
/opt/zammad/lib/sequencer.rb:60:in 'each_with_index'
/opt/zammad/lib/sequencer.rb:60:in 'block in process'
/opt/zammad/lib/mixin/start_finish_logger.rb:7:in 'log_start_finish'
/opt/zammad/lib/sequencer.rb:58:in 'process'
/opt/zammad/lib/sequencer.rb:25:in 'process'
/opt/zammad/lib/import/mixin/sequence.rb:15:in 'process'
/opt/zammad/lib/import/zendesk.rb:8:in 'start'
/opt/zammad/app/models/import_job.rb:24:in 'start'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/performable_method.rb:26:in 'perform'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/backend/base.rb:81:in 'block in invoke_job'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/lifecycle.rb:61:in 'block in initialize'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/lifecycle.rb:66:in 'execute'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/lifecycle.rb:40:in 'run_callbacks'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/backend/base.rb:78:in 'invoke_job'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/worker.rb:230:in 'block (2 levels) in run'
/opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/timeout.rb:93:in 'block in timeout'
/opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/timeout.rb:103:in 'timeout'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/worker.rb:230:in 'block in run'
/opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/benchmark.rb:308:in 'realtime'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/worker.rb:229:in 'run'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/worker.rb:312:in 'block in reserve_and_run_one_job'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/lifecycle.rb:61:in 'block in initialize'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/lifecycle.rb:66:in 'execute'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/lifecycle.rb:40:in 'run_callbacks'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/worker.rb:312:in 'reserve_and_run_one_job'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/worker.rb:213:in 'block in work_off'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/worker.rb:212:in 'times'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/delayed_job-4.1.3/lib/delayed/worker.rb:212:in 'work_off'
/opt/zammad/app/models/scheduler.rb:355:in 'block (3 levels) in worker'
/opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/benchmark.rb:308:in 'realtime'
/opt/zammad/app/models/scheduler.rb:353:in 'block (2 levels) in worker'
/opt/zammad/app/models/scheduler.rb:349:in 'loop'
/opt/zammad/app/models/scheduler.rb:349:in 'block in worker'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/logging-2.2.2/lib/logging/diagnostic_context.rb:474:in 'block in create_with_logging_context'
```
### Steps to reproduce the behavior:
* setup a Zendesk-instanz and try to import data from it to zammad.
Yes I'm sure this is a bug and no feature request or a general question.
This still has to be verified.
Hi,
sorry for my late post. Had a lot of work these days…
If you need more information for this, just tell.
system
Closed
December 13, 2018, 4:56am
5
This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.