OTRS Import Error: ForeignKeyViolation


  • Used Zammad version:
  • Used Zammad installation type: (source, package, docker-compose, …)
  • Operating system:
  • Browser + version:

Expected behavior:

Actual behavior:

The import from OTRS 5 fail with an error:

PG::ForeignKeyViolation: ERROR: insert or update on table “ticketpriorities” violates foreign key constraint “fkrails_7ba453ab6d” DETAIL: Key (createdbyid)=(3) is not present in table “users”. : INSERT INTO “ticketpriorities” (“id”, “name”, “updatedbyid”, “createdbyid”, “createdat”, “updated_at”) VALUES ($1, $2, $3, $4, $5, $6) RETURNING “id”

I guess there is a user missing in OTRS which is referenced in ticketpriorities.
There should be a fallback user_id for this case, or the FK must be deleted.

production.log shows still ongoing:

I, [2021-09-22T16:12:32.443373 #604-47348182630160] INFO – : Processing by ImportOtrsController#import_status as JSON
I, [2021-09-22T16:12:32.443475 #604-47348182630160] INFO – : Parameters: {"_"=>“1632319476260”}
I, [2021-09-22T16:12:32.445138 #604-47348182630160] INFO – : Completed 200 OK in 1ms (Views: 0.3ms | ActiveRecord: 0.0ms)

with changing Parameter, does it mean it still works ??

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