unmadem
Member of DD Central
Posts: 377 
Likes: 181
|
Post by unmadem on Oct 24, 2014 12:18:21 GMT
It is probably the same issue but spotted that the figure for accrued interest on screen is different from that on the export.
screen 0.09, loan book export 0.1, actual 0.09782.........
(there has been suggestion on another thread that number of decimal places on export be increased to be consistent with statement export)
Very much looks like a display issue - I've forwarded this on to the front end developers to look in to. aye
|
|
|
|
Post by Come_on_Grandad on Oct 24, 2014 12:23:31 GMT
Very much looks like a display issue - I've forwarded this on to the front end developers to look in to. aye I have a plausible headline figure (on the dashboard) for accrued interest, but any display of individual loans and any loans export I try show zero accrued for all loans.
|
|
TFTO
Member of DD Central
Posts: 143
Likes: 71
|
Post by TFTO on Oct 24, 2014 12:25:18 GMT
I have a plausible headline figure (on the dashboard) for accrued interest, but any display of individual loans and any loans export I try show zero accrued for all loans. All my accruals on the individual loans still show 3-days worth of accruals but the dashboard may be correct.
|
|
ianj
Member of DD Central
Posts: 656
Likes: 520
|
Post by ianj on Oct 24, 2014 12:28:40 GMT
The accrued interest calculation is now live on the site. I'm going through my own figures now to make sure that what is displayed matches what is calculated behind the scenes. I've just picked up on the figure being rounded to nearest rather than rounded down so that's one potential issue that will be addressed later this afternoon, but that shouldn't affect the figure by more than 1p on any given display. While my Current Accrued Interest appears to be 'healthy', every loan is showing Interest Accrued = £0.00! 
|
|
|
|
Post by chris on Oct 24, 2014 12:29:44 GMT
Checking with the front end guys to make sure the fix was deployed on sub pages as well. The dashboard is the one I've checked on the homepage (obviously with the direct figures in the database as well).
One lender is discussing an 18p inconsistency with their calculated figure via PM so I've given them a breakdown and will double check line by line with them.
|
|
|
|
Post by chris on Oct 24, 2014 12:50:54 GMT
Confirmed with the front end guys that the new figures haven't been properly deployed except on the homepage - they'll be rolling it out shortly.
The figure on the dashboard is the full figure we're calculating behind the scenes so should be correct.
|
|
|
|
Post by chris on Oct 24, 2014 12:52:27 GMT
Checking with the front end guys to make sure the fix was deployed on sub pages as well. The dashboard is the one I've checked on the homepage (obviously with the direct figures in the database as well). One lender is discussing an 18p inconsistency with their calculated figure via PM so I've given them a breakdown and will double check line by line with them. The system has been proven correct on this one, but the lender is very kindly working through the rest of his loans. He's in agreement with all the loans checked so far.
|
|
|
|
Post by henders on Oct 24, 2014 13:05:25 GMT
This has probably been answered but cannot find it.
Does the new system show accrued interest on sold loans that have not yet paid back (e.g. H****ey)?
|
|
|
|
Post by chris on Oct 24, 2014 13:10:46 GMT
This has probably been answered but cannot find it. Does the new system show accrued interest on sold loans that have not yet paid back (e.g. H****ey)? It does, but only if the loan repayment plan is correct in the system. Whilst the new loan model is in place and supports FF for example, the admin team are yet to update the loan to correctly reflect its current state. I know this is high up on their radar so should be correct in a couple of working days time, but in the interim the system can only report based on the data its been given. Where the data is complete it should be accurate including all historical sales.
|
|
|
|
Post by henders on Oct 24, 2014 14:24:06 GMT
Thanks, Chris.
But where is accrued interest on sold loans shown?
I can pull up H***ney as a sold loan but nowhere does it indicate what interest I had accrued prior to it being sold and that is still unpaid until the loan itself is repaid.
Perplexing.
|
|
|
|
Post by henders on Oct 24, 2014 14:26:05 GMT
Cancel that request it's staring me in the face bundled in to my overall accrues interest; top right of "your loans" page.
Doh!!
|
|
|
|
Post by chris on Oct 24, 2014 14:58:54 GMT
Thanks, Chris. But where is accrued interest on sold loans shown? I can pull up H***ney as a sold loan but nowhere does it indicate what interest I had accrued prior to it being sold and that is still unpaid until the loan itself is repaid. Perplexing. It's in the total on the dashboard and in the totals shown where you still hold some loan units. For loans where you no longer hold any units you can't see the broken down figure yet, this will come early next week but was more involved for the front end guys as they need to restructure a couple of queries.
|
|
|
|
Post by Jack Barlow on Oct 24, 2014 15:11:04 GMT
Thanks, Chris. But where is accrued interest on sold loans shown? I can pull up H***ney as a sold loan but nowhere does it indicate what interest I had accrued prior to it being sold and that is still unpaid until the loan itself is repaid. Perplexing. It's in the total on the dashboard and in the totals shown where you still hold some loan units. For loans where you no longer hold any units you can't see the broken down figure yet, this will come early next week but was more involved for the front end guys as they need to restructure a couple of queries. Meanwhile, if you're desperate to see your unpaid accrued interest broken down for your completely sold loans now, you can do so via Loan Book > Browse Loans, filter on "Show all current loans" (which is the default) then click on the "Export as CSV" button at the bottom of the page. The information is in the downloaded file.
|
|
|
|
Post by chris on Oct 24, 2014 16:20:00 GMT
I've found one potential issue that is a display only problem. Currently the accrued interest calculation takes a while to run and aftermarket activity during that process is causing potential database locking issues. If that happens then currently the accrued interest process stops and throws an error.
I'm working on some optimisations and restructuring of the way the values are captured and stored, but if the figures look out either due to the overnight process failing to run properly or when a repayment has happened in the middle of the day please flag it up to me as it's probably a database deadlock prevented it from updating.
This is a display only issue and I will code around it but it could take a couple of days to fully work through a solution and track all potential conflicts.
|
|
|
|
Post by chris on Oct 24, 2014 17:48:56 GMT
I've found one potential issue that is a display only problem. Currently the accrued interest calculation takes a while to run and aftermarket activity during that process is causing potential database locking issues. If that happens then currently the accrued interest process stops and throws an error. I'm working on some optimisations and restructuring of the way the values are captured and stored, but if the figures look out either due to the overnight process failing to run properly or when a repayment has happened in the middle of the day please flag it up to me as it's probably a database deadlock prevented it from updating. This is a display only issue and I will code around it but it could take a couple of days to fully work through a solution and track all potential conflicts. chris for read-only reporting/display queries (IE where not in any way transactional), are you using the SQL optimiser hint " with (nolock) "
If not - as well as protecting transactional tables/columns/rows from being locked/blocked by your query, this can speed performance exponentially.
[If you are already (or if the DB is Oracle...) then disregard, and have a good weekend]
We're storing the accrued interest on the loan unit's table as the quickest way to develop that feature. This then conflicts with the aftermarket when a buy / sell event occurs or someone changes their preferences. Accrued interest needs to be calculated on several events, such as repayments being made, and this is where the conflict is occurring especially as the order in which rows are processed is important. I can force that on the accrued interest calculation but not on the aftermarket. I'm now locking at the loan level in several places, hopefully I've caught them all but there could be one or two more that I've missed. Over the weekend / next week I'll move to storing the accrued interest in a separate table so that I can avoid the conflicts and improve performance. Database is PostgreSQL.
|
|
