<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Rene,</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).</p>
<p>Regards,</p>
<p>Henk Plessius<br>
</p>
<br>
<div class="moz-cite-prefix">On 4-12-2017 19:54, Henk wrote:<br>
</div>
<blockquote type="cite"
cite="mid:6e2816ff-5306-3391-37af-e6f1d04a372f@voipdigit.nl">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<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"
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 class="moz-txt-link-abbreviated"
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<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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Spce-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<a class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
</body>
</html>