ITMS 8.7 Error " Invalid object name 'ResourceTypeDataClassChanges'"

Products

• Client Management Suite

Issue/Introduction

When trying to add attentional Command Line into and existing Software Component.

After clicking Save you noticed date modified date on top right does not change.

Checking SMP log you discover

 Failed to save resource data: guid=[GUID]c, table=Inv_Software_Component

 Invalid object name 'ResourceTypeDataClassChanges'.

Cause

Missing table from SymantecCMDB indicating a possible corruption on the DB

Resolution

As one option you can just restore the class change table directly from SQL studio using query:

 

USE [Symantec_CMDB]

GO

/****** Object:  Table [dbo].[ResourceTypeDataClassChanges] ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ResourceTypeDataClassChanges](

     [_id] [bigint] IDENTITY(1,1) NOT NULL,

     [ResourceTypeGuid] [uniqueidentifier] NOT NULL,

     [ResourceDataClassGuid] [uniqueidentifier] NOT NULL,

     [Type] [nchar](1) NOT NULL,

     [ModifiedDate] [datetime] NOT NULL,

PRIMARY KEY CLUSTERED

(

     [_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[ResourceTypeDataClassChanges] ADD  DEFAULT (getdate()) FOR [ModifiedDate]

GO