When trying to delete a station (computer) in DSM Explorer I get the following error:
DB error: invalid column name in select query [CMM000191]
It only happens with this computer to erase.
I followed a CA document in which I explained the possible solution, however I have not managed to get the solution.
At the moment of executing the query that I will show below (taken from the CA information) I get a single result, which is the following:
SELECT * FROM inv_table_map WHERE (tbl_owner+table_name_tree COLLATE SQL_Latin1_General_CP1_CS_AS NOT IN (SELECT u.name+o.name COLLATE SQL_Latin1_General_CP1_CS_AS FROM sysobjects o, sysusers u WHERE o.xtype='U' AND o.uid=u.uid)) OR (tbl_owner+table_name_item COLLATE SQL_Latin1_General_CP1_CS_AS NOT IN (SELECT u.name+o.name COLLATE SQL_Latin1_General_CP1_CS_AS FROM sysobjects o, sysusers u WHERE o.xtype='U' AND o.uid=u.uid))Result:
What I need to know is that I must do with this result, what action must be taken to allow the affected computer station to be erased. Thanks for your possible answers engineers.
If it only happens for this single computer, you can run this SQL to delete the agent. But if this is a trend happening with any computer you try and delete, you should open a support case so we can investigate...
declare @uuid intdeclare uid CURSOR for select dis_hw_uuid from ca_discovered_hardware where host_name='Viper17'open uidfetch next from uid into @uuidwhile @@FETCH_STATUS=0begin delete from usd_applic where target=@uuid delete from ca_group_member where member_uuid=@uuid delete from ca_link_dis_hw_user where dis_hw_uuid=@uuid delete from ca_server where dis_hw_uuid=@uuid delete from ca_agent where object_uuid=@uuid delete from ca_discovered_hardware where dis_hw_uuid=@uuidfetch next from uid into @uuidendclose uiddeallocate uid
Thanks for your answers.
Actually it only happened with a computer station, with the others eliminated without problems, I executed the query defining the hostname of the station and the expected results were seen.
Greetings from Colombia.