[Spce-user] Problem with billing fees

[Irina Peshinskaya]

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 --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20170126/3dcb2aeb/attachment-0001.html>