Crash with transaction report.

[Richard Dawson]

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...