ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Client Automation - [OSG000202] "Another computer with same MAC address is already defined"

book

Article ID: 132981

calendar_today

Updated On:

Products

CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Software Delivery

Issue/Introduction

While trying to pre-register a machine in the DSM Explorer you receive an error:

[OSG000202] "Another computer with same MAC address is already defined"



Cause

This could have multiple causes :

  • A machine had hardware change : Network Interface card, motherboard. And a new MAC address is used.
  • Machine has 2 Network interface. It was installed with OSIM using one network addrass and use a second address later for communication with its scalability server.




Environment

Release : 14.0

Component : CA Client Automation



Resolution


1- Execute following SQL Query with Microsoft SQL Server Management Studio.


use mdb


SELECT o.name 'Computer Name',h.primary_mac_address 'Primary MAC Address',

dateadd ( ss, a.creation_date + datediff(ss,getutcdate(),getdate()), convert(datetime,'19700101')) 'Creation Date',

dateadd ( ss, a.last_run_date + datediff(ss,getutcdate(),getdate()), convert(datetime,'19700101')) 'Last Execution Date',

b.name 'Boot Configuration', p2.value 'MAC Address in Boot Configuration'

FROM csm_object o, ca_discovered_hardware h, csm_link l1, csm_object b, csm_link l2, csm_object mac, csm_property p2,

ca_agent a 

WHERE o.class=102 and o.uuid=h.dis_hw_uuid and l1.parent=o.id and l1.child=b.id and b.class=1004

and b.id=l2.parent and l2.child=mac.id and mac.class=106 and mac.name='macaddress' and p2.object=mac.id and p2.name='value'

and p2.value COLLATE SQL_Latin1_General_CP1_CI_AS<>h.primary_mac_address COLLATE SQL_Latin1_General_CP1_CI_AS and

a.object_uuid=h.dis_hw_uuid

ORDER BY 1



2- If this query returns some rows, please execute this to remove the data inconsistency :


use mdb


DECLARE @BACKUP_TABLE AS VARCHAR(64)

SET @BACKUP_TABLE='csm_property_backup_'+REPLACE(CONVERT(varchar, getdate(), 23),'-','_')


IF OBJECT_ID (@BACKUP_TABLE, 'U') IS NULL EXEC('SELECT * INTO '[email protected]_TABLE+' FROM csm_property')

IF OBJECT_ID ('tempdb..#TMP_MAC', 'U') IS NOT NULL DROP TABLE #TMP_MAC 


SELECT h.primary_mac_address, p2.id

INTO #TMP_MAC 

FROM csm_object o, ca_discovered_hardware h, csm_link l1, csm_object b, csm_link l2, csm_object mac, csm_property p2

WHERE o.class=102 and o.uuid=h.dis_hw_uuid and l1.parent=o.id and l1.child=b.id and b.class=1004

and b.id=l2.parent and l2.child=mac.id and mac.class=106 and mac.name='macaddress' and p2.object=mac.id and p2.name='value'

and p2.value COLLATE SQL_Latin1_General_CP1_CI_AS<>h.primary_mac_address COLLATE SQL_Latin1_General_CP1_CI_AS


UPDATE csm_property SET value=#TMP_MAC.primary_mac_address FROM #TMP_MAC WHERE #TMP_MAC.id=csm_property.id