2026-08-10T15:06:43.701Z INFO 371 --- [ Test worker] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [net.hostsharing.hsadminng.hs.office.sepamandate.HsOfficeSepaMandateRepositoryIntegrationTest$DeleteByUuid]: DeleteByUuid does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-08-10T15:06:43.711Z INFO 371 --- [ Test worker] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration net.hostsharing.hsadminng.HsadminNgApplication for test class net.hostsharing.hsadminng.hs.office.sepamandate.HsOfficeSepaMandateRepositoryIntegrationTest$DeleteByUuid
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
deletingASepaMandateAlsoDeletesRelatedRolesAndGrants(): 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: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
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 join hs_office.relation dr1_0 on dr1_0.uuid=hode1_0.debitorreluuid join (hs_office.partner hopre1_0 join hs_office.relation pr1_0 on pr1_0.uuid=hopre1_0.partnerreluuid) on pr1_0.holderuuid=dr1_0.anchoruuid and pr1_0.type='PARTNER' and dr1_0.type='DEBITOR' join hs_office.person hopre2_0 on hopre2_0.uuid=pr1_0.holderuuid or hopre2_0.uuid=dr1_0.holderuuid join hs_office.contact hocre1_0 on hocre1_0.uuid=dr1_0.contactuuid or hocre1_0.uuid=pr1_0.contactuuid join hs_office.partner_details_rv d1_0 on d1_0.uuid=hopre1_0.detailsuuid where ? is null or d1_0.birthname like (cast(? as varchar)||'%') escape '' or hopre2_0.tradename like (cast(? as varchar)||'%') escape '' or hopre2_0.familyname like (cast(? as varchar)||'%') escape '' or hopre2_0.givenname like (cast(? as varchar)||'%') escape '' or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
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.uuid=?
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 hobae1_0.uuid,hobae1_0.bic,hobae1_0.holder,hobae1_0.iban,hobae1_0.version from hs_office.bankaccount_rv hobae1_0 where hobae1_0.uuid=?
Hibernate: select hobae1_0.uuid,hobae1_0.bic,hobae1_0.holder,hobae1_0.iban,hobae1_0.version from hs_office.bankaccount_rv hobae1_0 where hobae1_0.iban=? order by hobae1_0.iban
toCleanup(class net.hostsharing.hsadminng.hs.office.sepamandate.HsOfficeSepaMandateEntity, c2e4c709-36b0-4797-bf1f-10898e020543
Hibernate: insert into hs_office.sepamandate_rv (agreement,bankaccountuuid,debitoruuid,reference,validity,version,uuid) values (?,?,?,?,?,?,?)
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hosme1_0.uuid,hosme1_0.agreement,hosme1_0.bankaccountuuid,hosme1_0.debitoruuid,hosme1_0.reference,hosme1_0.validity,hosme1_0.version from hs_office.sepamandate_rv hosme1_0 where hosme1_0.uuid=?
Hibernate: select hobae1_0.uuid,hobae1_0.bic,hobae1_0.holder,hobae1_0.iban,hobae1_0.version from hs_office.bankaccount_rv hobae1_0 where hobae1_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 hopre1_0.uuid,hopre1_0.detailsuuid,hopre1_0.partnernumber,hopre1_0.partnerreluuid,hopre1_0.version from hs_office.partner hopre1_0 where hopre1_0.uuid=?
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 hobae1_0.uuid,hobae1_0.bic,hobae1_0.holder,hobae1_0.iban,hobae1_0.version from hs_office.bankaccount_rv hobae1_0 where hobae1_0.uuid=?
Hibernate: delete from hs_office.sepamandate_rv where uuid=? and version=?
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.sepamandate WHERE uuid=?
DELETING temporary HsOfficeSepaMandateEntity#c2e4c709-36b0-4797-bf1f-10898e020543 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
deletingASepaMandateAlsoDeletesRelatedRolesAndGrants(): 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
globalAdmin_withoutAssumedRole_canDeleteAnySepaMandate(): 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: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
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 join hs_office.relation dr1_0 on dr1_0.uuid=hode1_0.debitorreluuid join (hs_office.partner hopre1_0 join hs_office.relation pr1_0 on pr1_0.uuid=hopre1_0.partnerreluuid) on pr1_0.holderuuid=dr1_0.anchoruuid and pr1_0.type='PARTNER' and dr1_0.type='DEBITOR' join hs_office.person hopre2_0 on hopre2_0.uuid=pr1_0.holderuuid or hopre2_0.uuid=dr1_0.holderuuid join hs_office.contact hocre1_0 on hocre1_0.uuid=dr1_0.contactuuid or hocre1_0.uuid=pr1_0.contactuuid join hs_office.partner_details_rv d1_0 on d1_0.uuid=hopre1_0.detailsuuid where ? is null or d1_0.birthname like (cast(? as varchar)||'%') escape '' or hopre2_0.tradename like (cast(? as varchar)||'%') escape '' or hopre2_0.familyname like (cast(? as varchar)||'%') escape '' or hopre2_0.givenname like (cast(? as varchar)||'%') escape '' or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
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.uuid=?
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 hobae1_0.uuid,hobae1_0.bic,hobae1_0.holder,hobae1_0.iban,hobae1_0.version from hs_office.bankaccount_rv hobae1_0 where hobae1_0.uuid=?
Hibernate: select hobae1_0.uuid,hobae1_0.bic,hobae1_0.holder,hobae1_0.iban,hobae1_0.version from hs_office.bankaccount_rv hobae1_0 where hobae1_0.iban=? order by hobae1_0.iban
toCleanup(class net.hostsharing.hsadminng.hs.office.sepamandate.HsOfficeSepaMandateEntity, f762f578-520f-4a26-b500-90f9de0c80d7
Hibernate: insert into hs_office.sepamandate_rv (agreement,bankaccountuuid,debitoruuid,reference,validity,version,uuid) values (?,?,?,?,?,?,?)
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hosme1_0.uuid,hosme1_0.agreement,hosme1_0.bankaccountuuid,hosme1_0.debitoruuid,hosme1_0.reference,hosme1_0.validity,hosme1_0.version from hs_office.sepamandate_rv hosme1_0 where hosme1_0.uuid=?
Hibernate: select hobae1_0.uuid,hobae1_0.bic,hobae1_0.holder,hobae1_0.iban,hobae1_0.version from hs_office.bankaccount_rv hobae1_0 where hobae1_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 hopre1_0.uuid,hopre1_0.detailsuuid,hopre1_0.partnernumber,hopre1_0.partnerreluuid,hopre1_0.version from hs_office.partner hopre1_0 where hopre1_0.uuid=?
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 hobae1_0.uuid,hobae1_0.bic,hobae1_0.holder,hobae1_0.iban,hobae1_0.version from hs_office.bankaccount_rv hobae1_0 where hobae1_0.uuid=?
Hibernate: delete from hs_office.sepamandate_rv where uuid=? and version=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hosme1_0.uuid,hosme1_0.agreement,hosme1_0.bankaccountuuid,hosme1_0.debitoruuid,hosme1_0.reference,hosme1_0.validity,hosme1_0.version from hs_office.sepamandate_rv hosme1_0 where hosme1_0.uuid=?
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.sepamandate WHERE uuid=?
DELETING temporary HsOfficeSepaMandateEntity#f762f578-520f-4a26-b500-90f9de0c80d7 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_withoutAssumedRole_canDeleteAnySepaMandate(): 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
nonGlobalAdmin_canNotDeleteTheirRelatedSepaMandate(): 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: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
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 join hs_office.relation dr1_0 on dr1_0.uuid=hode1_0.debitorreluuid join (hs_office.partner hopre1_0 join hs_office.relation pr1_0 on pr1_0.uuid=hopre1_0.partnerreluuid) on pr1_0.holderuuid=dr1_0.anchoruuid and pr1_0.type='PARTNER' and dr1_0.type='DEBITOR' join hs_office.person hopre2_0 on hopre2_0.uuid=pr1_0.holderuuid or hopre2_0.uuid=dr1_0.holderuuid join hs_office.contact hocre1_0 on hocre1_0.uuid=dr1_0.contactuuid or hocre1_0.uuid=pr1_0.contactuuid join hs_office.partner_details_rv d1_0 on d1_0.uuid=hopre1_0.detailsuuid where ? is null or d1_0.birthname like (cast(? as varchar)||'%') escape '' or hopre2_0.tradename like (cast(? as varchar)||'%') escape '' or hopre2_0.familyname like (cast(? as varchar)||'%') escape '' or hopre2_0.givenname like (cast(? as varchar)||'%') escape '' or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
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.uuid=?
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 hobae1_0.uuid,hobae1_0.bic,hobae1_0.holder,hobae1_0.iban,hobae1_0.version from hs_office.bankaccount_rv hobae1_0 where hobae1_0.uuid=?
Hibernate: select hobae1_0.uuid,hobae1_0.bic,hobae1_0.holder,hobae1_0.iban,hobae1_0.version from hs_office.bankaccount_rv hobae1_0 where hobae1_0.iban=? order by hobae1_0.iban
toCleanup(class net.hostsharing.hsadminng.hs.office.sepamandate.HsOfficeSepaMandateEntity, 0e65a30b-094a-4cb5-93c0-f1e742ab9b23
Hibernate: insert into hs_office.sepamandate_rv (agreement,bankaccountuuid,debitoruuid,reference,validity,version,uuid) values (?,?,?,?,?,?,?)
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hosme1_0.uuid,hosme1_0.agreement,hosme1_0.bankaccountuuid,hosme1_0.debitoruuid,hosme1_0.reference,hosme1_0.validity,hosme1_0.version from hs_office.sepamandate_rv hosme1_0 where hosme1_0.uuid=?
Hibernate: select hobae1_0.uuid,hobae1_0.bic,hobae1_0.holder,hobae1_0.iban,hobae1_0.version from hs_office.bankaccount_rv hobae1_0 where hobae1_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 hopre1_0.uuid,hopre1_0.detailsuuid,hopre1_0.partnernumber,hopre1_0.partnerreluuid,hopre1_0.version from hs_office.partner hopre1_0 where hopre1_0.uuid=?
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 hobae1_0.uuid,hobae1_0.bic,hobae1_0.holder,hobae1_0.iban,hobae1_0.version from hs_office.bankaccount_rv hobae1_0 where hobae1_0.uuid=?
Hibernate: select hosme1_0.uuid,hosme1_0.agreement,hosme1_0.bankaccountuuid,hosme1_0.debitoruuid,hosme1_0.reference,hosme1_0.validity,hosme1_0.version from hs_office.sepamandate_rv hosme1_0 where hosme1_0.uuid=?
Hibernate: delete from hs_office.sepamandate_rv where uuid=? and version=?
2026-08-10T15:06:47.859Z WARN 371 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: P0001
2026-08-10T15:06:47.860Z ERROR 371 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: [403] Subject {17d7012f-83e4-5ca9-b72a-a134765fc27f} is not allowed to delete hs_office.sepamandate uuid 0e65a30b-094a-4cb5-93c0-f1e742ab9b23
Where: PL/pgSQL function hs_office.sepamandate_instead_of_delete_tf() line 7 at RAISE
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hosme1_0.uuid,hosme1_0.agreement,hosme1_0.bankaccountuuid,hosme1_0.debitoruuid,hosme1_0.reference,hosme1_0.validity,hosme1_0.version from hs_office.sepamandate_rv hosme1_0 where hosme1_0.uuid=?
Hibernate: select hobae1_0.uuid,hobae1_0.bic,hobae1_0.holder,hobae1_0.iban,hobae1_0.version from hs_office.bankaccount_rv hobae1_0 where hobae1_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 hopre1_0.uuid,hopre1_0.detailsuuid,hopre1_0.partnernumber,hopre1_0.partnerreluuid,hopre1_0.version from hs_office.partner hopre1_0 where hopre1_0.uuid=?
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 hobae1_0.uuid,hobae1_0.bic,hobae1_0.holder,hobae1_0.iban,hobae1_0.version from hs_office.bankaccount_rv hobae1_0 where hobae1_0.uuid=?
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.sepamandate WHERE uuid=?
DELETING temporary HsOfficeSepaMandateEntity#0e65a30b-094a-4cb5-93c0-f1e742ab9b23 deleted 1 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
nonGlobalAdmin_canNotDeleteTheirRelatedSepaMandate(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0