[OSG000202] error with option "Use OS Installation"

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

When creating manually a new computer with option "Use OS Installation Management to setup a new operating system", following error appears :

Another computer with the same MAC adderss is already defined. [OSG000202]

Environment

Client Automation - All Versions

Cause

Same MAC Address value is already present in table csm_property for another computer.

Resolution

1. In DSM Explorer, go under Computer and Users/All Computers/{Group Details}/OS Installations :
   
   
   
2. Look for the MAC address with problem. Right click on it and select "Delete from OS Installation Management"
   
   
   
   
3. Then computer could be manually created. But if the MAC Address does not appear in the list continue with step 4
   
   
4. Check that following SQL Query returns 1 row
   
   Microsoft SQL Server :

   select * from csm_property where name='osimunknown' and object=(
   select object from csm_property where name='macaddr' and value='00:XX:XX:XX:XX:XX' and object in 
   (select id from csm_object where class=102 and dname=''))

   
   Oracle :

   select * from mdbadmin.csm_property where name='osimunknown' and object=(
   select object from mdbadmin.csm_property where name='macaddr' and value='00:XX:XX:XX:XX:XX' and object in 
   (select id from mdbadmin.csm_object where class=102 and dname='')) ;

   Replace 00:XX:XX:XX:XX:XX by the correct MAC Address to research
   
   
   
   
   
   
5. If one row is returned execute this :
   
   Microsoft SQL Server :

   update csm_property
   set object=0 
   where name='osimunknown' and object=(select object from csm_property where name='macaddr' and value='00:XX:XX:XX:XX:XX' and object in 
   (select id from csm_object where class=102 and dname=''))

   
   
   Oracle :
   

   update mdbadmin.csm_property
   set object=0 
   where name='osimunknown' and object=(select object from mdbadmin.csm_property where name='macaddr' and value='00:XX:XX:XX:XX:XX' and object in 
   (select id from mdbadmin.csm_object where class=102 and dname='')) ;

   
   
   
6. Do a refresh in DSM Explorer, go under Computer and Users/All Computers/{Group Details}/OS Installations. MAC Address appears and delete it (see step 2).

Additional Information

If this problem occurs without using option "Use OS Installation Management to setup a new operating system", see following article :

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