Oracle Communications EAGLE (Software)
 

PLA-Support>Sun Systems>CommsGBU>Global Signaling Solutions>SN-SND: Tekelec OS ELAP LSMS
 

In this Document

Symptoms

Changes

Cause

Solution

Created from <SR 3-13445674291>

Applies to:

Symptoms

NPAC has deleted a specific TN however TN was not deleted from LSMS. Customer with the specific TN cannot receive calls.

Changes

 Undetermined

Cause

There is no precise reason on why the TN wasn't removed from LSMS after being removed from NPAC. It is believed that since the deletion was done more than 45 days ago, it must be removed manually from LSMS
Remove TN from LSMS to correct the issue

Solution

Remove TN from LSMS to correct the issue

< Internal_Only > 

The following example shows how to delete a TN from LSMS. This section is marked internal only

myusql -udbroot -p
5764801

use MidwestDB;

mysql> select * from SubscriptionVersion where TN=3097941719;
+-----------+------------+------------+--------------+---------------------+-----------+----------+-----------+---------+---------+---------+-----------+---------+----------------------+---------------------+-----------+---------+----------------+----------+----------+--------+-----------------+
| versionId | tn | lrn | newCurrentSp | activationTimestamp | classDPC | classSSN | lidbDPC | lidbSSN | isvmDPC | isvmSSN | cnamDPC | cnamSSN | endUserLocationValue | endUserLocationType | billingId | lnpType | downloadReason | wsmscDPC | wsmscSSN | svType | alternativeSPID |
+-----------+------------+------------+--------------+---------------------+-----------+----------+-----------+---------+---------+---------+-----------+---------+----------------------+---------------------+-----------+---------+----------------+----------+----------+--------+-----------------+
| 227813871 | 3097941719 | 5634242999 | 846F | 20130329153211 | 238153000 | 000 | 240200240 | 000 | | | 240200240 | 000 | | | | 0 | 2 | | | -1 | |
+-----------+------------+------------+--------------+---------------------+-----------+----------+-----------+---------+---------+---------+-----------+---------+----------------------+---------------------+-----------+---------+----------------+----------+----------+--------+-----------------+
1 row in set (2.71 sec)

mysql> delete from SubscriptionVersion where TN=3097941719;
Query OK, 1 row affected (2.31 sec)

mysql> select * from SubscriptionVersion where TN=3097941719;
Empty set (2.43 sec)

mysql>

< /Internal_Only >

This solution has no attachment