[Spce-user] Fraud limit wrong calculation

[Jon Bonilla (Manwe)]

Hi all

I'm having a problem with a 3.8.8 setup lately. I'm receiving fraud limit mails
regarding accounts being locked. Example:

***

Account ID 29 has been locked due to exceeding the configured
credit balance threshold (158.40 >= 150.00 ) in the billing profile

Affected subscribers:
    ab0115 at domain.com (external ID '0442A')
    ab0116 at domain.com (external ID '0442B') 

****

But if I check the curren balance of account 29:

mysql> select sum(source_customer_cost)/100 from cdr where source_account_id=29
mysql> and update_time > "2016-11-01 00:00:00";
+-------------------------------+
| sum(source_customer_cost)/100 |
+-------------------------------+
|                 85.9175357000 |
+-------------------------------+

The ngcp-panel also shows same amount as the db.

150 was the daily limit and 600 is the monthly one.


any hints?


thanks,

Jon
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 833 bytes
Desc: Firma digital OpenPGP
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20161130/a5643fd7/attachment.sig>