Error running Payable Aging report

[Giancarlo Susin]

Some additional info about this: unposting the last bill I created, the 
error disappears. If I repost it, the error shows up again.

As it was the only one with a due date more than 1 year from today, I 
edited it and changed the due date to 05/01/15. Then I posted it and 
didn't get any error in reports.

So the only workaround I was able to find was to limit the due date of 
bills to less than 1 year from now.

Regards,

Giancarlo

Em 09-05-2014 20:47, Giancarlo Susin escreveu:
> Hello,
>
> I have been using Gnucash for 5 years in my small business. Today I 
> got the message "An error occurred while running the report" when I 
> opened Payable Aging report.
>
> I found the same error reported in 2012 on Gnucash Portable:
> http://lists.gnucash.org/pipermail/gnucash-user/2012-October/046216.html
>
> But with the difference that I have a stable release: Gnucash 2.6.2 on 
> Linux with MySQL backend, built from rev 667b581+ on 2014-03-20.
>
> The error happened just after I created and posted 7 new bills, each 
> one using the duplicate button from the previous one. The same error 
> shows up in Vendor Report if I select the same company that owns these 
> bills. Selecting other companies doesn't produce the error.
>
> Below is my trace file while I open Reports > Business > Payable Aging 
> report:
>
> susin at garoupa:~> tail -f /tmp/gnucash.trace
> * 19:59:48  WARN <gnc.backend.sql> [load_invoice_guid()] Invoice ref 
> 'a64a958dda89669bedf0c2936ff597cf' not found
> * 19:59:48  WARN <gnc.backend.sql> [load_invoice_guid()] Invoice ref 
> 'd16a2686095121eb409a8ce6cd9b9c0f' not found
> * 19:59:48  WARN <gnc.backend.sql> [load_invoice_guid()] Invoice ref 
> 'e477e6f09a3e3b57ba16885358bf866a' not found
> * 19:59:48  WARN <gnc.backend.sql> [load_invoice_guid()] Invoice ref 
> '2bd921639bc50ac5f24f72f16dc4b9b2' not found
> * 19:59:48  WARN <gnc.backend.sql> [load_invoice_guid()] Invoice ref 
> 'c4a86dc88c32a49a63e61323a177e8cc' not found
> * 19:59:48  WARN <gnc.backend.sql> [load_invoice_guid()] Invoice ref 
> '0ce8bd9099ef9cc60081f9867e99bf79' not found
> * 20:00:07  WARN <gnc.scm> In ice-9/boot-9.scm:
>  171: 19 [with-throw-handler #t #<catch-closure 3953cc0> 
> #<catch-closure 3953ca0>]
> In unknown file:
>    ?: 18 [apply-smob/1 #<catch-closure 3953cc0>]
>    ?: 17 [call-with-input-string "(gnc:report-run 0)" ...]
> In ice-9/boot-9.scm:
> 2320: 16 [save-module-excursion #<procedure 3954cc0 at 
> ice-9/eval-string.scm:65:9 ()>]
> In ice-9/eval-string.scm:
>   44: 15 [read-and-eval #<input: string 2d42000> #:lang ...]
>   37: 14 [lp (gnc:report-run 0)]
> In report.scm:
>  771: 13 [gnc:report-run 0]
> In ice-9/boot-9.scm:
>  157: 12 [catch ignore #<procedure 3954ab0 at gnucash/main.scm:112:4 
> ()> ...]
> In unknown file:
>    ?: 11 [lazy-catch #t #<procedure 3954a50 at gnucash/main.scm:114:18 
> ()> ...]
> In ice-9/boot-9.scm:
>  171: 10 [with-throw-handler #t #<catch-closure 3953980> 
> #<catch-closure 3953960>]
> In unknown file:
>    ?: 9 [apply-smob/1 #<catch-closure 3953980>]
> In report.scm:
>  775: 8 [#<procedure 3954ae0 at report.scm:772:5 ()>]
>  746: 7 [gnc:report-render-html # #t]
> In gnucash/report/aging.scm:
>  599: 6 [aging-renderer # "Payable Account" # ...]
> In ice-9/boot-9.scm:
>  700: 5 [for-each #<procedure 3a60b40 at 
> gnucash/report/aging.scm:599:22 (split)> #]
> In gnucash/report/aging.scm:
>  218: 4 [update-company-hash #<hash-table 397bd20 2/31> # # ...]
>  124: 3 [process-invoice # # # ...]
>  111: 2 [find-bucket 5 #(# # # # ...) (1431226800 . 0)]
> In ice-9/boot-9.scm:
>  102: 1 [#<procedure 2d43180 at ice-9/boot-9.scm:97:6 (thrown-k . 
> args)> out-of-range ...]
> In unknown file:
>    ?: 0 [apply-smob/1 #<catch-closure 3953960> out-of-range ...]
> ERROR: In procedure apply-smob/1:
> ERROR: Value out of range: 5
>
> Thank you very much for any help!
>
> Regards,
>
> Giancarlo
> _______________________________________________
> 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.