<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Rene,</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.</p>
<p>Regards,</p>
<p>Henk Plessius<br>
</p>
<br>
<div class="moz-cite-prefix">On 4-12-2017 16:24, Rene Krenn wrote:<br>
</div>
<blockquote type="cite"
cite="mid:009a01d36d13$fc5a9f40$f50fddc0$@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",serif;
color:black;}
span.E-MailFormatvorlage21
{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">hello
Henk,<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">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?<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,
rene<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> Freitag, 1. Dezember 2017 13:25<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 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>
<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>
</div>
</blockquote>
<br>
</body>
</html>