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>

Reminder

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

upgrade

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

Publication Date:  2012-07-25 Views:  32 Downloads:  0
Issue Description
In U2000, two rows show the "unknown" ONT with different quantity of network element.
Alarm Information
Null
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.
Suggestions
null

END