[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