CreateDebitor

8

tests

0

failures

0

ignored

11.133s

duration

100%

successful

Tests

Test Method name Duration Result
[1] givenPrefix= canNotCreateNewDebitorWithInvalidDefaultPrefix(String)[1] 1.245s passed
[2] givenPrefix=a canNotCreateNewDebitorWithInvalidDefaultPrefix(String)[2] 1.239s passed
[3] givenPrefix=ab canNotCreateNewDebitorWithInvalidDefaultPrefix(String)[3] 1.335s passed
[4] givenPrefix=a12 canNotCreateNewDebitorWithInvalidDefaultPrefix(String)[4] 1.365s passed
[5] givenPrefix=123 canNotCreateNewDebitorWithInvalidDefaultPrefix(String)[5] 1.245s passed
[6] givenPrefix=12a canNotCreateNewDebitorWithInvalidDefaultPrefix(String)[6] 1.246s passed
createsAndGrantsRoles() createsAndGrantsRoles() 2.134s passed
globalAdmin_canCreateNewDebitor() globalAdmin_canCreateNewDebitor() 1.324s passed

Standard output

2026-08-10T16:31:22.984Z  INFO 368 --- [    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-10T16:31:22.992Z  INFO 368 --- [    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, adb55876-af35-474e-a461-ead9196c0425
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#adb55876-af35-474e-a461-ead9196c0425 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, 12db32b1-9db9-4408-9bc9-f422aefab066
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#12db32b1-9db9-4408-9bc9-f422aefab066 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, ad687e3f-87a8-4cf2-8ac1-bed6feffed54
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-10T16:31:27.297Z  WARN 368 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23514
2026-08-10T16:31:27.298Z ERROR 368 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: new row for relation "debitor" violates check constraint "check_default_prefix"
  Detail: Failing row contains (ad687e3f-87a8-4cf2-8ac1-bed6feffed54, 0, 21, 2fe8ff80-96e8-4347-a1ab-7d43d99bd2fc, 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#ad687e3f-87a8-4cf2-8ac1-bed6feffed54 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, 33fb5f96-2f55-4bb7-8b01-7f68ddabcba5
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-10T16:31:28.548Z  WARN 368 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23514
2026-08-10T16:31:28.548Z ERROR 368 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: new row for relation "debitor" violates check constraint "check_default_prefix"
  Detail: Failing row contains (33fb5f96-2f55-4bb7-8b01-7f68ddabcba5, 0, 21, c4fbf143-9702-4012-acfa-f3075325836c, 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#33fb5f96-2f55-4bb7-8b01-7f68ddabcba5 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, fca7ab20-848f-484d-8d6f-f735915af16f
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-10T16:31:29.780Z  WARN 368 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23514
2026-08-10T16:31:29.781Z ERROR 368 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: new row for relation "debitor" violates check constraint "check_default_prefix"
  Detail: Failing row contains (fca7ab20-848f-484d-8d6f-f735915af16f, 0, 21, d20a0cec-9ef9-41f9-bc49-75230faf2cc2, 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#fca7ab20-848f-484d-8d6f-f735915af16f 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, 562cf118-c49d-4861-9815-7c03a2c3feab
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-10T16:31:31.233Z  WARN 368 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23514
2026-08-10T16:31:31.233Z ERROR 368 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: new row for relation "debitor" violates check constraint "check_default_prefix"
  Detail: Failing row contains (562cf118-c49d-4861-9815-7c03a2c3feab, 0, 21, 9057398c-5d57-46cc-9e76-ffecf5a99c77, 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#562cf118-c49d-4861-9815-7c03a2c3feab 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, 1b724188-8f7f-48da-92bc-9058c931d6a3
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-10T16:31:32.489Z  WARN 368 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23514
2026-08-10T16:31:32.489Z ERROR 368 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: new row for relation "debitor" violates check constraint "check_default_prefix"
  Detail: Failing row contains (1b724188-8f7f-48da-92bc-9058c931d6a3, 0, 21, 8ad037ff-8dad-4d87-b7db-43e9c3b35af9, 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#1b724188-8f7f-48da-92bc-9058c931d6a3 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, 151d3a1e-488d-4b72-8f14-129629b74650
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-10T16:31:33.749Z  WARN 368 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23514
2026-08-10T16:31:33.749Z ERROR 368 --- [    Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: new row for relation "debitor" violates check constraint "check_default_prefix"
  Detail: Failing row contains (151d3a1e-488d-4b72-8f14-129629b74650, 0, 21, 7bad70d5-3af0-4953-9aff-32be7444225e, 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#151d3a1e-488d-4b72-8f14-129629b74650 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