[Spce-user] Error in rate-o-mat because no contract balance has been added

[Mario Contreras]

Hi again,

That's what I think looks bad. I have 250 accounts:
select count(*) from contracts;
+----------+
| count(*) |
+----------+
|      249 |
+----------+

But there is only 9 rows of july in contract_balances:
select * from contract_balances order by end desc limit 10;
+------+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
| id   | contract_id | cash_balance | cash_balance_interval | 
free_time_balance | free_time_balance_interval | start               | 
end                 | invoice_id |
+------+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
| 1920 |          58 |            0 |                     0 
|                 0 |                          0 | 2013-07-01 00:00:00 | 
2013-07-31 23:59:59 |       NULL |
| 1921 |         288 |            0 |                     0 
|             30456 |                          0 | 2013-07-01 00:00:00 | 
2013-07-31 23:59:59 |       NULL |
| 1922 |         292 |            0 |                     0 
|             30576 |                          8 | 2013-07-01 00:00:00 | 
2013-07-31 23:59:59 |       NULL |
| 1923 |           3 |            0 |          0.1039999972 |            
180000 |                          0 | 2013-07-01 00:00:00 | 2013-07-31 
23:59:59 |       NULL |
| 1924 |          70 |            0 |                     0 
|                 0 |                          0 | 2013-07-01 00:00:00 | 
2013-07-31 23:59:59 |       NULL |
| 1925 |           7 |            0 |                     0 |            
180000 |                          0 | 2013-07-01 00:00:00 | 2013-07-31 
23:59:59 |       NULL |
| 1926 |         257 |            0 |                     0 
|             30822 |                          0 | 2013-07-01 00:00:00 | 
2013-07-31 23:59:59 |       NULL |
| 1927 |         326 |            0 |                     0 
|             29032 |                          0 | 2013-07-01 00:00:00 | 
2013-07-31 23:59:59 |       NULL |
| 1701 |          58 |            0 |                     0 
|                 0 |                          0 | 2013-06-01 00:00:00 | 
2013-06-30 23:59:59 |       NULL |
| 1702 |         131 |            0 |                     0 
|             22295 |                      16219 | 2013-06-01 00:00:00 | 
2013-06-30 23:59:59 |       NULL |
+------+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+

IMHO, it shoudn't look like this, right?


El 02/07/2013 16:20, Daniel Grotti escribió:
> Hi Mario,
>
> please check your contracts_balance table for that account.
> Everything should look fine.
> The error come in when your subscriber made the call just after few
> minutes after the new billing period (in this case few minutes after
> midnight of July 1st).
>
> So probably CDR 524366 is related to a call made few minutes after midnight.
>
>
> Daniel
>
>
>
> On 07/02/2013 04:11 PM, Mario Contreras wrote:
>> Hi Daniel,
>>
>> Thanks for your answer. Anyway, it has nothing to do with the calls,
>> right? I mean, the contract balances should be created in
>> contract_balances table. Correct me if I'm wrong, maybe I haven't
>> understood you correctly.
>>
>> Cheers!
>>
>> El 02/07/2013 15:19, Daniel Grotti escribió:
>>> Hi Mario,
>>>
>>> There is an issue in rate-o-mat when the period could not be matched for
>>> the particular call.
>>> It will be fixed in the next package update.
>>>
>>> Daniel
>>>
>>>
>>>
>>> On 07/02/2013 11:47 AM, Mario Contreras wrote:
>>>> Hi all!
>>>>
>>>> Since yesterday I'm experiencing this issue:
>>>> Error rating CDR batch: No contract balance for CDR 524366 found
>>>>
>>>> I have seen that this month most of contract balances haven't been
>>>> created. I've searched the script that does this job, but I can't find
>>>> it... Have you experienced this?
>>>>
>>>> Thanks in advance!
>>>>
>>>> _______________________________________________
>>>> Spce-user mailing list
>>>> Spce-user at lists.sipwise.com
>>>> http://lists.sipwise.com/listinfo/spce-user
>>> _______________________________________________
>>> Spce-user mailing list
>>> Spce-user at lists.sipwise.com
>>> http://lists.sipwise.com/listinfo/spce-user