[Spce-user] Error in rate-o-mate

Raul Alonso raul.alonso at tpartner.net
Tue Nov 26 04:42:45 EST 2013


hello,

 

I have a problem with the rate-o-mate, when I start it returns the following
error, and I can not see the problem:

 

rate-o-mat.log

Nov 26 10:16:05 sipproxy01 rate-o-mat[3604]: rate cdr #7102

Nov 26 10:16:05 sipproxy01 rate-o-mat[3604]: Error executing update cdr
statement: Out of range value for column 'source_carrier_cost' at row 1

Nov 26 10:16:05 sipproxy01 rate-o-mat[3604]: Caught DBI:err 1264

Nov 26 10:16:05 sipproxy01 rate-o-mat[3604]: Error rating CDR batch:

 

mysql> select * from cdr where id='7102'\G

*************************** 1. row ***************************

                                  id: 7102

                         update_time: 2013-11-16 20:32:21

                      source_user_id: 0ec7435f-1548-43eb-8721-XXXXXXXX

                  source_provider_id: 1

       source_external_subscriber_id: user

         source_external_contract_id: user

                   source_account_id: 18

                         source_user: user

                       source_domain: user.domain.net

                          source_cli: 349XXXXXXX

                         source_clir: 0

                           source_ip: 188.XX.XX.XX

                 destination_user_id: 0

             destination_provider_id: 4

  destination_external_subscriber_id:

    destination_external_contract_id:

              destination_account_id: 0

                    destination_user: 686XXXXX

                  destination_domain: 21.XX.XX.XX

             destination_user_dialed: 686XXXXXX

                 destination_user_in: 686XXXXXX

               destination_domain_in: user.domain.net

                      peer_auth_user:

                     peer_auth_realm:

                           call_type: call

                         call_status: ok

                           call_code: 200

                           init_time: 1384630010.184

                          start_time: 1384630019.870

                            duration: 314.940

                             call_id: 28eff98d-55b72c95 at 192.168.2.10

                 source_carrier_cost: 0.00

                source_reseller_cost: 0.00

                source_customer_cost: 0.00

            source_carrier_free_time: NULL

           source_reseller_free_time: NULL

           source_customer_free_time: NULL

       source_carrier_billing_fee_id: NULL

      source_reseller_billing_fee_id: NULL

      source_customer_billing_fee_id: NULL

      source_carrier_billing_zone_id: NULL

     source_reseller_billing_zone_id: NULL

     source_customer_billing_zone_id: NULL

            destination_carrier_cost: 0.00

           destination_reseller_cost: 0.00

           destination_customer_cost: 0.00

       destination_carrier_free_time: NULL

      destination_reseller_free_time: NULL

      destination_customer_free_time: NULL

  destination_carrier_billing_fee_id: NULL

destination_reseller_billing_fee_id: NULL

destination_customer_billing_fee_id: NULL

destination_carrier_billing_zone_id: NULL

destination_reseller_billing_zone_id: NULL

destination_customer_billing_zone_id: NULL

                 frag_carrier_onpeak: NULL

                frag_reseller_onpeak: NULL

                frag_customer_onpeak: NULL

                       is_fragmented: NULL

                               split: 0

                            rated_at: NULL

                       rating_status: unrated

                         exported_at: NULL

                       export_status: unexported

1 row in set (0.00 sec)

 

 

Regrads,

Raúl Alonso

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20131126/693b80a9/attachment.html>


More information about the Spce-user mailing list