Crash with transaction report.

Thu Jun 11 00:08:39 EDT 2015

Do you have income statements and balance sheets that are monthly or annual.
Run a balance sheet first for any date you choose, to compare with a prior
report.  If the report is still the same, try a later date.  When you find
one that is different, run the income statement to cover that period and
compare with a prior report.  This will show you which account is different,
causing the difference in the balance sheet.  That will narrow down the
account with the problem.  Then you only need to compare the data in the
problem account for the period of the problem instead of the whole history.
Alice Lee

-----Original Message-----
From: gnucash-user
[mailto:gnucash-user-bounces+alee212007=satx.rr.com at gnucash.org] On Behalf
Of Richard Dawson
Sent: Wednesday, June 10, 2015 7:16 PM
To: gnucash-user at gnucash.org
Subject: Re: Crash with transaction report.

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 

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.