[Spce-user] Unable to creat large invoices
Koot Pienaar
koot at ntelecom.co.za
Thu Oct 12 04:36:42 EDT 2017
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: <mailto:koot at ntelecom.co.za> koot at ntelecom.co.za
Website: <http://www.ntelecom.co.za/> www.ntelecom.co.za
Description: Description: Description: Description: Description:
Description: Description: Description: cid:image003.png at 01CFA5C0.7BBDE4A0
<https://twitter.com/ntel_koot> Description: Description: images (1)
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
<mailto:koot at ntelecom.co.za> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20171012/f5591eee/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 40413 bytes
Desc: not available
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20171012/f5591eee/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 2163 bytes
Desc: not available
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20171012/f5591eee/attachment.jpg>
More information about the Spce-user
mailing list