2026-08-10T13:36:13.406Z INFO 378 --- [ Test worker] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [net.hostsharing.hsadminng.hs.office.sepamandate.HsOfficeSepaMandateRepositoryIntegrationTest$UpdateSepaMandate]: UpdateSepaMandate does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-08-10T13:36:13.410Z INFO 378 --- [ Test worker] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration net.hostsharing.hsadminng.HsadminNgApplication for test class net.hostsharing.hsadminng.hs.office.sepamandate.HsOfficeSepaMandateRepositoryIntegrationTest$UpdateSepaMandate
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
bankAccountAdmin_canViewButNotUpdateRelatedSepaMandate(): 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, 0a6d666b-ab75-43bc-ad46-bdc9d3606995
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: 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: 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,ba1_0.uuid,ba1_0.bic,ba1_0.holder,ba1_0.iban,ba1_0.version,d1_0.uuid,d1_0.billable,d1_0.debitornumbersuffix,d1_0.debitorreluuid,dr1_0.uuid,dr1_0.anchoruuid,dr1_0.contactuuid,dr1_0.holderuuid,dr1_0.mark,dr1_0.type,dr1_0.version,d1_0.defaultprefix,(
SELECT DISTINCT partner.uuid
FROM hs_office.partner partner
JOIN hs_office.relation dRel
ON dRel.uuid = d1_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
)
,d1_0.refundbankaccountuuid,d1_0.vatbusiness,d1_0.vatcountrycode,d1_0.vatid,d1_0.vatreversecharge,d1_0.version,hosme1_0.reference,hosme1_0.validity,hosme1_0.version from hs_office.sepamandate_rv hosme1_0 left join hs_office.bankaccount_rv ba1_0 on ba1_0.uuid=hosme1_0.bankaccountuuid left join hs_office.debitor_rv d1_0 on d1_0.uuid=hosme1_0.debitoruuid left join hs_office.relation dr1_0 on dr1_0.uuid=d1_0.debitorreluuid where hosme1_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 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=?
toCleanup(class net.hostsharing.hsadminng.hs.office.sepamandate.HsOfficeSepaMandateEntity, 0a6d666b-ab75-43bc-ad46-bdc9d3606995
Hibernate: update hs_office.sepamandate_rv set agreement=?,bankaccountuuid=?,debitoruuid=?,reference=?,validity=?,version=? where uuid=? and version=?
2026-08-10T13:36:14.243Z WARN 378 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: P0001
2026-08-10T13:36:14.243Z ERROR 378 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: [403] Subject {4a876e25-b3c0-49f9-a3b4-f87050f3070e} is not allowed to update hs_office.sepamandate uuid 0a6d666b-ab75-43bc-ad46-bdc9d3606995
Where: PL/pgSQL function hs_office.sepamandate_instead_of_update_tf() line 13 at RAISE
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#0a6d666b-ab75-43bc-ad46-bdc9d3606995 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
bankAccountAdmin_canViewButNotUpdateRelatedSepaMandate(): 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
hostsharingAdmin_canUpdateArbitrarySepaMandate(): 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 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, 54dcc1ad-7b8a-457f-aee4-d92b7de43da9
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: 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,ba1_0.uuid,ba1_0.bic,ba1_0.holder,ba1_0.iban,ba1_0.version,d1_0.uuid,d1_0.billable,d1_0.debitornumbersuffix,d1_0.debitorreluuid,dr1_0.uuid,dr1_0.anchoruuid,dr1_0.contactuuid,dr1_0.holderuuid,dr1_0.mark,dr1_0.type,dr1_0.version,d1_0.defaultprefix,(
SELECT DISTINCT partner.uuid
FROM hs_office.partner partner
JOIN hs_office.relation dRel
ON dRel.uuid = d1_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
)
,d1_0.refundbankaccountuuid,d1_0.vatbusiness,d1_0.vatcountrycode,d1_0.vatid,d1_0.vatreversecharge,d1_0.version,hosme1_0.reference,hosme1_0.validity,hosme1_0.version from hs_office.sepamandate_rv hosme1_0 left join hs_office.bankaccount_rv ba1_0 on ba1_0.uuid=hosme1_0.bankaccountuuid left join hs_office.debitor_rv d1_0 on d1_0.uuid=hosme1_0.debitoruuid left join hs_office.relation dr1_0 on dr1_0.uuid=d1_0.debitorreluuid where hosme1_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 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=?
toCleanup(class net.hostsharing.hsadminng.hs.office.sepamandate.HsOfficeSepaMandateEntity, 54dcc1ad-7b8a-457f-aee4-d92b7de43da9
Hibernate: update hs_office.sepamandate_rv set agreement=?,bankaccountuuid=?,debitoruuid=?,reference=?,validity=?,version=? 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=?
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#54dcc1ad-7b8a-457f-aee4-d92b7de43da9 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
hostsharingAdmin_canUpdateArbitrarySepaMandate(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0