[Spce-user] Rate-o-mat can't rate CDRs after terminating subscriber on SPCE mr3.2.1

[Gavin Sweet]

Hi Joel - 
Was that the Id of the user, does his record still exist in the billing db subs table?

If its only a single CDR holding things up, just delete it so that you can re-start rate-o-mat

Cheers
Gavin




> -----Original Message-----
> From: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] On Behalf
> Of Joel S. | VOZELIA
> Sent: 05 September 2014 10:46
> To: Spce-user
> Subject: Re: [Spce-user] Rate-o-mat can't rate CDRs after terminating
> subscriber on SPCE mr3.2.1
> 
> Hi,
> 
> Can anyone tell me where I can start troubleshooting rate-o-mat issues?
> 
> For some strange reason after terminating a subscriber, rating CDRs has
> stopped because Id "1d679354-184b-489d-af9c-d5b188023c94" is not found.
> 
> Any help is well appreciated, at the moment we have our billing system
> stopped :-(
> 
> 
> Best regards,
> Joel.
> 
> 
> ----- Mensaje original -----
> > De: "Joel S. | VOZELIA" <joel at vozelia.com>
> > Para: "Spce-user" <spce-user at lists.sipwise.com>
> > Enviados: Martes, 2 de Septiembre 2014 9:41:07
> > Asunto: Re: Rate-o-mat can't rate CDRs after terminating subscriber
> on SPCE mr3.2.1
> >
> > Hi,
> >
> > Has anyone had a similar problem?
> >
> > BR,
> > Joel.
> >
> > ----- Original Message -----
> > > From: "Joel S. | VOZELIA" <joel at vozelia.com>
> > > To: "Spce-user" <spce-user at lists.sipwise.com>
> > > Sent: Monday, September 1, 2014 10:18:20 AM
> > > Subject: Rate-o-mat can't rate CDRs after terminating subscriber on
> SPCE
> > > mr3.2.1
> > >
> > > Hi,
> > >
> > > We are experiencing problems to rate CDRs after terminating a
> subscriber.
> > >
> > > Our NGCP version:
> > >
> > > root at za-spce1-eu:/var/log/ngcp# cat /etc/ngcp_version
> > > mr3.2.1
> > > root at za-spce1-eu:/var/log/ngcp#
> > >
> > >
> > > We noticed that rate-o-mat was stopped, and after starting it we
> see the
> > > following in the logs:
> > >
> > > root at za-spce1-eu:/var/log/ngcp# cat rate-o-mat.log
> > > Sep  1 09:31:45 spce1 rate-o-mat[16667]: Trying to connect to
> billing db...
> > > Sep  1 09:31:45 spce1 rate-o-mat[16667]: Successfully connected to
> billing
> > > db...
> > > Sep  1 09:31:45 spce1 rate-o-mat[16667]: Trying to connect to
> accounting
> > > db...
> > > Sep  1 09:31:45 spce1 rate-o-mat[16667]: Successfully connected to
> > > accounting
> > > db...
> > > Sep  1 09:31:45 spce1 rate-o-mat[16667]: Up and running.
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396691
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396716
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396690
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396724
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396695
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396701
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396718
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396725
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396733
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396779
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396698
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396710
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396723
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396732
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396692
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396770
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396713
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396762
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396711
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396726
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396764
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396709
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: missing destination
> profile, so we
> > > can't calculate destination_reseller_cost for
> destination_provider_info
> > > $VAR1 = {#012          'contract_id' => '1',#012
>  'profile_id' =>
> > > undef,#012          'class' => 'reseller'#012        };
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396759
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396816
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396717
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396712
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396765
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396696
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396754
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396776
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: rate cdr #5396702
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: Missing
> destination_provider_id
> > > for
> > > destination_user_id 1d679354-184b-489d-af9c-d5b188023c94 in cdr
> #5396702
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: missing destination
> profile, so we
> > > can't calculate destination_reseller_cost for
> destination_provider_info
> > > $VAR1 = {};
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: No contract id found for
> uuid
> > > '1d679354-184b-489d-af9c-d5b188023c94'
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: Error rating CDR batch: No
> > > contract
> > > id found for uuid '1d679354-184b-489d-af9c-d5b188023c94'
> > > root at za-spce1-eu:/var/log/ngcp#
> > >
> > >
> > > Regarding the UUID not found, why is it failing if we did a normal
> > > "terminate" subscriber through the admin panel?
> > >
> > >
> > > Also, what does this error mean? (or is it just a warning?)
> > >
> > > Sep  1 09:31:55 spce1 rate-o-mat[16667]: missing destination
> profile, so we
> > > can't calculate destination_reseller_cost for
> destination_provider_info
> > > $VAR1 = {#012          'contract_id' => '1',#012
>  'profile_id' =>
> > > undef,#012          'class' => 'reseller'#012        };
> > >
> > >
> > > Is there a quick way to get over this?
> > >
> > >
> > > Thanks in advanced.
> > >
> > >
> > > Best regards,
> > > Joel.
> > >
> > >
> >
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
> 
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2014.0.4745 / Virus Database: 4007/8102 - Release Date:
> 08/26/14
> Internal Virus Database is out of date.