[Spce-user] Problem with billing fees

[Sergio Serrano]

Previous version was 4.4.2. The ouput for the command is

mysql ngcp <<< 'select id,revision,applied_at from db_schema order byid
desc limit 1;'                                                         
id      revision        applied_at                       
485     15311   2017-01-26 15:56:11


regards,

SergioEl jue, 26-01-2017 a las 19:38 +0200, Irina Peshinskaya escribió:
> Dear Sergio,
> What was previous version of your system?
> Could you please share output of the:
>  mysql ngcp <<< 'select id,revision,applied_at from db_schema order
> by id desc limit 1;'
> 
> ?
> 
> Best regards,
> Irina Peshinskaya
> 
> On 26.01.2017 17:43, Sergio Serrano wrote:
> > Hi all,
> > 
> > 	after we upgradeto 4.5.3 all work fine, but when I try to
> > change billing fees system throw next error in panel.log:
> > 
> > Jan 26 16:37:20 sipwise ngcp-panel: ERROR: IP=87.220.105.140
> > CALLED=Controller::Billing::fees_upload TX=149D5C64D49BB170
> > USER=administrator DATA={ 'upload_fees' => 'billing_fees_1.txt',
> > 'purge_existing' => '1', 'submitid' => '', 'save' => 'Upload'}
> > MSG="Failed to upload Billing Fees ({UNKNOWN}: DBI Exception:
> > DBD::mysql::db do failed: PROCEDURE billing.fill_billing_fees does
> > not exist [for Statement "call billing.fill_billing_fees(?)"] at
> > /usr/share/perl5/NGCP/Panel/Utils/Billing.pm line 268#012)" LOG=""
> > 
> > I had downloaded actual fees, replace an try to upload. If I try to
> > add fee manually, I obtain a 
> > 
> > Sorry!
> > 500 Internal server error
> > We are terribly sorry, an exceptional error has occured:
> > incident number: 149D5CA208E6EA20
> > time of incident: 2017-01-26T15:41:43.105940000Z
> > 
> > Details have been logged on the server. If you want to report the
> > error, describe what you were doing or attempting to do just
> > before.
> > 
> > and in panel.log I have seen
> > 
> > Jan 26 16:41:43 sipwise ngcp-panel: ERROR: fatal error,
> > id=149D5CA208E6EA20, timestamp=2017-01-26T15:41:43.105940000Z,
> > error={UNKNOWN}: DBI Exception: DBD::mysql::db do failed: PROCEDURE
> > billing.fill_billing_fees does not exist [for Statement "call
> > billing.fill_billing_fees(?)"] at
> > /usr/share/perl5/NGCP/Panel/Utils/Billing.pm line 268
> > 
> > Are there any bug in reltaion with billing fees in 4.5.3?
> > 
> > regards,
> > 
> > Sergio
> > 
> > 
> > _______________________________________________
> > Spce-user mailing list
> > Spce-user at lists.sipwise.com
> > https://lists.sipwise.com/listinfo/spce-user
>  
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 213 bytes
Desc: This is a digitally signed message part
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20170126/07687bcc/attachment-0001.asc>