Infos:
- 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 ??