[Spce-user] Problem with billing fees

[Sergio Serrano]

Thanks Ireina, here you have the output:

mysql ngcp <<< 'select id,revision,applied_at from db_schema where
revision like
"%15176%";'                                                            
                                                                       
                               
id      revision        applied_at
389     15176   2016-10-18 01:06:44

Regards,
-- 
Sergio Serrano Revuelto
CTO
-
C/ Marie Curie 20, Planta 1ª Derecha
29590 Campanillas - MALAGA
Teléfono: 952028709
Fax: 951010922
email: sergio.serrano at avanzada7.com
web: http://www.avanzada7.com





El vie, 27-01-2017 a las 09:41 +0200, Irina Peshinskaya escribió:
> Dear Sergio,
> 
> Thank you. But I see what I didn't expected - the script, where 
> "fill_billing_fees" procedure defined should be created, according
> to 
> your log.
> 
> Let me check more exactly:
> 
> mysql ngcp <<< 'select id,revision,applied_at from db_schema where 
> revision like "%15176%";'
> 
> Could you please share the output of this too?
> 
> Thanks in advance.
> 
> Best regards,
> Irina Peshinskaya
> 
> On 26.01.2017 21:24, Sergio Serrano wrote:
> > 
> > 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/20170127/17c42b8b/attachment-0001.asc>