Description

After deleting a node from the LDMS Console and refreshing the node pops back up into the list.

Console.exe.log:

3/7/2008 10:03:56 AM : Critical Exception: System.Runtime.InteropServices.SEHException: External component has thrown an exception.

at IDALLib.IDALRecordsetClass.DeleteDevices(String conStr, Object& pvtDevices)

Or:

Database.ExecuteDataTable: System.Data.OleDb.OleDbException: Invalid object name 'AlertRulesetDeployment'.

Key Words: Unable to Delete Nodes, Can not Delete Nodes, Cannot Delete Nodes, Unable to Delete Devices, Can not Delete Devices, Cannot Delete Devices.

Resolution

1. Stop LANDesk services

2. Backup DB

3. Run the following SQL Query:

Update metaobjattrrelations set tablename = 'UNMODELEDDATA' WHERE TABLENAME = 'ALERTRULESETDEPLOYMENT'

Run DBRepair.exe Then CoreDBUtil.exe

-DBRepair

1) Download the Correct version of DB Repair from: Community Doc DOC-2297

http://community.landesk.com/support/docs/DOC-2297

2) Copy the file to ...\LANDesk\ManagementSuite

3) Stop the LANDesk Inventory Server Service

4) Run DBRepair (DO NOT Run from a share (ldmain))

5) Click on each item except for anything under "Custom Data" and click the clean button

6) Close DBRepair

-CoreDBUtil

1) Run CoreDBUtil.exe from ...\LANDesk\ManagementSuite\

2) Click the Build Components button (This compares the database to the file Datamart.xml and makes repairs. It usually takes 5-15 minutes. DO NOT Stop the process!!!)

3) When the Build Components process finishes A Message will appear that says

4) Close CoreDBUtil

5) Start the LANDesk Inventory Server Service

DBRepair can be found here:

http://community.landesk.com/support/docs/DOC-2297

Start the LANDesk Services that had been stopped in step 1.