<div dir="ltr"><div>The count looks the same but the ORDER of the DID that do not appear on the Edit form is different. The BAD did are 17877487645 and 17879057355<br></div><div><br></div><div><br></div><div>mysql> select count(*) from provisioning.voip_dbaliases where subscriber_id=47;</div><div>+----------+</div><div>| count(*) |</div><div>+----------+</div><div>| 85 |</div><div>+----------+</div><div>1 row in set (0.00 sec)</div><div><br></div><div>mysql> select count(*) from billing.voip_numbers where subscriber_id=43;</div><div>+----------+</div><div>| count(*) |</div><div>+----------+</div><div>| 85 |</div><div>+----------+</div><div>1 row in set (0.00 sec)</div><div><br></div><div><div>mysql> select * from billing.voip_numbers where subscriber_id=43;</div><div>+-------+----+-----+---------+-------------+---------------+--------+--------+---------------------+</div><div>| id | cc | ac | sn | reseller_id | subscriber_id | status | ported | list_timestamp |</div><div>+-------+----+-----+---------+-------------+---------------+--------+--------+---------------------+</div><div>| 911 | 1 | 787 | 7052432 | 10 | 43 | active | 0 | 2014-06-17 13:11:32 |</div><div>| 8972 | 1 | 787 | 2687353 | 10 | 43 | active | 0 | 2014-09-23 10:02:44 |</div><div>| 8973 | 1 | 787 | 6524000 | 10 | 43 | active | 0 | 2014-09-23 10:02:44 |</div><div>| 8974 | 1 | 787 | 6524001 | 10 | 43 | active | 0 | 2014-09-23 10:02:44 |</div><div>| 8975 | 1 | 787 | 6524002 | 10 | 43 | active | 0 | 2014-09-23 10:02:44 |</div><div>| 8976 | 1 | 787 | 6524003 | 10 | 43 | active | 0 | 2014-09-23 10:02:44 |</div><div>| 8977 | 1 | 787 | 6524004 | 10 | 43 | active | 0 | 2014-09-23 10:02:44 |</div><div>| 8978 | 1 | 787 | 8054100 | 10 | 43 | active | 0 | 2014-09-23 10:02:44 |</div><div>| 8979 | 1 | 787 | 8346242 | 10 | 43 | active | 0 | 2014-09-23 10:02:44 |</div><div>| 8980 | 1 | 787 | 9354000 | 10 | 43 | active | 0 | 2014-09-23 10:02:44 |</div><div>| 8981 | 1 | 787 | 9354001 | 10 | 43 | active | 0 | 2014-09-23 10:02:44 |</div><div>| 8982 | 1 | 787 | 9354002 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8983 | 1 | 787 | 9354004 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8984 | 1 | 787 | 9350102 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8985 | 1 | 787 | 8492888 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8986 | 1 | 787 | 6525000 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8987 | 1 | 787 | 6525001 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8988 | 1 | 787 | 6525002 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8989 | 1 | 787 | 6525003 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8990 | 1 | 787 | 6524005 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8991 | 1 | 787 | 6524006 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8992 | 1 | 787 | 6524007 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8993 | 1 | 787 | 6524008 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8994 | 1 | 787 | 6524009 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8995 | 1 | 787 | 6525004 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8996 | 1 | 787 | 2968286 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 8997 | 1 | 787 | 2968284 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9004 | 1 | 787 | 9576222 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9006 | 1 | 787 | 9667163 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9007 | 1 | 787 | 9667586 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9008 | 1 | 787 | 9667589 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9009 | 1 | 787 | 9667592 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9011 | 1 | 787 | 9619786 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9012 | 1 | 787 | 9619787 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9013 | 1 | 787 | 9619788 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9014 | 1 | 787 | 9619789 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9015 | 1 | 787 | 7109657 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9016 | 1 | 787 | 6657891 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9017 | 1 | 787 | 6657892 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9018 | 1 | 787 | 7050939 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9019 | 1 | 787 | 7050940 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9020 | 1 | 787 | 7050948 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9021 | 1 | 787 | 7086472 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9022 | 1 | 787 | 7086473 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9023 | 1 | 787 | 9455094 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9024 | 1 | 787 | 9455096 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9025 | 1 | 787 | 9455097 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9026 | 1 | 787 | 9455098 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9028 | 1 | 787 | 7052433 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9030 | 1 | 787 | 7052436 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9031 | 1 | 787 | 7052437 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9032 | 1 | 787 | 7109659 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9033 | 1 | 787 | 7109661 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9034 | 1 | 787 | 7107631 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9035 | 1 | 787 | 7107632 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9036 | 1 | 787 | 9667014 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9037 | 1 | 787 | 9667019 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9038 | 1 | 787 | 9667017 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9039 | 1 | 787 | 9667029 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9040 | 1 | 787 | 3957441 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9041 | 1 | 787 | 9619794 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9042 | 1 | 787 | 9619793 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9043 | 1 | 787 | 7057382 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9044 | 1 | 787 | 7057383 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9045 | 1 | 787 | 2667259 | 10 | 43 | active | 0 | 2014-09-23 10:02:45 |</div><div>| 9514 | 1 | 787 | 9619790 | 10 | 43 | active | 0 | 2014-11-14 14:38:30 |</div><div>| 9610 | 1 | 787 | 7650130 | 10 | 43 | active | 0 | 2015-01-07 11:17:19 |</div><div>| 9611 | 1 | 787 | 7657386 | 10 | 43 | active | 0 | 2015-01-07 11:17:19 |</div><div>| 9612 | 1 | 787 | 7729149 | 10 | 43 | active | 0 | 2015-01-07 11:17:19 |</div><div>| 9755 | 1 | 787 | 7845000 | 10 | 43 | active | 0 | 2015-03-26 10:45:52 |</div><div>| 9758 | 1 | 787 | 7845051 | 10 | 43 | active | 0 | 2015-03-26 16:01:08 |</div><div>| 9780 | 1 | 787 | 7265929 | 10 | 43 | active | 0 | 2015-04-09 13:26:54 |</div><div>| 9781 | 1 | 787 | 7286969 | 10 | 43 | active | 0 | 2015-04-09 13:26:54 |</div><div>| 9843 | 1 | 787 | 7551210 | 10 | 43 | active | 0 | 2015-06-11 11:14:59 |</div><div>| 9844 | 1 | 787 | 7487645 | 10 | 43 | active | 0 | 2015-08-02 10:41:06 |</div><div>| 9845 | 1 | 787 | 7551235 | 10 | 43 | active | 0 | 2015-06-11 11:14:59 |</div><div>| 9846 | 1 | 787 | 7551260 | 10 | 43 | active | 0 | 2015-06-11 11:14:59 |</div><div>| 9847 | 1 | 787 | 7551300 | 10 | 43 | active | 0 | 2015-06-11 11:14:59 |</div><div>| 9850 | 1 | 787 | 9057355 | 10 | 43 | active | 0 | 2015-08-02 10:41:06 |</div><div>| 10096 | 1 | 787 | 4740636 | 10 | 43 | active | 0 | 2015-07-30 13:42:56 |</div><div>| 10097 | 1 | 787 | 4740637 | 10 | 43 | active | 0 | 2015-07-30 15:38:45 |</div><div>| 10098 | 1 | 787 | 4740638 | 10 | 43 | active | 0 | 2015-07-30 15:38:45 |</div><div>| 10099 | 1 | 787 | 4740639 | 10 | 43 | active | 0 | 2015-07-30 15:38:45 |</div><div>| 10100 | 1 | 787 | 4740640 | 10 | 43 | active | 0 | 2015-07-30 15:38:45 |</div><div>| 10101 | 1 | 787 | 4740641 | 10 | 43 | active | 0 | 2015-07-30 15:38:45 |</div><div>+-------+----+-----+---------+-------------+---------------+--------+--------+---------------------+</div></div><div><br></div><div><div>mysql> select * from provisioning.voip_dbaliases where subscriber_id=47;</div><div>+-------+-------------+-----------+---------------+------------+</div><div>| id | username | domain_id | subscriber_id | is_primary |</div><div>+-------+-------------+-----------+---------------+------------+</div><div>| 9221 | 17877052432 | 3 | 47 | 1 |</div><div>| 9222 | 17872687353 | 3 | 47 | 0 |</div><div>| 9223 | 17876524000 | 3 | 47 | 0 |</div><div>| 9224 | 17876524001 | 3 | 47 | 0 |</div><div>| 9225 | 17876524002 | 3 | 47 | 0 |</div><div>| 9226 | 17876524003 | 3 | 47 | 0 |</div><div>| 9227 | 17876524004 | 3 | 47 | 0 |</div><div>| 9228 | 17878054100 | 3 | 47 | 0 |</div><div>| 9229 | 17878346242 | 3 | 47 | 0 |</div><div>| 9230 | 17879354000 | 3 | 47 | 0 |</div><div>| 9231 | 17879354001 | 3 | 47 | 0 |</div><div>| 9232 | 17879354002 | 3 | 47 | 0 |</div><div>| 9233 | 17879354004 | 3 | 47 | 0 |</div><div>| 9234 | 17879350102 | 3 | 47 | 0 |</div><div>| 9235 | 17878492888 | 3 | 47 | 0 |</div><div>| 9236 | 17876525000 | 3 | 47 | 0 |</div><div>| 9237 | 17876525001 | 3 | 47 | 0 |</div><div>| 9238 | 17876525002 | 3 | 47 | 0 |</div><div>| 9239 | 17876525003 | 3 | 47 | 0 |</div><div>| 9240 | 17876524005 | 3 | 47 | 0 |</div><div>| 9241 | 17876524006 | 3 | 47 | 0 |</div><div>| 9242 | 17876524007 | 3 | 47 | 0 |</div><div>| 9243 | 17876524008 | 3 | 47 | 0 |</div><div>| 9244 | 17876524009 | 3 | 47 | 0 |</div><div>| 9245 | 17876525004 | 3 | 47 | 0 |</div><div>| 9246 | 17872968286 | 3 | 47 | 0 |</div><div>| 9247 | 17872968284 | 3 | 47 | 0 |</div><div>| 9254 | 17879576222 | 3 | 47 | 0 |</div><div>| 9256 | 17879667163 | 3 | 47 | 0 |</div><div>| 9257 | 17879667586 | 3 | 47 | 0 |</div><div>| 9258 | 17879667589 | 3 | 47 | 0 |</div><div>| 9259 | 17879667592 | 3 | 47 | 0 |</div><div>| 9261 | 17879619786 | 3 | 47 | 0 |</div><div>| 9262 | 17879619787 | 3 | 47 | 0 |</div><div>| 9263 | 17879619788 | 3 | 47 | 0 |</div><div>| 9264 | 17879619789 | 3 | 47 | 0 |</div><div>| 9265 | 17877109657 | 3 | 47 | 0 |</div><div>| 9266 | 17876657891 | 3 | 47 | 0 |</div><div>| 9267 | 17876657892 | 3 | 47 | 0 |</div><div>| 9268 | 17877050939 | 3 | 47 | 0 |</div><div>| 9269 | 17877050940 | 3 | 47 | 0 |</div><div>| 9270 | 17877050948 | 3 | 47 | 0 |</div><div>| 9271 | 17877086472 | 3 | 47 | 0 |</div><div>| 9272 | 17877086473 | 3 | 47 | 0 |</div><div>| 9273 | 17879455094 | 3 | 47 | 0 |</div><div>| 9274 | 17879455096 | 3 | 47 | 0 |</div><div>| 9275 | 17879455097 | 3 | 47 | 0 |</div><div>| 9276 | 17879455098 | 3 | 47 | 0 |</div><div>| 9278 | 17877052433 | 3 | 47 | 0 |</div><div>| 9280 | 17877052436 | 3 | 47 | 0 |</div><div>| 9281 | 17877052437 | 3 | 47 | 0 |</div><div>| 9282 | 17877109659 | 3 | 47 | 0 |</div><div>| 9283 | 17877109661 | 3 | 47 | 0 |</div><div>| 9284 | 17877107631 | 3 | 47 | 0 |</div><div>| 9285 | 17877107632 | 3 | 47 | 0 |</div><div>| 9286 | 17879667014 | 3 | 47 | 0 |</div><div>| 9287 | 17879667019 | 3 | 47 | 0 |</div><div>| 9288 | 17879667017 | 3 | 47 | 0 |</div><div>| 9289 | 17879667029 | 3 | 47 | 0 |</div><div>| 9290 | 17873957441 | 3 | 47 | 0 |</div><div>| 9291 | 17879619794 | 3 | 47 | 0 |</div><div>| 9292 | 17879619793 | 3 | 47 | 0 |</div><div>| 9293 | 17877057382 | 3 | 47 | 0 |</div><div>| 9294 | 17877057383 | 3 | 47 | 0 |</div><div>| 9295 | 17872667259 | 3 | 47 | 0 |</div><div>| 9785 | 17879619790 | 3 | 47 | 0 |</div><div>| 9916 | 17877650130 | 3 | 47 | 0 |</div><div>| 9917 | 17877657386 | 3 | 47 | 0 |</div><div>| 9918 | 17877729149 | 3 | 47 | 0 |</div><div>| 10116 | 17877845000 | 3 | 47 | 0 |</div><div>| 10122 | 17877845051 | 3 | 47 | 0 |</div><div>| 10147 | 17877265929 | 3 | 47 | 0 |</div><div>| 10148 | 17877286969 | 3 | 47 | 0 |</div><div>| 10227 | 17877551210 | 3 | 47 | 0 |</div><div>| 10229 | 17877551235 | 3 | 47 | 0 |</div><div>| 10230 | 17877551260 | 3 | 47 | 0 |</div><div>| 10231 | 17877551300 | 3 | 47 | 0 |</div><div>| 10505 | 17874740636 | 3 | 47 | 0 |</div><div>| 10506 | 17874740637 | 3 | 47 | 0 |</div><div>| 10507 | 17874740638 | 3 | 47 | 0 |</div><div>| 10508 | 17874740639 | 3 | 47 | 0 |</div><div>| 10509 | 17874740640 | 3 | 47 | 0 |</div><div>| 10510 | 17874740641 | 3 | 47 | 0 |</div><div>| 10524 | 17879057355 | 3 | 47 | 0 |</div><div>| 10525 | 17877487645 | 3 | 47 | 0 |</div><div>+-------+-------------+-----------+---------------+------------+</div><div>85 rows in set (0.02 sec)</div><div><br></div><div>mysql> </div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Aug 4, 2015 at 10:05 AM, Andrew Pogrebennyk <span dir="ltr"><<a href="mailto:apogrebennyk@sipwise.com" target="_blank">apogrebennyk@sipwise.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
I've encountered this issue once but was unable to find out what is<br>
causing it. Please provide the dump of all numbers from the billing and<br>
provisioning DBs:<br>
<br>
select * from provisioning.voip_dbaliases where subscriber_id=73;<br>
select * from billing.voip_numbers where subscriber_id=69;<br>
<br>
The id of subscriber in billing.voip_numbers table is the one you see in<br>
your browser's address bar when you go to subscriber details. The id in<br>
provisioning database you can figure out by alias.<br>
<br>
Please check if the two tables look in sync to you. Also, after you get<br>
the lists of numbers please specify which ones of those are missing when<br>
you get into Edit mode.<br>
<br>
Regards,<br>
Andrew<br>
<div class="HOEnZb"><div class="h5"><br>
On 08/02/2015 04:43 PM, Abel Alejandro wrote:<br>
> Hello,<br>
><br>
> We have a bug (it happens to anyone so its not a local browser issue)<br>
> when we modify a particular subscriber in order to add new extra alias,<br>
> it keeps deleting a specific set number of aliases because they do not<br>
> appear automatically when we "Edit" the subscriber. We have to manually<br>
> keep putting the numbers of existing alias on the Alias edit form so<br>
> they do not get deleted.<br>
><br>
> Any tips how to troubleshoot?<br>
<br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><span style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255);color:rgb(102,102,102)"><i><font size="4" face="'trebuchet ms', sans-serif">Abel Alejandro</font></i></span><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><blockquote style="margin:0px 0px 0px 40px;border-style:none;padding:0px"></blockquote><span style="color:rgb(51,51,51);font-family:'trebuchet ms',sans-serif">787 586 8313 </span><span style="font-family:'trebuchet ms',sans-serif"><font color="#ff6600">|</font></span><span style="color:rgb(51,51,51);font-family:'trebuchet ms',sans-serif"> 787 705 0555</span><div><a href="mailto:joquendo@alliedtechnologygrouppr.com" style="color:rgb(17,85,204)" target="_blank"></a><div><br></div><div><span style="color:rgb(102,102,102);font-family:'trebuchet ms',sans-serif">400 Calle Calaf 477</span></div><div><div style="text-align:left"><span style="color:rgb(102,102,102);font-family:'trebuchet ms',sans-serif">San Juan, PR 00918</span></div></div></div></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255);text-align:left"><a href="mailto:aalejandro@alliedtechnologygrouppr.com" target="_blank">aalejandro@alliedtechnologygrouppr.com</a></div></div></div>
</div></div>