[Spce-user] Exception Error on trying to add new billing fee - NGCP-Panel Incident

William Hilsum William at ezpcltd.com
Mon Apr 11 06:06:32 EDT 2016

Whoops - I thought I was replying to the group, but sent direct... Making a few modifications though...


Thanks - I am using mr4.2.1

I had a look at that folder already, but, stupidly, I didn't know what file to look at, I just did grep on everything looking for the incident number and found the following:

panel.log:Apr 11 11:08:38 testpbx1 (local0.err) ngcp-panel: ERROR: fatal error, id=144442E2257A56A0, timestamp=2016-04-11T09:08:38.233700000Z, error={UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry '2' for key 'PRIMARY' [for Statement "call billing.fill_billing_fees(?)"] at /usr/share/perl5/NGCP/Panel/Utils/Billing.pm line 109

I don't get why it isn't auto incrementing the primary key here.

As per the email I got back, I can confirm that I have never touched the database or done anything like that.

The direct series of events that lead to this were:

1. The system was being used like normal.
2. Created a new reseller, with a new blank billing plan.
3. I tried updating the billing plan a week later, but, I noticed that in call history, the column that lists the zone was just blank - I couldn't understand why (I have never used billing before, hence previous question).
4. rate-o-mat.log was blank. Thinking there was an error, I rebooted the system.
5. I saw the error in rate-o-mat.log that there was a no match, realising there was no default plan in place for the new reseller, I created this rule and issues "service ngcp-rate-o-mat start"
6. It rated the last week of calls, and all appeared to be working ok.
7. Attempted to create a new fee on any billing plan - I get the error as indicated above.
8. I can create new billing zones fine, just not fees.

But at no point, have I edited the database... I do however want to reset it so that it rerates the last week (after seeing a recommendation in another topic), but, I can live without that if it will cause more trouble than good.


-----Original Message-----
From: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] On Behalf Of Alex Lutay
Sent: 11 April 2016 10:05
To: spce-user at lists.sipwise.com
Subject: Re: [Spce-user] Exception Error on trying to add new billing fee - NGCP-Panel Incident

Dear William,

Please always provide the release version you have.

All logs are located in /var/log/ngcp/ .
As for latest releases you need to check panel.log panel-debug.log and api.log if REST API is involved.

On 04/10/2016 11:24 PM, William Hilsum wrote:
> It says I can submit an error report, but, where are these errors 
> located on the server?

Alex Lutay

Meet us @ ANGACOM: Hall 10.1 / booth N10 Exhibition and Congress for Broadband, Cable & Satellite: 07 - 09 June, 2016 in Cologne _______________________________________________
Spce-user mailing list
Spce-user at lists.sipwise.com

More information about the Spce-user mailing list