Data file corruption in Kmymoney 0.9.2 (all categories lost)

[Claudio Felix]

Hi everyone,

I have been using Kmymoney for some years now and I find it perfect
for keeping track both from my personal and small business records.
You guys did a very good job on it!

Unfortunately, I was recently surprised by what it seems to be a
rather serious bug in kmymoney 0.9.2. I usually import my bank's data
from a custom awk script I made to convert my bank's ofc file to the
default .qif format accepted by kmymoney, and it always worked fine.
Last time I tried though, for some reason my script wasn't associated
to the importing profile, so nothing got imported. No big deal, I just
went there, associated it as my input filter, imported the data to a
specific account and went on to classify the imported transactions. To
my surprise, all my categories were gone! The accounts are all there,
but all asset and expense categories are completely lost, like they
had never been created before. I can't really say the importing
process has something to do with it, since before that I entered a
whole month of transactions in a passive account, constantly saving
the file.

One tip I had was from executing kmymoney from the command line, it
reported something about the file header which could explain kmymoney
not reading the file right:

kbuildsycoca running...
kio (KIOConnection): ERROR: Header read failed, errno=104
kio (KIOConnection): ERROR: Header has invalid size (-1)
reading file
start parsing file
startDocument
reading accounts
reading transactions
reading securities
reading prices
reading reports
endDocument

Since this file has years of data you can imagine how upset I am about
losing it, so I would really appreciate if someone could help me or at
least point me some documentation about the data file's internal
format I could use to recover the categories data, if that is
possible. Judging by the file size, it seems like all info should
still be there, since its size is consistently larger than some
previous backups I had. Anyway I would prefer try recovering the data
than using the 3 month old backup, since I had restructured a lot of
my categories since then.

Thank you all!
Claudio

------------------------------------------------------------------------------
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

În data de Duminică 05 Iulie 2009 22:29:54 Claudio Felix a scris:

> Hi everyone,
>
> I have been using Kmymoney for some years now and I find it perfect
> for keeping track both from my personal and small business records.
> You guys did a very good job on it!
>
> Unfortunately, I was recently surprised by what it seems to be a
> rather serious bug in kmymoney 0.9.2. I usually import my bank's data
> from a custom awk script I made to convert my bank's ofc file to the
> default .qif format accepted by kmymoney, and it always worked fine.
> Last time I tried though, for some reason my script wasn't associated
> to the importing profile, so nothing got imported. No big deal, I just
> went there, associated it as my input filter, imported the data to a
> specific account and went on to classify the imported transactions. To
> my surprise, all my categories were gone! The accounts are all there,
> but all asset and expense categories are completely lost, like they
> had never been created before. I can't really say the importing
> process has something to do with it, since before that I entered a
> whole month of transactions in a passive account, constantly saving
> the file.
>
> One tip I had was from executing kmymoney from the command line, it
> reported something about the file header which could explain kmymoney
> not reading the file right:
>
> kbuildsycoca running...
> kio (KIOConnection): ERROR: Header read failed, errno=104
> kio (KIOConnection): ERROR: Header has invalid size (-1)
> reading file
> start parsing file
> startDocument
> reading accounts
> reading transactions
> reading securities
> reading prices
> reading reports
> endDocument
>
> Since this file has years of data you can imagine how upset I am about
> losing it, so I would really appreciate if someone could help me or at
> least point me some documentation about the data file's internal
> format I could use to recover the categories data, if that is
> possible. Judging by the file size, it seems like all info should
> still be there, since its size is consistently larger than some
> previous backups I had. Anyway I would prefer try recovering the data
> than using the 3 month old backup, since I had restructured a lot of
> my categories since then.
>
> Thank you all!
> Claudio
>
> ---------------------------------------------------------------------------
>--- _______________________________________________
> KMyMoney2-developer mailing list
> KMyMoney2-developer@...
> https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

You could try to run a consistency check located under the 'Tools' menu. That
helped users that experienced this kind of behaviour as you can see at:
http://www.nabble.com/Critical-bug-in-the-development-release-td23357303.html

--
Regards,

Cristian Oneţ


------------------------------------------------------------------------------

_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

În data de Luni 06 Iulie 2009 01:14:08 ați scris:

> > You could try to run a consistency check located under the 'Tools' menu.
> > That helped users that experienced this kind of behaviour as you can see
> > at:
> > http://www.nabble.com/Critical-bug-in-the-development-release-td23357303.
> >html
> >
> > --
> > Regards,
> >
> > Cristian Oneţ
> >
> > -------------------------------------------------------------------------
> >-----
> >
> > _______________________________________________
> > KMyMoney2-developer mailing list
> > KMyMoney2-developer@...
> > https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer
>
> Hi Cristian,
>
> Thanks a lot! The Consistency check restored the categories back. The
> link you supplied described exactly the same problem I had indeed. If
> the corrupted file serves for anything to help fix this bug I'd be
> glad to send it upstream.

You are welcome. I don't know why after the last report this issue wasn't

tackled. I also stumbled upon this behaviour when I switched between kmymoney
files without restarting kmymoney (after several switches) but there wasn't a
sequence to reproduce this and if it can be fixed with a consistency check I
taught we could leave it as is. I'll try to check if it can still be
reproduced by switching files a lot and if it can than there is no need to send
your file. Thanks for offering your help.

--
Regards,

Cristian Oneţ


------------------------------------------------------------------------------

_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer