SMS: Group Class Is Not Re-Created After Being Deleted

CAUSE

The Inventory Dataloader does not re-create the group class in the Systems Management Server database.

You can diagnose this problem by monitoring the Datalodr.log file for activity similar to the following:

   Waiting for a MIF...
   Processing a machine...
   Requesting license for client S0100001
   CMachine::FindMachine - Searching for matching SMS Unique IDs
   Defining attributes for group GROUPTEST|MYTEST|1.0...
   CGroupMap::AddColumnToSpecificTable - couldn't add column to table
   CDefinedArchitecture::InsertDefinedAttribute - could not add column
   CGroup::DefineAttributes - couldn't defined attribute
   CGroup::DefineGroupAndAttributes - couldn't define attributes for
   GROUPTEST|MYTEST|1.0
   finished processing current machine.
   SQL problem detected, terminating the thread.
   SQL problem detected, terminating MIF processing thread.
				

The Systems Management Server Executive service caches Defined Architecture in memory. When Dataloader receives a MIF that contains a group that existed the last time the Systems Management Server Executive was initialized, it sees the table(s) defined for this group class in cache, even though it has been deleted using Database Manager. Instead of re-creating the group class, it attempts to add to it. This results in the failure noted in the log example above. The MIF is not placed in the Badmifs subdirectory.