Hello I checked (undoLoanDisbursal and reverseAllTransactions) and didn't find the relation between the changes i did and the mentioned methods.
Also i get the same error when i try to edit repayment transaction and the log in both errors says the FailedObject is in the query found in file o.a.f.p.a.d.AccountTransferRepository. I have tested also another action which use method from o.a.f.p.a.d.AccountTransferRepository. and give the same error. But i haven't changed anything in this file. Best Regards > On July 31, 2019 at 5:45 PM [email protected] > wrote: > > > Your problem is: „Too many tables; MySQL can only use 61 tables in a join“ > (http://bit.ly/61TblLmt). There's a join that uses sixty-nine tables (t69): > > „...t69.total_pending_shares, t67.unit_price, t67.status_enum, > t67.total_shares, t67.transaction_date, t67.type_enum FROM > m_account_transfer_transaction t0 INNER JOIN m_account_transfer_details t1 ON > t0.account_transfer_details_id = t1.id...“ > > You might want to look at either > o.a.f.p.l.s.LoanWritePlatformServiceJpaRepositoryImpl.undoLoanDisbursal or > o.a.f.p.a.s.AccountTransfersWritePlatformServiceImpl.reverseAllTransactions. > > > > > > ---- > Sent using Guerrillamail.com > Block or report abuse: > https://www.guerrillamail.com//abuse/?a=RURiJQsJTbEHiQ2gvn8PcxfPSISfwNA%3D > > Mexina Daniel Singo Africa Limited Mbezi Beach "B" | Mwai Kibaki Road | 6 Wasafi Str. P.O BOX 78908 | 14121 Dar es salaam +255 71 211 0791 | +255 22 261 8511 amala.co.tz | singo.africa
