Client Automation - Software specified is not unique [SDM000105]
search cancel

Client Automation - Software specified is not unique [SDM000105]

book

Article ID: 45487

calendar_today

Updated On:

Products

CA Client Automation - IT Client Manager CA Client Automation

Issue/Introduction

Some SD Packages are not visible in the DSM Explorer under Software/Software Package Library/All Software.
When trying to create the package following error appears :
 
"Software specified is not unique [SDM000105]"
 

The SD package seems to be present in database, but it is not visible in DSM Explorer.

 

The following query could be used to verify whether the package is present in the database (replace value for @SW_NAME and @SW_VERSION) :

DECLARE @SW_NAME VARCHAR(255)
DECLARE @SW_VERSION VARCHAR(255)
SET @SW_NAME='TEST'
SET @SW_VERSION='60'
  
SELECT * FROM usd_rsw
WHERE itemname=@SW_NAME and itemversion=@SW_VERSION
 

Environment

Client Automation - All versions.

Resolution

There are 2 possible causes of package not being visible in the DSM Explorer:

 

- Access rights problem.

Use this query to find out the rights the user has on the package in question.

Replace @SW_NAME, @SW_VERSION and @USER_NAME with appropriate values 

 

DECLARE @SW_NAME VARCHAR(255)
DECLARE @SW_VERSION VARCHAR(255)
DECLARE @USER_NAME VARCHAR(255)
SET @SW_NAME='TEST'
SET @SW_VERSION='60'
SET @USER_NAME='%Administrator%'
 
SELECT u.label 'User Name', p.name 'Security Profile', a.ace, a.security_level
FROM ca_object_ace a, ca_security_profile p, ca_link_dis_user_sec_profile l, ca_discovered_user u
WHERE object_def_uuid=(SELECT objectid FROM usd_rsw WHERE itemname=@SW_NAME and itemversion=@SW_VERSION)
and p.security_profile_uuid=a.security_profile_uuid and p.type<100
and l.security_profile_uuid=p.security_profile_uuid and l.user_uuid=u.user_uuid
and u.label like @USER_NAME
 
 
Example :

See How to decode ace column of table ca_object_ace for explanation about column ace

User Administrator belongs to Security profile 'Everyone', 'winnt://domain_test/users' and 'winnt://domain_test/administrators'
It has :
- ace=0 : no rights on SD package "TEST 60" via Security Profile 'Everyone'
- ace=65 : Read rights on SD package "TEST 60" via Security Profile 'winnt://domain_test/users'
- ace=255 : Full Control on SD package "TEST 60" via Security Profile 'winnt://domain_test/administrators'
 
It is a Union of the rights so user Administrator has Full Control rights on SD Package "TEST 60"
 

 

- Package has lost its link with "All Software" folder

This query returns the list of packages which have no links to the "All Software" folder:

 
SELECT r.itemname, r.itemversion 
FROM usd_rsw r, usd_swfold f 
WHERE f.name='$SOFTWAREFOLDER_%ALLSW%' and r.objectid not in (SELECT sw FROM usd_link_swg_sw WHERE swg=f.objectid) 
 

If this query returns 1 or more rows, contact Broadcom Support in order to get a query to add the lost links in the database.