Issue/Introduction:
When trying to delete a client computer from the Console, the computer doesn't delete and gives the error "Unable to delete Item".
'DB Table' is referencing the table found in the logs.
In the error logs: The Invalid object name 'DB Table' refers to the issue where the client cannot be deleted from the Console.
This error below references a SQL table that is missing in the database.
Process: w3wp (3812)
Thread: 13
Module: w3wp.exe
Source: Item::Delete
Description: An unexpected exception has occured (Item: {GUID.EN_US}, Exception: System.Data.SqlClient.SqlException: Invalid object name 'dbo.ResourceMerge'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Altiris.NS.DataAccessLayer.Implementation.Altiris_NS_ResourceManagement_DataAccessLayerResourceManagementDataAccessLayer.spResourceDelete(Guid Guid, Boolean IsPartitioned)
at Altiris.NS.ResourceManagement.Resource.OnDelete()
at Altiris.NS.ResourceManagement.Resource.DeletePartitionedResource())
Cause:
The reason this error occurs is because the SQL database is missing the table that is referenced in the error logs.
Resolution:
A table that is intact is needed. Follow the steps below to copy the structure of the table into the environment where the table is missing.
On a test environment: Microsoft SQL Server Management Studio, navigate to Databases > Symantec_CMDB > Tables > 'DB Table' within the Object Explorer.
1. Right click on the 'DB Table'
2. Select Script Table as > CREATE TO > New Query Window Editor
3. Copy the Query
4. Run the Query where the Database Table is missing.
This will create a table, now that the table is in the database the clients that are referencing the missing table will now delete.
Applies To
Symantec Management Platform 7.x