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

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:  119 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