GNOME Bugzilla – Bug 748644
General Ledger Report - An error occurred while running the report
Last modified: 2018-06-29 23:40:32 UTC
Since installing GNUCash 2.6.6 the General Ledger Report returns only "An error occurred while running the report". This was working up until v 2.6.5. I have checked on another machine running this version of GNUCash and it has the same problem.
I should say that this error occurs when you select General Ledger from Reports | Assets and Liabilities | General Ledger. It also means that any saved General Ledger Reports that you have (from a previous version ) fail to run.
Hi Julian, Can you provide the gnucash trace file which is generated while attempting to run the General Ledger report ? Where and how to get this trace file is explained here: http://wiki.gnucash.org/wiki/Tracefile
Created attachment 304674 [details] Tracefile attached
Thank you for the trace file. It suggests the code for your general ledger report is bad, which is rather odd. So it seems to point in the direction of a bad installation, or interference from an older install. Can you try this: - Uninstall gnucash via its uninstaller program - Check in c:\Program Files(x86) if the directory gnucash still exists. If so remove it. - Reinstall gnucash 2.6.6 Other things to check: did you ever create custom reports (by adding a file in the .gnucash directory inside c:\users\<youraccount>\ ? These may interfere as well. Where did you download gnucash from ? And did you check the validity of the download ?
Oh, and just for reference I have tried to reproduce this by installing gnucash 2.6.6 as downloaded from the gnucash website on a fresh Windows 7 Home Premium (64-bit) PC. For me the report works just fine.
Created attachment 305977 [details] Trace file 2
I have in the past made changes to invoice.scm, easy-invoice.scm and fancy-invoice.scm to change the word 'Tax' to 'GST' and the report title from 'Invoice' to 'Tax Invoice' to comply with Australian requirements. I always had to re-copy the files though, as they were replaced by the default ones on an upgrade. This was fine, although I had to do them again for 2.6.5 and the location had also changed. So I have followed your instructions and also haven't copied these back or opened the templates. I have done the following: - Used the uninstaller to remove Gnucash - Deleted the gnucash folder - Deleted the .gnucash folder from c:/users/<username> - Re downloaded Gnucash 2.6.6 via the website - Reinstalled Gnucash 2.6.6 The problem remains, so I must have some remaining artefact somewhere. Do you have any other ideas?
Ok, I've just installed 2.6.7 and the General Ledger report will now run successfully. However, all of my saved reports that used the General Ledger report are now blank with no accounts selected. So I'm thinking something must have changed in the General Ledger report? I've uploaded the latest tracefile after running the report if that helps you.
Created attachment 306286 [details] Trace file 3 - report working with blank data 2.6.7
(In reply to Julian from comment #8) > Ok, I've just installed 2.6.7 and the General Ledger report will now run > successfully. > > However, all of my saved reports that used the General Ledger report are now > blank with no accounts selected. So I'm thinking something must have changed > in the General Ledger report? > I have looked multiple times through all the changes between gnucash 2.6.5 and 2.6.7. There is only one change that affects the General Ledger report [1]. It doesn't however introduce a change that would cause your saved reports to loose the account selection. So unfortunately I have no idea what is happening here exactly. > I've uploaded the latest tracefile after running the report if that helps > you. For some reason your saved reports have become corrupt. Can you attach the saved-reports-2.4 file from c:\users\<your-user-name>\.gnucash ? [1] https://github.com/Gnucash/gnucash/commit/becec4022b64161b66ff61338f133d9d43f769b0
Closing this bug report as no further information has been provided. Please feel free to reopen this bug report if you can provide the information that was asked for in a previous comment. Thanks!
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=748644. Please update any external references or bookmarks.