[Spce-user] billing issues in a development environment

[Andreas Granig]

Hi,

On 03/27/2012 03:23 PM, Joan Cifre (ibred) wrote:
> - The billing system stops (rate-o-mat stopped) not only when there is
> no match, but also when there is a match. The problem could be that we
> have many fees (more than 10 thousand). When I have a "all-matches" rule
> (^.\*$) at the begginning there is no problem, but when the rule to
> match is not at the start of the list, the system does not found it and
> rate-o-mat is stopped

The correct rule is actually without quoting the star, like "^.*$".

In any case, it really doesn't matter at which place you put the
catch-all rule, because rate-o-mat re-orders it internally when trying
to find a matching rule anyways.

Can you show one db entry of such a billing fee (from mysql db
"billing.billing_fees") where you expect a match (you can of course set
the rate values to 0 for privacy reasons)? Maybe your destination colum
is not as expected

One other typical error we encounter with people new to the platform is
when you see such a message in /var/log/ngcp/cdr.log:

Error rating CDR batch: No contract id found for uuid
'f13c07a9-639b-45f3-be4b-915646bebac5'

This usually comes from the fact that an account is deleted before all
CDRs have been rated for all subscribers of this account (either via
SOAP or in the Admin Panel). The correct approach for disabling a
subscriber immediately is "terminating" a subscriber (that is, clicking
the x-Button in the subscriber's master data), and only later on (once
you're sure all CDRs are rated) really delete the account.
The reason for that is that when you completely delete an account,
you're not able to bill this customer anymore, whereas when you
terminate the subscribers of this account, they can't use it anymore,
but you're still able to rate/bill calls.

Andreas

Andreas

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 900 bytes
Desc: OpenPGP digital signature
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20120327/94184820/attachment-0001.asc>