Crash with transaction report.

[Richard Dawson]

On 06/09/2015 06:44 PM, Richard Dawson wrote:
> Thank you for your response.
>
> I am using GnuCash 2.6.1, built from rev 76cba80+ on 2014-02-19
> I am using Linux Mint KDE
> I am using the default storage - I think that it is uncompressed XML.  I
> declined to switch to database storage.  I can open the file with a text
> editor, and the first few lines look like this
>
>     <?xml version="1.0" encoding="utf-8" ?>
>     <gnc-v2
>          xmlns:gnc="http://www.gnucash.org/XML/gnc"
>          xmlns:act="http://www.gnucash.org/XML/act"
>          xmlns:book="http://www.gnucash.org/XML/book"
>          xmlns:cd="http://www.gnucash.org/XML/cd"
>          xmlns:cmdty="http://www.gnucash.org/XML/cmdty"
>          xmlns:price="http://www.gnucash.org/XML/price"
>
>
>
> Check and repair produced a strange result.  Prior to running it I had
> no imbalances and one orphan.  Immediately after running it, which
> didn't take very long, I had some $105K in imbalances.  Oh #%C$%&&!
> I closed the file, opened the back-up to verify that I didn't have those
> imbalances.  I then re-opened the main file to see if I could make any
> sense of the imbalances.  Happily, they had disappeared.
>
> I corrected the one orphan, then reran the result.  Same result.
>
> Thanks,
>
> Richard
>
> On 06/09/2015 03:45 PM, gnucash-user-request at gnucash.org wrote:
>> Message: 3 Date: Tue, 9 Jun 2015 20:37:09 +0100 From: Wm
>> <wm+gnc at tarrcity.demon.co.uk> To: gnucash-user at gnucash.org Subject:
>> Re: Crash with transaction report. Message-ID:
>> <kPZC5+BlB0dVFwiY at tarrcity.demon.co.uk> Content-Type:
>> text/plain;charset=us-ascii Mon, 8 Jun 2015 22:10:31
>> <55767547.6000100 at att.net> Richard Dawson <rcdawson at att.net>
>>>> I have been maintaining my accounts on gnucash since 2002.  Recently I
>>>> came across a balancing error in one account.  suspecting that I had
>>>> accidentally deleted or altered a transaction,  I decided to create
>>>> transaction reports from the current file and from an earlier backup so
>>>> I could compare them transaction by transaction.
>>>>
>>>> When I attempted to run a transaction report for the entire history, I
>>>> got a message in the transaction report window that an error had
>>>> occurred, and then gnucash ceased to run.  I restarted gnucash and it
>>>> opened with the file seemingly none-the worse for the experience.
>>>>
>>>> Thinking that perhaps a single transaction was somehow corrupted, reran
>>>> the report with only the last month, then the last two months, etc,
>>>> until the problem recurred.  I was able to print out reports or the
>>>> period 6/1/2014 - today.  If I went back further, gnucash crashed
>>>> again.
>>>>
>>>> I then attempted to create reports starting with the earliest
>>>> transaction and ending before 6/1/2014.  Guncash crashed again.
>>>>
>>>> Then I tried incremental reports starting at the beginning:  these were
>>>> the results
>>>> report period                     Result
>>>> 1/1/2002-12/31/2002            OK
>>>> 1/1/2003-12/31/2003            OK
>>>> 1/1/2002-12/31/2003            Crash
>>>> 6/1/2002-5/31/2003              Crash
>>>>
>>>> How can I trouble shoot this.  Is there any utility for verifying the
>>>> integrity of the file?  For repairing the file?
>>>>
>>>> Thanks in advance for any help.
>> saying
>>
>>   gnc version
>>   OS
>>   storage (XML compressed or not, SQL, etc)
>>
>> will help the next helper.
>>
>> make some backups (you sound like the sort of person that might have
>> them but there is no harm in going wholesale)
>>
>> first thing to try after that
>>
>>   switch to the accounts tab
>>   Actions / Check and repair / check all
>>
>>   make tea as you have 13 years worth of data
>>
>> do you have any Imbalance or Orphan accounts.
>>
>> If you do they're the place to start looking for answers.
>>
>> -- Wm...

Thank you for your response.

I am using GnuCash 2.6.1, built from rev 76cba80+ on 2014-02-19
I am using Linux Mint KDE
I am using the default storage - I think that it is uncompressed XML.  I
declined to switch to database storage.  I can open the file with a text
editor, and the first few lines look like this

    <?xml version="1.0" encoding="utf-8" ?>
    <gnc-v2
         xmlns:gnc="http://www.gnucash.org/XML/gnc"
         xmlns:act="http://www.gnucash.org/XML/act"
         xmlns:book="http://www.gnucash.org/XML/book"
         xmlns:cd="http://www.gnucash.org/XML/cd"
         xmlns:cmdty="http://www.gnucash.org/XML/cmdty"
         xmlns:price="http://www.gnucash.org/XML/price"



Check and repair produced a strange result.  Prior to running it I had
no imbalances and one orphan.  Immediately after running it, which
didn't take very long, I had some $105K in imbalances.  Oh #%C$%&&!
I closed the file, opened the back-up to verify that I didn't have those
imbalances.  I then re-opened the main file to see if I could make any
sense of the imbalance entries.  Happily, they had disappeared.  The data seems intact.

I corrected the one orphan, then reran the result.  Same result. 

I tried to find a newer version of gnucash, but was unable to find one short of trying to compile from source.  Not something I have done, so a little reluctant.

Any more ideas?

Richard