2026-08-10T16:40:42.518Z INFO 380 --- [ 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-10T16:40:42.526Z INFO 380 --- [ 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, c992dcb2-24cb-407f-93c9-454023e73e3a
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, c992dcb2-24cb-407f-93c9-454023e73e3a
Hibernate: update hs_office.sepamandate_rv set agreement=?,bankaccountuuid=?,debitoruuid=?,reference=?,validity=?,version=? where uuid=? and version=?
2026-08-10T16:40:43.409Z WARN 380 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: P0001
2026-08-10T16:40:43.409Z ERROR 380 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: [403] Subject {d77c95be-c06f-470a-9ff4-dcc8177c4267} is not allowed to update hs_office.sepamandate uuid c992dcb2-24cb-407f-93c9-454023e73e3a
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#c992dcb2-24cb-407f-93c9-454023e73e3a 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, 26df2b72-8351-494a-86c3-5de7347a1292
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, 26df2b72-8351-494a-86c3-5de7347a1292
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#26df2b72-8351-494a-86c3-5de7347a1292 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