Local pass-docker with deposit services/dspace failing

[rpoet-jh]

Environment

mac, chrome, local pass-docker

Date/time occurred

2024-09-17

Description

When running pass-docker locally with deposit services and dspace, the deposit into dspace is failing.

Note I tested this in PASS stage, and it is working fine there, this is only an issue running pass-docker locally.

Steps to Reproduce

Start pass-docker locally with deposit services and dspace (follow full instructions from pass-docker https://github.com/eclipse-pass/pass-docker/blob/main/README.md#run-with-deposit-services-and-dspace)
Log into PASS using staff1
Submit new submission all the way through (use grant R24)

Expected Results

JScholarship deposit on submissions details page gets a dspace handle.

Actual Results

JScholarship deposit on submissions details page fails and no dspace handle is created.

Evidence

Pulling errors from local dspace and dspacedb container:

dspace:

Caused by: java.lang.RuntimeException: Postcondition failed for 81: Transport of package to endpoint failed: {"timestamp":"2024-09-17T18:40:33.759+00:00","status":500,"error":"Internal Server Error","message":"javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute batch","path":"/server/swordv2/collection/123456789/20"}
2024-09-17 14:40:34     at org.eclipse.pass.deposit.service.DepositTask$DepositTaskCriFunc.lambda$depositPostcondition$3(DepositTask.java:480)
2024-09-17 14:40:34     at org.eclipse.pass.deposit.cri.CriticalPath.performCritical(CriticalPath.java:202)
2024-09-17 14:40:34     at org.eclipse.pass.deposit.cri.CriticalRepositoryInteraction.performCritical(CriticalRepositoryInteraction.java:146)
2024-09-17 14:40:34     at org.eclipse.pass.deposit.service.DepositTask.executeDeposit(DepositTask.java:98)
2024-09-17 14:40:34     ... 21 common frames omitted
2024-09-17 14:40:34 Caused by: org.eclipse.pass.deposit.transport.sword2.SwordErrorMessageWrapper: {"timestamp":"2024-09-17T18:40:33.759+00:00","status":500,"error":"Internal Server Error","message":"javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute batch","path":"/server/swordv2/collection/123456789/20"}
2024-09-17 14:40:34     at org.eclipse.pass.deposit.transport.sword2.Sword2ErrorResponse.<init>(Sword2ErrorResponse.java:46)
2024-09-17 14:40:34     at org.eclipse.pass.deposit.transport.sword2.Sword2TransportSession.send(Sword2TransportSession.java:171)
2024-09-17 14:40:34     at org.eclipse.pass.deposit.service.DepositTask$DepositTaskCriFunc.lambda$performDeposit$1(DepositTask.java:440)
2024-09-17 14:40:34     at org.eclipse.pass.deposit.cri.CriticalPath.performCritical(CriticalPath.java:178)
2024-09-17 14:40:34     ... 23 common frames omitted

dspacedb:

2024-09-17 14:34:51 2024-09-17 18:34:51.628 UTC [85] ERROR:  new row for relation "resourcepolicy" violates check constraint "resourcepolicy_eperson_and_epersongroup_not_nullobject_chk"
2024-09-17 14:34:51 2024-09-17 18:34:51.628 UTC [85] DETAIL:  Failing row contains (806, 0, null, 0, null, null, null, null, null, null, null, null).
2024-09-17 14:34:51 2024-09-17 18:34:51.628 UTC [85] STATEMENT:  insert into public.resourcepolicy (action_id, dspace_object, end_date, eperson_id, epersongroup_id, resource_type_id, rpdescription, rpname, rptype, start_date, policy_id) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11)

Estimated Severity

Major