[kmymoney] [Bug 410994] Losing transactions after 8000+ DB to KmyFile

[robsonsilva]

https://bugs.kde.org/show_bug.cgi?id=410994

--- Comment #9 from robsonsilva <evertondanilo at yahoo.com.br> ---
(In reply to Thomas Baumgart from comment #8)
> Created attachment 122245 [details]
> Screenshot showing one of the accounts
> 
> (In reply to robsonsilva from comment #7)
> 
> > For e.g On ledger screen:
> > 
> > If you check last transaction date (sqlite file) and then last transaction
> > date after save as (kmy file) you will see these differences:
> > 
> > Account ID, before, after save as kmy:
> > A000331, 16-aug-2019, 08-jul-2019
> > A000329, 10-aug-2019, 06-jul-2019
> > A000344, 09-jul-2019, 25-jun-2019
> 
> I just did that and I cannot confirm the dates you report for the sqlite
> file. I do see exactly the ones that you report for the kmy file. A000331
> attached as an example.

The problem is sqlfile is already at a weird state,I guess.
I've attached the steps starting from anonymizer.xml to sqlite to kmy file
now...

I've attached xml file and screenshots of steps.


1 - User open anonymizer.xml file
2 - User check reports, ledger
3 - User save as sqlite, close KMY and open again (now sqlite file)
4 - Orphan splits are found in sqlite (dbBrowser)
        select * from kmmTransactions where id not in (select distinct
transactionId from kmmSplits)
5 - User cannot see latest transaction on reports, but
        he can see on ledger yet.. it seems kmmslipts are about to be lost
(probably in some cache table?)
6 - User save as kmy file and Close KMY
7 - User Open kmy file and go to ledger
8 - Transactions missing

-- 
You are receiving this mail because:
You are the assignee for the bug.