[Spce-user] Error generating invoice
Henk
henk at voipdigit.nl
Sat Dec 2 08:27:24 EST 2017
Hi Irina,
I found another problem. The invoices that are generated, have a scaling
problem. Every next page is scaled at about 66% of the last one for the
first 25 pages, then it start at 100% and scales down again.
This is my panel-debug:
Dec 2 13:55:25 spce ngcp-panel: DEBUG: rsvg-convert -a -f pdf -z 0.8
/tmp/_Q5YIBaFpx/1.svg /tmp/_Q5YIBaFpx/2.svg /tmp/_Q5YIBaFpx/3.svg
/tmp/_Q5YIBaFpx/4.svg /tmp/_Q5YIBaFpx/5.svg /tmp/_Q5YIBaFpx/6.svg
/tmp/_Q5YIBaFpx/7.svg /tmp/_Q5YIBaFpx/8.svg /tmp/_Q5YIBaFpx/9.svg
/tmp/_Q5YIBaFpx/10.svg /tmp/_Q5YIBaFpx/11.svg /tmp/_Q5YIBaFpx/12.svg
/tmp/_Q5YIBaFpx/13.svg /tmp/_Q5YIBaFpx/14.svg /tmp/_Q5YIBaFpx/15.svg
/tmp/_Q5YIBaFpx/16.svg /tmp/_Q5YIBaFpx/17.svg /tmp/_Q5YIBaFpx/18.svg
/tmp/_Q5YIBaFpx/19.svg /tmp/_Q5YIBaFpx/20.svg /tmp/_Q5YIBaFpx/21.svg
/tmp/_Q5YIBaFpx/22.svg /tmp/_Q5YIBaFpx/23.svg /tmp/_Q5YIBaFpx/24.svg
/tmp/_Q5YIBaFpx/25.svg
Dec 2 13:55:25 spce ngcp-panel: DEBUG: rsvg-convert -a -f pdf -z 0.8
/tmp/_Q5YIBaFpx/26.svg /tmp/_Q5YIBaFpx/27.svg /tmp/_Q5YIBaFpx/28.svg
/tmp/_Q5YIBaFpx/29.svg /tmp/_Q5YIBaFpx/30.svg /tmp/_Q5YIBaFpx/31.svg
/tmp/_Q5YIBaFpx/32.svg /tmp/_Q5YIBaFpx/33.svg /tmp/_Q5YIBaFpx/34.svg
/tmp/_Q5YIBaFpx/35.svg /tmp/_Q5YIBaFpx/36.svg /tmp/_Q5YIBaFpx/37.svg
/tmp/_Q5YIBaFpx/38.svg /tmp/_Q5YIBaFpx/39.svg /tmp/_Q5YIBaFpx/40.svg
/tmp/_Q5YIBaFpx/41.svg /tmp/_Q5YIBaFpx/42.svg /tmp/_Q5YIBaFpx/43.svg
/tmp/_Q5YIBaFpx/44.svg /tmp/_Q5YIBaFpx/45.svg /tmp/_Q5YIBaFpx/46.svg
/tmp/_Q5YIBaFpx/47.svg /tmp/_Q5YIBaFpx/48.svg /tmp/_Q5YIBaFpx/49.svg
/tmp/_Q5YIBaFpx/50.svg
Dec 2 13:55:25 spce ngcp-panel: DEBUG: rsvg-convert -a -f pdf -z 0.8
/tmp/_Q5YIBaFpx/51.svg /tmp/_Q5YIBaFpx/52.svg /tmp/_Q5YIBaFpx/53.svg
/tmp/_Q5YIBaFpx/54.svg /tmp/_Q5YIBaFpx/55.svg /tmp/_Q5YIBaFpx/56.svg
/tmp/_Q5YIBaFpx/57.svg /tmp/_Q5YIBaFpx/58.svg /tmp/_Q5YIBaFpx/59.svg
/tmp/_Q5YIBaFpx/60.svg /tmp/_Q5YIBaFpx/61.svg /tmp/_Q5YIBaFpx/62.svg
/tmp/_Q5YIBaFpx/63.svg /tmp/_Q5YIBaFpx/64.svg /tmp/_Q5YIBaFpx/65.svg
/tmp/_Q5YIBaFpx/66.svg /tmp/_Q5YIBaFpx/67.svg /tmp/_Q5YIBaFpx/68.svg
/tmp/_Q5YIBaFpx/69.svg /tmp/_Q5YIBaFpx/70.svg /tmp/_Q5YIBaFpx/71.svg
/tmp/_Q5YIBaFpx/72.svg /tmp/_Q5YIBaFpx/73.svg /tmp/_Q5YIBaFpx/74.svg
/tmp/_Q5YIBaFpx/75.svg
Dec 2 13:55:25 spce ngcp-panel: DEBUG: rsvg-convert -a -f pdf -z 0.8
/tmp/_Q5YIBaFpx/76.svg /tmp/_Q5YIBaFpx/77.svg /tmp/_Q5YIBaFpx/78.svg
/tmp/_Q5YIBaFpx/79.svg /tmp/_Q5YIBaFpx/80.svg /tmp/_Q5YIBaFpx/81.svg
/tmp/_Q5YIBaFpx/82.svg /tmp/_Q5YIBaFpx/83.svg /tmp/_Q5YIBaFpx/84.svg
/tmp/_Q5YIBaFpx/85.svg /tmp/_Q5YIBaFpx/86.svg /tmp/_Q5YIBaFpx/87.svg
/tmp/_Q5YIBaFpx/88.svg /tmp/_Q5YIBaFpx/89.svg /tmp/_Q5YIBaFpx/90.svg
/tmp/_Q5YIBaFpx/91.svg /tmp/_Q5YIBaFpx/92.svg /tmp/_Q5YIBaFpx/93.svg
/tmp/_Q5YIBaFpx/94.svg /tmp/_Q5YIBaFpx/95.svg /tmp/_Q5YIBaFpx/96.svg
Dec 2 13:55:25 spce ngcp-panel: DEBUG: gs -dBATCH -dNOPAUSE -q
-sDEVICE=pdfwrite -dPDFSETTINGS=/prepress -sOutputFile=-
/tmp/_Q5YIBaFpx/1.pdf /tmp/_Q5YIBaFpx/2.pdf /tmp/_Q5YIBaFpx/3.pdf
/tmp/_Q5YIBaFpx/4.pdf
Regards,
Henk Plessius
On 1-12-2017 13:24, Henk wrote:
>
> Hi Irina,
>
> Sorry I missed that. Now the first invoice works, but the second has
> another error:
>
> MSG="Failed to create invoice ({UNKNOWN}: Can't call method "start" on
> an undefined value at /usr/share/perl5/NGCP/Panel/Utils/Invoice.pm
> line 61. at /usr/share/perl5/Catalyst/Model/DBIC/Schema.pm line
> 526#012)" LOG=""
>
> Regards,
>
> Henk
>
> On 1-12-2017 12:19, Irina Peshinskaya wrote:
>>
>> Dear Henk,
>>
>> Just the same as was described yesterday, kindly upgrade your
>> ngcp-panel to the 5.5.1.5:
>>
>> apt-get update
>> apt-get install ngcp-panel
>> ngcpcfg apply 'commit mesasge'
>>
>> or better update to latest hotfixes:
>>
>> apt-get update && apt-get upgrade && \
>> ngcp-update-db-schema && ngcp-update-cfg-schema && \
>> ngcpcfg apply 'commit message'
>>
>> Best regards,
>>
>> Irina Peshinskaya
>>
>>
>> On 01.12.2017 13:14, Henk wrote:
>>>
>>> Hi all,
>>>
>>> I'm on the latest version mr5.5.1 and cannot generate invoices
>>> anymore. In panel.log I get the following message:
>>>
>>> MSG="Failed to create invoice .... Unknown column
>>> 'me.source_cli_suppression_id' in 'field list' [for Statement
>>> "SELECT `me`.`source_user`, `me`.`source_domain`, `me`.`source_cli`,
>>> `me`.`destination_user_in`, `me`.`source_cli_suppression_id`,
>>> `me`.`destination_user_in_suppression_id`, `me`.`start_time`,
>>> `me`.`duration`, `me`.`call_type`, `me`.`source_customer_cost`,
>>> `source_customer_billing_zones_history`.`zone`,
>>> `source_customer_billing_zones_history`.`detail` FROM
>>> `accounting`.`cdr` `me` LEFT JOIN `billing`.`billing_zones_history`
>>> `source_customer_billing_zones_history` ON
>>> `source_customer_billing_zones_history`.`id` =
>>> `me`.`source_customer_billing_zone_id` WHERE ( ( `call_status` = ?
>>> AND `source_account_id` = ? AND `source_user_id` != ? AND (
>>> `start_time` >= ? AND `start_time` <= ? ) ) ) ORDER BY `start_time`"
>>> with ParamValues: 0='ok', 1="26", 2='0', 3=1509494400, 4=1512086399]
>>> at /usr/share/perl5/NGCP/Panel/Utils/Invoice.pm line 84#012)" LOG=""
>>>
>>> My current DB version is 15367. Did I miss a part of the DB upgrade?
>>>
>>> Regards,
>>>
>>> Henk Plessius
>>>
>>>
>>>
>>> _______________________________________________
>>> Spce-user mailing list
>>> Spce-user at lists.sipwise.com
>>> https://lists.sipwise.com/listinfo/spce-user
>>
>
>
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20171202/7ebf6b75/attachment-0001.html>
More information about the Spce-user
mailing list