Discrepancy Between Local Service Management System (LSMS) and Query Server (QS)

Asset ID:	1-72-1946249.1
Update Date:	2016-11-04
Keywords:

Solution Type Problem Resolution Sure

Solution 1946249.1 : Discrepancy Between Local Service Management System (LSMS) and Query Server (QS)

Applies to:

Oracle Communications EAGLE (Hardware) - Version LSMS 12.0 and later
Information in this document applies to any platform.

Symptoms

One Telephone Number (TN) record has a discrepancy between LSMS ABC and QS XYZ for Location Routing Number (LRN), Service Provider ID (SPID) and activation timestamp.

Cause

QS record for affected TN was not updated properly during recent modification, a manual synchronization did not update the record on the QS.
Last TN time-stamp has a 7 years difference.

Solution

Manual fix on QS:

1. Login to the QS: ssh <QS_IP>
2. change to mysql binary directory: cd /opt/TKLCplat/mysql/bin
3. connect to mysql: ./mysql -u root -p
4. select affected Region DB: use <RegionDB>;
5. Retrieve affected telephone number: select * from SubscriptionVersion where tn='xxxx475598'\G
6. Retrieve old subscription version: select * from SubscriptionVersion where versionId=yyyy0166\G
7. Verify new subscription version is not in use: select * from SubscriptionVersion where versionId=zzzz17208\G
8. Update the TN with the correct data: Update LOW_PRIORITY SubscriptionVersion set versionId=zzzz17208 lrn='tttt779999' newCurrentSp='rr14' activationTimestamp='yyyymmddhhmmss' lidbDPC='ssss55002' lidbSSN='000' cnamDPC='ssss55052' lnpType=2 downloadReason=0 where tn='xxxx475598'\G
Note; letters need to be replaced with correspondent numbers
9. Verify changes: select * from SubscriptionVersion where tn='xxxx475598'\G
10. Exit from mysql: exit
11. Compare that output matches between QS and LSMS for affected TN.

Attachments

This solution has no attachment