[Spce-user] no contract balance

[Daniel Grotti]

Yep.


On 07/07/2014 12:00 PM, Martin Stix wrote:
>
> 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/f6864930/attachment-0001.html>