2026-08-10T15:05:36.117Z INFO 380 --- [ Test worker] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [net.hostsharing.hsadminng.hs.office.debitor.HsOfficeDebitorRepositoryIntegrationTest$CreateDebitor]: CreateDebitor does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-08-10T15:05:36.130Z INFO 380 --- [ Test worker] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration net.hostsharing.hsadminng.HsadminNgApplication for test class net.hostsharing.hsadminng.hs.office.debitor.HsOfficeDebitorRepositoryIntegrationTest$CreateDebitor
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
globalAdmin_canCreateNewDebitor(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select count(*) from hs_office.debitor_rv hode1_0
Hibernate: select hopre1_0.uuid,hopre1_0.detailsuuid,hopre1_0.partnernumber,hopre1_0.partnerreluuid,hopre1_0.version from hs_office.partner hopre1_0 where hopre1_0.partnernumber=?
Hibernate: select hopde1_0.uuid,hopde1_0.birthname,hopde1_0.birthplace,hopde1_0.birthday,hopde1_0.dateofdeath,hopde1_0.registrationnumber,hopde1_0.registrationoffice,hopde1_0.version from hs_office.partner_details_rv hopde1_0 where hopde1_0.uuid=?
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
Hibernate: select horre1_0.uuid,horre1_0.anchoruuid,horre1_0.contactuuid,horre1_0.holderuuid,horre1_0.mark,horre1_0.type,horre1_0.version from hs_office.relation horre1_0 where horre1_0.uuid=?
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.uuid=?
Hibernate: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where hocre1_0.uuid=?
toCleanup(class net.hostsharing.hsadminng.hs.office.debitor.HsOfficeDebitorEntity, 0b055302-42fa-44c4-b957-50a370e5d4a0
Hibernate: insert into hs_office.relation (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
Hibernate: insert into hs_office.debitor_rv (billable,debitornumbersuffix,debitorreluuid,defaultprefix,refundbankaccountuuid,vatbusiness,vatcountrycode,vatid,vatreversecharge,version,uuid) values (?,?,?,?,?,?,?,?,?,?,?)
Hibernate: select hode1_0.uuid,hode1_0.billable,hode1_0.debitornumbersuffix,hode1_0.debitorreluuid,dr1_0.uuid,dr1_0.anchoruuid,dr1_0.contactuuid,dr1_0.holderuuid,dr1_0.mark,dr1_0.type,dr1_0.version,hode1_0.defaultprefix,(
SELECT DISTINCT partner.uuid
FROM hs_office.partner partner
JOIN hs_office.relation dRel
ON dRel.uuid = hode1_0.debitorRelUuid AND dRel.type = 'DEBITOR'
JOIN hs_office.relation pRel
ON pRel.uuid = partner.partnerRelUuid AND pRel.type = 'PARTNER'
WHERE pRel.holderUuid = dRel.anchorUuid
)
,hode1_0.refundbankaccountuuid,hode1_0.vatbusiness,hode1_0.vatcountrycode,hode1_0.vatid,hode1_0.vatreversecharge,hode1_0.version from hs_office.debitor_rv hode1_0 join hs_office.relation dr1_0 on dr1_0.uuid=hode1_0.debitorreluuid where hode1_0.uuid=?
Hibernate: select hopre1_0.uuid,hopre1_0.detailsuuid,d1_0.uuid,d1_0.birthname,d1_0.birthplace,d1_0.birthday,d1_0.dateofdeath,d1_0.registrationnumber,d1_0.registrationoffice,d1_0.version,hopre1_0.partnernumber,hopre1_0.partnerreluuid,pr1_0.uuid,pr1_0.anchoruuid,pr1_0.contactuuid,pr1_0.holderuuid,pr1_0.mark,pr1_0.type,pr1_0.version,hopre1_0.version from hs_office.partner hopre1_0 left join hs_office.partner_details_rv d1_0 on d1_0.uuid=hopre1_0.detailsuuid join hs_office.relation pr1_0 on pr1_0.uuid=hopre1_0.partnerreluuid where hopre1_0.uuid=?
Hibernate: select horre1_0.uuid,horre1_0.anchoruuid,horre1_0.contactuuid,horre1_0.holderuuid,horre1_0.mark,horre1_0.type,horre1_0.version from hs_office.relation horre1_0 where horre1_0.uuid=?
Hibernate: select hode1_0.uuid,hode1_0.billable,hode1_0.debitornumbersuffix,hode1_0.debitorreluuid,dr1_0.uuid,dr1_0.anchoruuid,dr1_0.contactuuid,dr1_0.holderuuid,dr1_0.mark,dr1_0.type,dr1_0.version,hode1_0.defaultprefix,(
SELECT DISTINCT partner.uuid
FROM hs_office.partner partner
JOIN hs_office.relation dRel
ON dRel.uuid = hode1_0.debitorRelUuid AND dRel.type = 'DEBITOR'
JOIN hs_office.relation pRel
ON pRel.uuid = partner.partnerRelUuid AND pRel.type = 'PARTNER'
WHERE pRel.holderUuid = dRel.anchorUuid
)
,hode1_0.refundbankaccountuuid,hode1_0.vatbusiness,hode1_0.vatcountrycode,hode1_0.vatid,hode1_0.vatreversecharge,hode1_0.version from hs_office.debitor_rv hode1_0 join hs_office.relation dr1_0 on dr1_0.uuid=hode1_0.debitorreluuid where hode1_0.uuid=?
Hibernate: select hode1_0.uuid,hode1_0.billable,hode1_0.debitornumbersuffix,hode1_0.debitorreluuid,hode1_0.defaultprefix,(
SELECT DISTINCT partner.uuid
FROM hs_office.partner partner
JOIN hs_office.relation dRel
ON dRel.uuid = hode1_0.debitorRelUuid AND dRel.type = 'DEBITOR'
JOIN hs_office.relation pRel
ON pRel.uuid = partner.partnerRelUuid AND pRel.type = 'PARTNER'
WHERE pRel.holderUuid = dRel.anchorUuid
)
,hode1_0.refundbankaccountuuid,hode1_0.vatbusiness,hode1_0.vatcountrycode,hode1_0.vatid,hode1_0.vatreversecharge,hode1_0.version from hs_office.debitor_rv hode1_0 where hode1_0.uuid=?
Hibernate: select count(*) from hs_office.debitor_rv hode1_0
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: DELETE FROM hs_office.debitor WHERE uuid=?
DELETING temporary HsOfficeDebitorEntity#0b055302-42fa-44c4-b957-50a370e5d4a0 deleted 0 rows
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
globalAdmin_canCreateNewDebitor(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
createsAndGrantsRoles(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rrre1_0.uuid,rrre1_0.objectidname,rrre1_0.objecttable,rrre1_0.objectuuid,rrre1_0.objectTable||'#'||rrre1_0.objectIdName||':'||rrre1_0.roleType,rrre1_0.roletype from rbac.role_ev rrre1_0
Hibernate: select rrge1_0.uuid,rrge1_0.ascendantidname,rrge1_0.ascendantuuid,rrge1_0.assumed,rrge1_0.descendantidname,rrge1_0.descendantuuid,rrge1_0.grantedbyroleidname,rrge1_0.grantedbyroleuuid from rbac.grant_ev rrge1_0
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
toCleanup(class net.hostsharing.hsadminng.hs.office.debitor.HsOfficeDebitorEntity, 267b609e-e400-4120-b167-3cb229ce0d18
Hibernate: insert into hs_office.relation (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
Hibernate: insert into hs_office.debitor_rv (billable,debitornumbersuffix,debitorreluuid,defaultprefix,refundbankaccountuuid,vatbusiness,vatcountrycode,vatid,vatreversecharge,version,uuid) values (?,?,?,?,?,?,?,?,?,?,?)
Hibernate: select rrre1_0.uuid,rrre1_0.objectidname,rrre1_0.objecttable,rrre1_0.objectuuid,rrre1_0.objectTable||'#'||rrre1_0.objectIdName||':'||rrre1_0.roleType,rrre1_0.roletype from rbac.role_ev rrre1_0
Hibernate: select rrge1_0.uuid,rrge1_0.ascendantidname,rrge1_0.ascendantuuid,rrge1_0.assumed,rrge1_0.descendantidname,rrge1_0.descendantuuid,rrge1_0.grantedbyroleidname,rrge1_0.grantedbyroleuuid from rbac.grant_ev rrge1_0
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: DELETE FROM hs_office.debitor WHERE uuid=?
DELETING temporary HsOfficeDebitorEntity#267b609e-e400-4120-b167-3cb229ce0d18 deleted 0 rows
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
createsAndGrantsRoles(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
[1] givenPrefix=: TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
toCleanup(class net.hostsharing.hsadminng.hs.office.debitor.HsOfficeDebitorEntity, a33f32b3-e3b9-4811-9641-a5cf7dd28387
Hibernate: insert into hs_office.relation (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
Hibernate: insert into hs_office.debitor_rv (billable,debitornumbersuffix,debitorreluuid,defaultprefix,refundbankaccountuuid,vatbusiness,vatcountrycode,vatid,vatreversecharge,version,uuid) values (?,?,?,?,?,?,?,?,?,?,?)
2026-08-10T15:05:40.490Z WARN 380 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 23514
2026-08-10T15:05:40.490Z ERROR 380 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: new row for relation "debitor" violates check constraint "check_default_prefix"
Detail: Failing row contains (a33f32b3-e3b9-4811-9641-a5cf7dd28387, 0, 21, cc0827bb-24e3-47bd-b25d-3bce0cbbf6bd, t, null, null, f, f, null, ).
Where: SQL statement "insert
into hs_office.debitor (uuid, version, debitornumbersuffix, debitorreluuid, billable, vatid, vatcountrycode, vatbusiness, vatreversecharge, refundbankaccountuuid, defaultprefix)
values (new.uuid, new.version, new.debitornumbersuffix, new.debitorreluuid, new.billable, new.vatid, new.vatcountrycode, new.vatbusiness, new.vatreversecharge, new.refundbankaccountuuid, new.defaultprefix)
returning *"
PL/pgSQL function hs_office.debitor_instead_of_insert_tf() line 5 at SQL statement
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: DELETE FROM hs_office.debitor WHERE uuid=?
DELETING temporary HsOfficeDebitorEntity#a33f32b3-e3b9-4811-9641-a5cf7dd28387 deleted 0 rows
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
[1] givenPrefix=: TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
[2] givenPrefix=a: TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
toCleanup(class net.hostsharing.hsadminng.hs.office.debitor.HsOfficeDebitorEntity, 641021a6-09e5-481f-bd09-0c23411b5f91
Hibernate: insert into hs_office.relation (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
Hibernate: insert into hs_office.debitor_rv (billable,debitornumbersuffix,debitorreluuid,defaultprefix,refundbankaccountuuid,vatbusiness,vatcountrycode,vatid,vatreversecharge,version,uuid) values (?,?,?,?,?,?,?,?,?,?,?)
2026-08-10T15:05:41.771Z WARN 380 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 23514
2026-08-10T15:05:41.771Z ERROR 380 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: new row for relation "debitor" violates check constraint "check_default_prefix"
Detail: Failing row contains (641021a6-09e5-481f-bd09-0c23411b5f91, 0, 21, 63c8e1fb-6fc3-4bf4-9094-bce7f37bafbd, t, null, null, f, f, null, a ).
Where: SQL statement "insert
into hs_office.debitor (uuid, version, debitornumbersuffix, debitorreluuid, billable, vatid, vatcountrycode, vatbusiness, vatreversecharge, refundbankaccountuuid, defaultprefix)
values (new.uuid, new.version, new.debitornumbersuffix, new.debitorreluuid, new.billable, new.vatid, new.vatcountrycode, new.vatbusiness, new.vatreversecharge, new.refundbankaccountuuid, new.defaultprefix)
returning *"
PL/pgSQL function hs_office.debitor_instead_of_insert_tf() line 5 at SQL statement
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: DELETE FROM hs_office.debitor WHERE uuid=?
DELETING temporary HsOfficeDebitorEntity#641021a6-09e5-481f-bd09-0c23411b5f91 deleted 0 rows
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
[2] givenPrefix=a: TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
[3] givenPrefix=ab: TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
toCleanup(class net.hostsharing.hsadminng.hs.office.debitor.HsOfficeDebitorEntity, 8602ef06-d8ba-4764-b8e1-f59da62a5b99
Hibernate: insert into hs_office.relation (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
Hibernate: insert into hs_office.debitor_rv (billable,debitornumbersuffix,debitorreluuid,defaultprefix,refundbankaccountuuid,vatbusiness,vatcountrycode,vatid,vatreversecharge,version,uuid) values (?,?,?,?,?,?,?,?,?,?,?)
2026-08-10T15:05:43.114Z WARN 380 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 23514
2026-08-10T15:05:43.114Z ERROR 380 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: new row for relation "debitor" violates check constraint "check_default_prefix"
Detail: Failing row contains (8602ef06-d8ba-4764-b8e1-f59da62a5b99, 0, 21, 7736d386-3bda-44e5-8fbc-191a84587582, t, null, null, f, f, null, ab ).
Where: SQL statement "insert
into hs_office.debitor (uuid, version, debitornumbersuffix, debitorreluuid, billable, vatid, vatcountrycode, vatbusiness, vatreversecharge, refundbankaccountuuid, defaultprefix)
values (new.uuid, new.version, new.debitornumbersuffix, new.debitorreluuid, new.billable, new.vatid, new.vatcountrycode, new.vatbusiness, new.vatreversecharge, new.refundbankaccountuuid, new.defaultprefix)
returning *"
PL/pgSQL function hs_office.debitor_instead_of_insert_tf() line 5 at SQL statement
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: DELETE FROM hs_office.debitor WHERE uuid=?
DELETING temporary HsOfficeDebitorEntity#8602ef06-d8ba-4764-b8e1-f59da62a5b99 deleted 0 rows
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
[3] givenPrefix=ab: TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
[4] givenPrefix=a12: TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
toCleanup(class net.hostsharing.hsadminng.hs.office.debitor.HsOfficeDebitorEntity, 836c2cf3-ae26-4083-8250-94cf7356ddcb
Hibernate: insert into hs_office.relation (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
Hibernate: insert into hs_office.debitor_rv (billable,debitornumbersuffix,debitorreluuid,defaultprefix,refundbankaccountuuid,vatbusiness,vatcountrycode,vatid,vatreversecharge,version,uuid) values (?,?,?,?,?,?,?,?,?,?,?)
2026-08-10T15:05:44.407Z WARN 380 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 23514
2026-08-10T15:05:44.407Z ERROR 380 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: new row for relation "debitor" violates check constraint "check_default_prefix"
Detail: Failing row contains (836c2cf3-ae26-4083-8250-94cf7356ddcb, 0, 21, fe3b3c6e-6156-4311-8662-2ec1ae0f40cb, t, null, null, f, f, null, a12).
Where: SQL statement "insert
into hs_office.debitor (uuid, version, debitornumbersuffix, debitorreluuid, billable, vatid, vatcountrycode, vatbusiness, vatreversecharge, refundbankaccountuuid, defaultprefix)
values (new.uuid, new.version, new.debitornumbersuffix, new.debitorreluuid, new.billable, new.vatid, new.vatcountrycode, new.vatbusiness, new.vatreversecharge, new.refundbankaccountuuid, new.defaultprefix)
returning *"
PL/pgSQL function hs_office.debitor_instead_of_insert_tf() line 5 at SQL statement
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: DELETE FROM hs_office.debitor WHERE uuid=?
DELETING temporary HsOfficeDebitorEntity#836c2cf3-ae26-4083-8250-94cf7356ddcb deleted 0 rows
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
[4] givenPrefix=a12: TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
[5] givenPrefix=123: TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
toCleanup(class net.hostsharing.hsadminng.hs.office.debitor.HsOfficeDebitorEntity, dc512937-3180-4fbd-922a-29b0e799411d
Hibernate: insert into hs_office.relation (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
Hibernate: insert into hs_office.debitor_rv (billable,debitornumbersuffix,debitorreluuid,defaultprefix,refundbankaccountuuid,vatbusiness,vatcountrycode,vatid,vatreversecharge,version,uuid) values (?,?,?,?,?,?,?,?,?,?,?)
2026-08-10T15:05:45.661Z WARN 380 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 23514
2026-08-10T15:05:45.661Z ERROR 380 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: new row for relation "debitor" violates check constraint "check_default_prefix"
Detail: Failing row contains (dc512937-3180-4fbd-922a-29b0e799411d, 0, 21, be5757de-35d7-409f-a01b-72f36c306778, t, null, null, f, f, null, 123).
Where: SQL statement "insert
into hs_office.debitor (uuid, version, debitornumbersuffix, debitorreluuid, billable, vatid, vatcountrycode, vatbusiness, vatreversecharge, refundbankaccountuuid, defaultprefix)
values (new.uuid, new.version, new.debitornumbersuffix, new.debitorreluuid, new.billable, new.vatid, new.vatcountrycode, new.vatbusiness, new.vatreversecharge, new.refundbankaccountuuid, new.defaultprefix)
returning *"
PL/pgSQL function hs_office.debitor_instead_of_insert_tf() line 5 at SQL statement
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: DELETE FROM hs_office.debitor WHERE uuid=?
DELETING temporary HsOfficeDebitorEntity#dc512937-3180-4fbd-922a-29b0e799411d deleted 0 rows
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
[5] givenPrefix=123: TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
[6] givenPrefix=12a: TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
toCleanup(class net.hostsharing.hsadminng.hs.office.debitor.HsOfficeDebitorEntity, 863f91c0-086a-418f-bc1a-ae6dd63cc323
Hibernate: insert into hs_office.relation (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
Hibernate: insert into hs_office.debitor_rv (billable,debitornumbersuffix,debitorreluuid,defaultprefix,refundbankaccountuuid,vatbusiness,vatcountrycode,vatid,vatreversecharge,version,uuid) values (?,?,?,?,?,?,?,?,?,?,?)
2026-08-10T15:05:47.010Z WARN 380 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 23514
2026-08-10T15:05:47.010Z ERROR 380 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: new row for relation "debitor" violates check constraint "check_default_prefix"
Detail: Failing row contains (863f91c0-086a-418f-bc1a-ae6dd63cc323, 0, 21, 4e3e7ee1-1c48-41b7-972e-c9cbe3556b52, t, null, null, f, f, null, 12a).
Where: SQL statement "insert
into hs_office.debitor (uuid, version, debitornumbersuffix, debitorreluuid, billable, vatid, vatcountrycode, vatbusiness, vatreversecharge, refundbankaccountuuid, defaultprefix)
values (new.uuid, new.version, new.debitornumbersuffix, new.debitorreluuid, new.billable, new.vatid, new.vatcountrycode, new.vatbusiness, new.vatreversecharge, new.refundbankaccountuuid, new.defaultprefix)
returning *"
PL/pgSQL function hs_office.debitor_instead_of_insert_tf() line 5 at SQL statement
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: DELETE FROM hs_office.debitor WHERE uuid=?
DELETING temporary HsOfficeDebitorEntity#863f91c0-086a-418f-bc1a-ae6dd63cc323 deleted 0 rows
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
[6] givenPrefix=12a: TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0