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

[Joel S. | VOZELIA]

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.