[Spce-user] Error generating invoice

[Rene Krenn]

Thx, so is it correct you are or have been using billing packages for this customer contract? Would you like to send results for

 

  select start,end from billing.contract_balances where contract_id=<that contractId> order by id desc;

 

and

 

  select * from billing.contracts where id = <that contractId>;

 

(won‘t expose any sensitive data) 

 

regards

 

Von: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] Im Auftrag von Henk
Gesendet: Montag, 4. Dezember 2017 20:26
An: spce-user at lists.sipwise.com
Betreff: Re: [Spce-user] Error generating invoice

 

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 <mailto: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 <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/f43c6a65/attachment-0001.html>