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

[David Cousens]

James,

You might want to take a look at https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade. From V2
to V3 there was a change in the location of the reports. Changes in location s of files take place where necessary on
the major version number changes. Further information is also available at
https://wiki.gnucash.org/wiki/Configuration_Locations. About halfway down the page are some diagrams which decode the
more complex description given above them for the 3 major OS.  

There is normally a process run during the upgrade which checks the version level of the data file and makes any changes
in the config  files locations which may not have run depending on how you upgraded. In most cases the fix is just
copying the old config files to the new location in the updated version.

David Cousens


On Sun, 2024-01-28 at 07:03 +0000, James Edmunds wrote:
> 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 ?
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.