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

[Joel S. | VOZELIA]

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