Crash with transaction report.

[Derek Atkins]

Hi,

Richard Dawson <rcdawson at att.net> writes:

> Thank you for your response.
>
> I am using GnuCash 2.6.1, built from rev 76cba80+ on 2014-02-19

2.6.6 is current.  There are lots of known bugs in 2.6.1.
You should update before any further testing.

> 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

-derek

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

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available