No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search


To have a better experience, please upgrade your IE browser.

Knowledge Base

The solution to modify serival rows of unknown ONT to one row in U2000

Publication Date:  2012-07-25  |   Views:  135  |   Downloads:  0  |   Author:  chenzhong  |   Document ID:  EKB0000572057


Issue Description

In U2000, two rows show the "unknown" ONT with different quantity of network element.

Alarm Information


Handling Process

After running the script will fix this problem:

root@bms225 # isql -Usa -Psybase -SDBSVR
1>update BMSDB..bms_cpesvc_cpeinfo set EquipmentID = null where EquipmentID =''
2> go
1>update BMSDB..bms_cpesvc_cpeinfo set Version = null where Version =''
2> go
1> quit
root@bms225 #

This bug can be fixed in V1R2C01SPC501 and later cersion, but for the existing data we only can modify it by script.

Root Cause

After checking the data in sybase, due to some value is not consistent (sometimes is null, but sometimes is empty) which is store in sybase,  two different rows will show "unknown" network element. But actually they are the same.