[Spce-user] Can't create new SIP Peering Groups on MR3.2.1

[Joel S. | VOZELIA]

Hi, 

I'm adding two screenshots:
 
PrtScr-2014-10-10-005.png --> screenshot of the "loading" (the GUI stays like that forever)
PrtScr-2014-10-10-006.png --> screenshot of the error if I click on "save" without the contracts being loaded.

Any help is welcome.

BR, 
Joel.

----- Original Message -----
> From: "Joel S. | VOZELIA" <joel at vozelia.com>
> To: "Spce-user" <spce-user at lists.sipwise.com>
> Sent: Friday, October 10, 2014 12:51:05 PM
> Subject: Can't create new SIP Peering Groups on MR3.2.1
> 
> Hi,
> 
> We have a problem on mr3.2.1, when we try to create a new SIP Peering Group,
> we can't select the "Contract" as it never finishes "loading..."
> 
> I think the problem is the amount of contracts that we have... (over 100k
> customers, each with 1 subscriber):
> 
> mysql> select count(*) from billing.contracts;
> +----------+
> | count(*) |
> +----------+
> |   106769 |
> +----------+
> 1 row in set (0.01 sec)
> 
> mysql>
> 
> Should I try to create the peering group through the API? I already know my
> peering contract id is "5" so I really don't need to select it from the
> list.
> 
> If not, can I directly do an INSERT to the provisioning.voip_peer_groups
> table with peering_contract_id=5 ? Do I have to INSERT into more tables?
> 
> mysql> select name,priority,peering_contract_id from voip_peer_groups;
> +--------+----------+---------------------+
> | name   | priority | peering_contract_id |
> +--------+----------+---------------------+
> | XXXXXX |        1 |                   5 |
> | XXXXXX |        2 |                   5 |
> | XXXXXX |        4 |                   5 |
> | XXXXXX |        3 |                   5 |
> | XXXXXX |        6 |                   5 |
> +--------+----------+---------------------+
> 5 rows in set (0.00 sec)
> 
> mysql>
> 
> 
> I don't know why I cant do it though the GUI, could there be some sort of
> "loading timeout" that we are hitting and when the DB query finishes the
> webpage does not load the data?
> 
> 
> Best regards,
> Joel.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PrtScr-2014-10-10-005.png
Type: image/png
Size: 11715 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20141010/b3d5054c/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PrtScr-2014-10-10-006.png
Type: image/png
Size: 16756 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20141010/b3d5054c/attachment-0003.png>