[Spce-user] Error generating invoice

[Rene Krenn]

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

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20171204/4dddd693/attachment-0001.html>