2026-08-10T13:36:08.950Z INFO 378 --- [ 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-10T13:36:08.954Z INFO 378 --- [ 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, 1e3f187a-9515-47d3-b452-c5de07567892
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#1e3f187a-9515-47d3-b452-c5de07567892 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, 5dc35da7-fd62-4769-8984-ddb798595f32
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#5dc35da7-fd62-4769-8984-ddb798595f32 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, e0070477-725f-4e44-8658-e9543533c0e3
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-10T13:36:12.985Z WARN 378 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: P0001
2026-08-10T13:36:12.986Z ERROR 378 --- [ 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 e0070477-725f-4e44-8658-e9543533c0e3
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#e0070477-725f-4e44-8658-e9543533c0e3 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