After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 794932 - Invoice report throws with numerical-overflow
Invoice report throws with numerical-overflow
Status: RESOLVED DUPLICATE of bug 794936
Product: GnuCash
Classification: Other
Component: Reports
3.0
Other Linux
: Normal normal
: future
Assigned To: gnucash-reports-maint
gnucash-reports-maint
Depends on:
Blocks:
 
 
Reported: 2018-04-03 12:52 UTC by Tom Vincent
Modified: 2018-06-30 00:06 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Invoice stack trace (1.32 KB, text/plain)
2018-04-03 12:52 UTC, Tom Vincent 		Details

Description Tom Vincent 2018-04-03 12:52:38 UTC 
Created attachment 370485 [details]
Invoice stack trace

When printing an existing invoice, "Report error An error occurred while running the report." is shown (stack trace attached).

In the invoice itself, the qty & unit price is empty and discount has "1 + 71622403761/1482537514336". If I edit that line with the correct qty/price, all is well, but this resets each time the book is opened.
Comment 1 Frank H. Ellenberger 2018-04-04 18:13:23 UTC 
Which backend (xml, SQL variant) are you using?

N.B. A strange discount was also reported in Bug 794982 - Business data gets garbled when carrying a SQL file form V 2.6.19 to V 3.0
Comment 2 Tom Vincent 2018-04-04 18:55:55 UTC 
That sounds familiar. I'm using the SQLite backend and also migrated from v2.6.19 to v3.0.
Comment 3 John Ralls 2018-04-06 16:31:19 UTC 
Even though this is 3 items newer, there's more information on bug 794936, so let's use that for dissecting the problem.

Tom, please post over there the results of the query
 select guid, qty_num, qty_denom, i_price_num, i_price_denom from events;
If you have a backup from 2.6.19 it would be helpful to run it on both.

*** This bug has been marked as a duplicate of bug 794936 ***
Comment 4 John Ralls 2018-06-30 00:06:46 UTC 
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=794932. Please update any external references or bookmarks.