<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Rene,</p>
<p>I have been using them just as an experiment and all that was
left over was the balance period not starting at the beginning of
the month. I changed the dates in records 453 and 519. I'm not
sure when the problem started, I started with a 4.x version.<br>
</p>
<p><font size="-2"><tt>| 372 | 2017-02-13 03:00:00 | 2017-02-13
03:59:59 |<br>
| 373 | 2017-02-13 04:00:00 | 2017-02-13 04:59:59 |<br>
| 374 | 2017-02-13 05:00:00 | 2017-02-13 05:59:59 |<br>
| 375 | 2017-02-13 06:00:00 | 2017-02-13 06:59:59 |<br>
| 376 | 2017-02-13 07:00:00 | 2017-02-13 07:59:59 |<br>
| 377 | 2017-02-13 08:00:00 | 2017-02-13 08:59:59 |<br>
| 378 | 2017-02-13 09:00:00 | 2017-02-13 09:59:59 |<br>
| 379 | 2017-02-13 10:00:00 | 2017-02-13 10:59:59 |<br>
| 380 | 2017-02-13 11:00:00 | 2017-03-13 10:59:59 |<br>
| 389 | 2017-03-13 11:00:00 | 2017-04-13 10:59:59 |<br>
| 399 | 2017-04-13 11:00:00 | 2017-05-13 10:59:59 |<br>
| 409 | 2017-05-13 11:00:00 | 2017-06-13 10:59:59 |<br>
| 417 | 2017-06-13 11:00:00 | 2017-07-13 10:59:59 |<br>
| 426 | 2017-07-13 11:00:00 | 2017-08-13 10:59:59 |<br>
| 433 | 2017-08-13 11:00:00 | 2017-09-13 10:59:59 |<br>
| 442 | 2017-09-13 11:00:00 | 2017-10-13 10:59:59 |<br>
| 453 | 2017-10-13 11:00:00 | 2017-10-31 23:59:59 |<br>
| 519 | 2017-11-01 00:00:00 | 2017-11-30 23:59:59 |<br>
| 542 | 2017-12-01 00:00:00 | 2017-12-31 23:59:59 |<br>
+-----+---------------------+---------------------+<br>
</tt></font></p>
<p>Best regards,</p>
<p>Henk Plessius<br>
</p>
<br>
<div class="moz-cite-prefix">On 4-12-2017 22:12, Rene Krenn wrote:<br>
</div>
<blockquote type="cite"
cite="mid:00fe01d36d44$9d78f4f0$d86aded0$@sipwise.com">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
tt
{mso-style-priority:99;
font-family:"Courier New";}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;
color:black;}
span.E-MailFormatvorlage21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.E-MailFormatvorlage22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Thx,
so is it correct you are or have been using billing packages
for this customer contract? Would you like to send results
for<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">
select start,end from billing.contract_balances where
contract_id=<that contractId> order by id desc;<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">and<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">
select * from billing.contracts where id = <that
contractId>;<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">(won‘t
expose any sensitive data) <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">regards<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext"
lang="DE">Von:</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext"
lang="DE"> Spce-user
[<a class="moz-txt-link-freetext" href="mailto:spce-user-bounces@lists.sipwise.com">mailto:spce-user-bounces@lists.sipwise.com</a>] <b>Im
Auftrag von </b>Henk<br>
<b>Gesendet:</b> Montag, 4. Dezember 2017 20:26<br>
<b>An:</b> <a class="moz-txt-link-abbreviated" href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a><br>
<b>Betreff:</b> Re: [Spce-user] Error generating invoice<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p>Hi Rene,<o:p></o:p></p>
<p>An update on my last email, it's working now! I changed the
dates to begin/end of month and then generate the invoice for
December first. After that I can generate November too. So
fixed for now, but it looks like it is caused by not using a
monthly period (in the past).<o:p></o:p></p>
<p>Regards,<o:p></o:p></p>
<p>Henk Plessius<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On 4-12-2017 19:54, Henk wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p>Hi Rene,<o:p></o:p></p>
<p>Thank you for the research. I'm entering a valid invoice
period, just 11-2017 with a customer that is active for 1
year. I have found that at least two of the customers with
failing invoices have an interval that is not from 1st to
last of the month, so for example contract balance runs from
2017-11-13 11:00:00 to 2017-12-13 10:59:59. But after I
changed the interval in billing.contract_balances to the
start and end of month, I have still the same error.<o:p></o:p></p>
<p>Regards,<o:p></o:p></p>
<p>Henk Plessius<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On 4-12-2017 16:24, Rene Krenn wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">hello
Henk,</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">thanks
for pointing to this. I was able to reproduce the exact
same message, but only if i was trying to enter an
invoice period (month+year) when that customer contract
was not created yet. Can you check if this was also the
case in your situation?</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">regards,
rene</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext"
lang="DE">Von:</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext"
lang="DE"> Spce-user [<a
href="mailto:spce-user-bounces@lists.sipwise.com"
moz-do-not-send="true">mailto:spce-user-bounces@lists.sipwise.com</a>]
<b>Im Auftrag von </b>Henk<br>
<b>Gesendet:</b> Freitag, 1. Dezember 2017 13:25<br>
<b>An:</b> <a
href="mailto:spce-user@lists.sipwise.com"
moz-do-not-send="true">spce-user@lists.sipwise.com</a><br>
<b>Betreff:</b> Re: [Spce-user] Error generating
invoice</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p>Hi Irina,<o:p></o:p></p>
<p>Sorry I missed that. Now the first invoice works, but the
second has another error:<o:p></o:p></p>
<p><tt><span style="font-size:10.0pt">MSG="Failed to create
invoice ({UNKNOWN}: Can't call method "start" on an
undefined value at
/usr/share/perl5/NGCP/Panel/Utils/Invoice.pm line 61.
at /usr/share/perl5/Catalyst/Model/DBIC/Schema.pm line
526#012)" LOG=""</span></tt><o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Regards,<br>
<br>
Henk<o:p></o:p></p>
<div>
<p class="MsoNormal">On 1-12-2017 12:19, Irina Peshinskaya
wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p>Dear Henk,<o:p></o:p></p>
<p>Just the same as was described yesterday, kindly
upgrade your ngcp-panel to the 5.5.1.5:<o:p></o:p></p>
<pre> apt-get update<o:p></o:p></pre>
<pre> apt-get install ngcp-panel<o:p></o:p></pre>
<pre> ngcpcfg apply 'commit mesasge'<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre> or better update to latest hotfixes:<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre> apt-get update && apt-get upgrade && \<o:p></o:p></pre>
<pre> ngcp-update-db-schema && ngcp-update-cfg-schema && \<o:p></o:p></pre>
<pre> ngcpcfg apply 'commit message'<o:p></o:p></pre>
<p>Best regards,<o:p></o:p></p>
<p>Irina Peshinskaya<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal">On 01.12.2017 13:14, Henk wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p>Hi all,<o:p></o:p></p>
<p>I'm on the latest version mr5.5.1 and cannot generate
invoices anymore. In panel.log I get the following
message:<o:p></o:p></p>
<p><tt><span style="font-size:10.0pt">MSG="Failed to
create invoice .... Unknown column
'me.source_cli_suppression_id' in 'field list'
[for Statement "SELECT `me`.`source_user`,
`me`.`source_domain`, `me`.`source_cli`,
`me`.`destination_user_in`,
`me`.`source_cli_suppression_id`,
`me`.`destination_user_in_suppression_id`,
`me`.`start_time`, `me`.`duration`,
`me`.`call_type`, `me`.`source_customer_cost`,
`source_customer_billing_zones_history`.`zone`,
`source_customer_billing_zones_history`.`detail`
FROM `accounting`.`cdr` `me` LEFT JOIN
`billing`.`billing_zones_history`
`source_customer_billing_zones_history` ON
`source_customer_billing_zones_history`.`id` =
`me`.`source_customer_billing_zone_id` WHERE ( (
`call_status` = ? AND `source_account_id` = ? AND
`source_user_id` != ? AND ( `start_time` >= ?
AND `start_time` <= ? ) ) ) ORDER BY
`start_time`" with ParamValues: 0='ok', 1="26",
2='0', 3=1509494400, 4=1512086399] at
/usr/share/perl5/NGCP/Panel/Utils/Invoice.pm line
84#012)" LOG=""</span></tt><o:p></o:p></p>
<p>My current DB version is 15367. Did I miss a part of
the DB upgrade?<o:p></o:p></p>
<p>Regards,<o:p></o:p></p>
<p>Henk Plessius<o:p></o:p></p>
<p class="MsoNormal"><br>
<br>
<br>
<br>
<o:p></o:p></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Spce-user mailing list<o:p></o:p></pre>
<pre><a href="mailto:Spce-user@lists.sipwise.com" moz-do-not-send="true">Spce-user@lists.sipwise.com</a><o:p></o:p></pre>
<pre><a href="https://lists.sipwise.com/listinfo/spce-user" moz-do-not-send="true">https://lists.sipwise.com/listinfo/spce-user</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"> <o:p></o:p></p>
</blockquote>
<p class="MsoNormal"> <o:p></o:p></p>
</blockquote>
<p class="MsoNormal"><br>
<br>
<br>
<br>
<o:p></o:p></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Spce-user mailing list<o:p></o:p></pre>
<pre><a href="mailto:Spce-user@lists.sipwise.com" moz-do-not-send="true">Spce-user@lists.sipwise.com</a><o:p></o:p></pre>
<pre><a href="https://lists.sipwise.com/listinfo/spce-user" moz-do-not-send="true">https://lists.sipwise.com/listinfo/spce-user</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</blockquote>
<br>
</body>
</html>