[Spce-user] no contract balance

[Martin Stix]

Hi!

Added dummy line, now ok:

insert into contract_balances VALUES(NULL,*contract_id*,0,0,0,0,’2013-10-01 00:00:00′,’2014-12-01 00:00:00′,NULL);

regards


mit freundlichen Grüßen
best regards
Martin Stix
CEO
pluteus communication solutions
ms at pluteus.at<mailto:ms at pluteus.at>
www.pluteus.at
Dampfsägestraße 17
3300 Amstetten
Austria
tel.: +43 7472 28165 20
fax.: +43 7472 28165 22

Von: Daniel Grotti [mailto:dgrotti at sipwise.com]
Gesendet: Montag, 07. Juli 2014 10:38
An: spce-user at lists.sipwise.com
Betreff: Re: [Spce-user] no contract balance

Hi Martin,
looks like you have an issue on your Contract id 1.
You are missing contract balance. Please check the billing.contract_balances for that account.

If you do not care about that, you can set the CDR field "rating_status" to "ok", so rate-o-mate will skip it.

Daniel




On 07/07/2014 10:31 AM, Martin Stix wrote:
Hi!


Maybe I could delete something in mysql itself?

root at spce:~# rate-o-mat: Error rating CDR batch: No contract balance for contract id 1 starting earlier than '1404311099.45' found

Thanks


mit freundlichen Grüßen
best regards
Martin Stix
CEO
pluteus communication solutions
ms at pluteus.at<mailto:ms at pluteus.at>
www.pluteus.at<http://www.pluteus.at>
Dampfsägestraße 17
3300 Amstetten
Austria
tel.: +43 7472 28165 20
fax.: +43 7472 28165 22

Von: Martin Stix
Gesendet: Freitag, 04. Juli 2014 11:21
An: Martin Stix; Spce-user at lists.sipwise.com<mailto:Spce-user at lists.sipwise.com>
Betreff: AW: [Spce-user] no contract balance

Hi!

Anyone any idea?

Thanks


mit freundlichen Grüßen
best regards
Martin Stix
CEO
pluteus communication solutions
ms at pluteus.at<mailto:ms at pluteus.at>
www.pluteus.at<http://www.pluteus.at>
Dampfsägestraße 17
3300 Amstetten
Austria
tel.: +43 7472 28165 20
fax.: +43 7472 28165 22

Von: Martin Stix [mailto:ms at pluteus.at]
Gesendet: Donnerstag, 03. Juli 2014 16:50
An: Spce-user at lists.sipwise.com<mailto:Spce-user at lists.sipwise.com>
Betreff: [Spce-user] no contract balance

Hi!

Completely new message form e:

root at spce:~# rate-o-mat: Error rating CDR batch: No contract balance for contract id 1 starting earlier than '1404311099.45' found

sorry if already asked….

regrads


mit freundlichen Grüßen
best regards
Martin Stix
CEO
pluteus communication solutions
ms at pluteus.at<mailto:ms at pluteus.at>
www.pluteus.at<http://www.pluteus.at>
Dampfsägestraße 17
3300 Amstetten
Austria
tel.: +43 7472 28165 20
fax.: +43 7472 28165 22





_______________________________________________

Spce-user mailing list

Spce-user at lists.sipwise.com<mailto:Spce-user at lists.sipwise.com>

http://lists.sipwise.com/listinfo/spce-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20140707/380b0dbb/attachment-0001.html>