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

Database Problem Causes BMS Device Already Exist

Publication Date:  2012-07-24 Views:  17 Downloads:  0
Issue Description
Customer told us that he tried to add two devices but an error occured: "device already exists".
The BMS is R10. We searched the technical support page, but we only found solution for BMS R07.
Alarm Information
Device already exists
Handling Process
use TopoDB
        go
        declare @devID int,@resIID int,@strDevIP varchar(32)
        select @strDevIP = 'xxx.xxx.xxx.xxx'     ------------The ip address of the equipment that cannot add in the bms
        select @resIID = iid from TopoDB..tbl_ResAttr where attrid = 1 and value = @strDevIP
        select @devID = id1 from TopoDB..tbl_Resource where iid = @resIID
        delete from TopoDB..tbl_Node where DevID = @devID
        delete from TopoDB..tbl_Resource where id1 = @devID
        go
Root Cause
There is a problem in the database
Suggestions

Null

END