[GNC] Balance Sheet fails to run for dates more than 7 month ago.

[James Edmunds]

In Dec 2023 I  tried to upgrade from Ubuntu 18.04 to Ubuntu 20.04  . There was some file corruption which was difficult for me to fix so I wiped the hard disc clean and installed a fresh version of Ubuntu 20.04 .

In 20.04   I use Gnucash 3.8 . In 18.04 I used Gnucash 2.6.19


At the time of the installation of GC 3.8 I thought that all my reports worked . Now I find that  when I try to run a Balance Sheet for any date earlier than  about 7 months ago it  fails  . I use the  price source " nearest in time"  in the BS.

I had not input any security /currency prices  in the Price Table between  28 Apr 2023 and 23 Oct 2023 .

See error report .


An error occurred while running the report.

In srfi/srfi-1.scm:
   592:29 19 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29 18 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29 17 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29 16 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29 15 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29 14 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29 13 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29 12 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29 11 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29 10 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29  9 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29  8 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29  7 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29  6 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29  5 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:29  4 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
   592:17  3 (map1 (#<<gnc-monetary> commodity: #<swig-pointer gnc_commod…> …))
In commodity-utilities.scm:
   933:46  2 (_ #<<gnc-monetary> commodity: #<swig-pointer gnc_commodity * 5…>)
   780:12  1 (gnc:exchange-by-pricedb-nearest _ #<swig-pointer gnc_commodit…> …)
In unknown file:
           0 (gnc-pricedb-convert-balance-nearest-price-t64 #<swig-pointer …> …)

Throw to key `numerical-overflow' with args `("/" "Numerical overflow" #f #f)'.



This table show the result  of running the BS on various dates . I can understand the BS might fail if it was run on dates  when there were no security prices in  GC , but is is not so simple . The BS fails on 28  Apr when there are prices in GC



23 Oct 23  -  ok

30 Sep 23   - ok

31 Aug 23  - ok

31 Jul  23   - ok

30 Jun 23   - ok

16 Jun 23  - ok

15 Jun 23  - fails

14 Jun 23  - fails

28 Apr23  - fails

31 Dec 22  -fails


What do I do to fix this ?