[Spce-user] Create subscriber - The specified telephone number is not available any more.

[Skyler]

Hey,

On Tue, Jun 12, 2012 at 2:06 PM, Daniel Tiefnig <dtiefnig at sipwise.com>wrote:

> On 06/12/2012 07:17 PM, Skyler wrote:
> > Hi,
>
> Hej.
>
> > I deleted a subscriber via the NGCP admin interface and it still
> > shows under the same account ID.
>
> Is it shown as deleted or as active? I.e. is the subscriber name an href?
>
>
 It is shown greyed out within the account it was originally created.


> > The error message when trying to re-create is: The specified
> > telephone number is not available any more.
>
> Hmm, what is the exact error message in /var/log/ngcp/oss.log?
>
>
 ***Provisioning::call_prov: billing::add_voip_account_subscriber failed:
number '16044173292' is assigned to another user (subscriber_id: 2)



> You can look at the database to see if the subscriber has not been
> deleted correctly. You should be able to find an entry with status
> "terminated" in the billing database:
>
>  select * from billing.voip_subscribers where username = '...';
>
>
  Yes it shows status 'terminated'.

mysql> select * from billing.voip_subscribers where username =
'16044173292';
+----+-------------+--------------------------------------+-------------+-----------+------------+-------------------+-------------+
| id | contract_id | uuid                                 | username    |
domain_id | status     | primary_number_id | external_id |
+----+-------------+--------------------------------------+-------------+-----------+------------+-------------------+-------------+
|  1 |           2 | 5bc847b1-9453-499c-9ff3-43c458c094ab | 16044173292 |
      1 | terminated |                 1 | 1605-1      |
+----+-------------+--------------------------------------+-------------+-----------+------------+-------------------+-------------+
1 row in set (0.00 sec)


The primary_number_id should be NULL, and you shouldn't be able to find
> any numbers assigned to the subscriber:
>
>
 No the primary_id is not NULL.


>  select * from billing.voip_numbers where subscriber_id = ...;
>
>
  mysql> select * from billing.voip_numbers where subscriber_id = '2';
+----+----+-----+---------+-------------+---------------+--------+--------+---------------------+
| id | cc | ac  | sn      | reseller_id | subscriber_id | status | ported |
list_timestamp      |
+----+----+-----+---------+-------------+---------------+--------+--------+---------------------+
|  1 |  1 | 604 | 4173292 |        NULL |             2 | active |      1 |
2012-06-10 10:47:00 |
|  2 |  1 | 778 | 3315172 |        NULL |             2 | active |      1 |
2012-06-10 10:46:37 |
+----+----+-----+---------+-------------+---------------+--------+--------+---------------------+
2 rows in set (0.00 sec)


> Also the provisioning database shouldn't have any information on the
> subscriber:
>
>  select * from provisioning.voip_subscribers where username = '...';
>
>
 correct, empty set.

mysql> select * from provisioning.voip_subscribers where username =
'16044173292';
Empty set (0.00 sec)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20120614/0dfe2286/attachment-0001.html>