[Spce-user] Error generating invoice

[Henk]

Hi Rene,

An update on my last email, it's working now! I changed the dates to 
begin/end of month and then generate the invoice for December first. 
After that I can generate November too. So fixed for now, but it looks 
like it is caused by not using a monthly period (in the past).

Regards,

Henk Plessius


On 4-12-2017 19:54, Henk wrote:
>
> Hi Rene,
>
> Thank you for the research. I'm entering a valid invoice period, just 
> 11-2017 with a customer that is active for 1 year. I have found that 
> at least two of the customers with failing invoices have an interval 
> that is not from 1st to last of the month, so for example contract 
> balance runs from 2017-11-13 11:00:00 to 2017-12-13 10:59:59. But 
> after I changed the interval in billing.contract_balances to the start 
> and end of month, I have still the same error.
>
> Regards,
>
> Henk Plessius
>
>
> On 4-12-2017 16:24, Rene Krenn wrote:
>>
>> hello Henk,
>>
>> thanks for pointing to this. I was able to reproduce the exact same 
>> message, but only if i was trying to enter an invoice period 
>> (month+year) when that customer contract was not created yet. Can you 
>> check if this was also the case in your situation?
>>
>> regards, rene
>>
>> *Von:*Spce-user [mailto:spce-user-bounces at lists.sipwise.com] *Im 
>> Auftrag von *Henk
>> *Gesendet:* Freitag, 1. Dezember 2017 13:25
>> *An:* spce-user at lists.sipwise.com
>> *Betreff:* Re: [Spce-user] Error generating invoice
>>
>> 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 <mailto: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/20171204/541835ab/attachment-0001.html>