[Spce-user] Unable to creat large invoices

[Irina Peshinskaya]

Dear Koot,

Could you please remind me your ngcp-panel version?
All concatenations I see in the Invoice.pm are too far from line 169.

Thanks in advance.

Best regards,
Irina Peshinskaya

On 12.10.2017 11:36, Koot Pienaar wrote:
>
> Hi Team
>
> I get the following error in panel.log when generating invoices with 
> large amounts of calls.
>
> Oct 12 10:28:20 ntel-sipsw1 ngcp-panel: ERROR: IP=2.1.1.86 
> CALLED=Controller::Invoice::__ANON__ TX=14ECC54ADC9EF410 
> USER=administrator DATA={ 'template.id' => '2', 'period' => '2017-09', 
> 'submitid' => '', 'contract.id' => '15', 'save' => 'Save'} MSG="Failed 
> to save invoice meta data. (DBIx::Class::Storage::DBI::_dbh_execute(): 
> DBI Exception: DBD::mysql::st execute failed: MySQL server has gone 
> away [for Statement "INSERT INTO `billing`.`invoices` ( `amount_net`, 
> `amount_total`, `amount_vat`, `contract_id`, `data`, `period_end`, 
> `period_start`, `serial`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? )" with 
> ParamValues: 0=5923.9, 1=6753.25, 2=829.346, 3="15", 4=undef, 
> 5='2017-09-30 23:59:59', 6='2017-09-01 00:00:00', 
> 7='tmp150779690053912'] at 
> /usr/share/perl5/NGCP/Panel/Controller/Invoice.pm line 290#012)" LOG=""
>
> Oct 12 10:28:20 ntel-sipsw1 ngcp-panel: ERROR: IP=2.1.1.86 
> CALLED=Controller::Invoice::create TX=14ECC54AE303C380 
> USER=administrator DATA={ 'submitid' => '', 'contract.id' => '15', 
> 'save' => 'Save', 'template.id' => '2', 'period' => '2017-09'} 
> MSG="Failed to create invoice. ({UNKNOWN}: Use of uninitialized value 
> $contract_id in concatenation (.) or string at 
> /usr/share/perl5/NGCP/Panel/Controller/Invoice.pm line 169. at 
> /usr/share/perl5/Catalyst/Model/DBIC/Schema.pm line 526#012)" LOG=""
>
> I do not see any logs in Mysql.log or mysql.err
>
> Koot Pienaar
>
> VoIP Coordinator
>
> Ntelecom Central
>
> Tel: 051 412 6300
>
> Email: koot at ntelecom.co.za <mailto:koot at ntelecom.co.za>
>
> Website: www.ntelecom.co.za <http://www.ntelecom.co.za/>
>
> Description: Description: Description: Description: Description: 
> Description: Description: Description: cid:image003.png at 01CFA5C0.7BBDE4A0
>
> Description: Description: images (1) <https://twitter.com/ntel_koot>
>
> Confidentiality Notice:
>
> This e-mail may contain confidential information and is intended only 
> for the use of the recipient named above.
>
> Should you receive this e-mail in error, please forward it to 
> koot at ntelecom.co.za <mailto:koot at ntelecom.co.za>  and delete from your 
> in-box.
>
> Any disclosure, copying, distribution or action on the contents of 
> this e-mail is strictly prohibited.
>
> Please consider the environment before printing this email and/or any 
> related attachments.
>
>
>
> _______________________________________________
> 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/20171012/600adda0/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 40413 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20171012/600adda0/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 2163 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20171012/600adda0/attachment-0001.jpe>