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

[Joel S. | VOZELIA]

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.
> > 
> > 
>