Cannot delete devices in suspended state

[tbenton]

We are currently migrating a large number of devices with unix and when using the deleteDevice.pl I get a failure occured with the following:

Probable Cause: A database read error occurred when trying to read the device data for this device. Recommended Action: Click on the CiscoWorks Server>Diagnostics>Collect Server Information link before calling your technical support representative for assistance

Anyone seen this before and is there a fix? There are several devices which I cannot delete this way

[jsivulka]

Did you try deleting this device via the GUI. Also, did you try stopping and restaring the daemon?

[jano]

Hi, I also have this problem in CiscoWorks RWAN. I solved the problem by reinstalling Windows and reinstalling CiscoWorks.

Trying to stop and start the daemons also did not solve the problem.

[john.sobrinho]

stop start and WAIT 5 minutes or so...if that fails.. contact TAC for instructions on running the back end database reader utility.

[pvanvuuren]

I recently found a device stuck in suspend mode and here is the procedure I used to delete it. I also used this procedure to delete SWIM jobs that were stuck at one time.

Logon to CiscoWorks using your admin account.

Now type in the following URL at the the address bar:

http://[ip adress]:1741/dbreader/dbreader.html and press enter.

Login with username dba

password: c2ky2k

databse: rme

and click on the "Get Database Tables" button.

Found the table called: DEV_FQN.

In this table find the devices you need to delete and write down the corresponding Device_ID number. You need this number to delete it later.

Now click back twice to get to the initial dbreader logon screen. You will notice the username and db info is still there. Type in the password again and type the following in the SQL statement box.

Delete from DEV_FQN where Device_Id = "the number of the device"

Do not include the "".

The next screen should look like this:

SQL Statement:

Delete from DEV_FQN where Device_Id = 4893

--------------------------------------------------------------------------------

Statement Executed Successfully; Rows affected: 1

If the Rows affected is 1 then it was successfull.

Let us know.

Cheers

[arodrigue]

That SQL statement worked perfectly.

[pvanvuuren]

great to hear it. deserves a vote don't u think?

[jangeja]

I tried the url you psted by typing in http://ip_address:1741/dbreader/dbreader.html after I logged into the main page and it came up blank. What am I doing wrong? I have several devices in my database that are either in suspended or not responding that I simply can not get rid of.

[pvanvuuren]

I'm asuming your're using LMS 2.2 .

The part that says ip_address is yourCiscoworks server's IP address. example:http://10.134.1.2:1741/dbreader/dbreader.html

Suppose your Ciscoworks server is called "Jupiter". Then you would login with http://jupiter:1741 , correct? Now , after you have logged in , the URL will change slightly to http://jupiter:1741/login.html.

Now simply delete the login.hmtl part and type in dbreader/dbreader.html. So now the URL will look like this: http://jupiter:1741/dbreader/dbreader.html

Remember to login in first with your admin acount as per normal, and then type in the URL.

Also check that your proxy settings isn't confusing the browser.

Let me know.

[jangeja]

No, I totally understand to substitute my IP address. I just didnt display it as we own a class B address space and it is not being natted on this particular network. I am however using CSNMS ( CiscoWorks Small Network Management Solution 1.5) Any help is appreciated.

Thanks,

Joe

[jangeja]

No, I totally understand to substitute my IP address. I just didnt display it as we own a class B address space and it is not being natted on this particular network. I am however using CSNMS ( CiscoWorks Small Network Management Solution 1.5) Any help is appreciated.

Thanks,

Joe

[jangeja]

OK I rebooted my server and I can now get to my DB login page however, the credentials are not working that were discussed in this thread. Is there a way to change them somewhere else or is the CSNMS use different credentials?

Thanks,

Joe

[pvanvuuren]

During the initial installation of CSNMS 1.5 you were prompted for that database password: Use the same username "dba" , and enter the password you typed in when you installed CSNMS.